Click here to Skip to main content
15,879,095 members
Please Sign up or sign in to vote.
1.44/5 (2 votes)
See more:
I having a problem for this error, i using MV2010 C#. when i create a new .cs file as public function to connect to .aspx.cs , it show this kind of msg.
C#
FA - material.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using FA.DAL.SystemSettings;
using FA.BLL.SystemSettings;
using System.Data;

namespace FA.SystemSettings
{
        [System.Web.Services.WebMethod(EnableSession = true)]
        public static SysMaterial OpenForm(int RecordId)//attention,this error i facing
        {
            SysMaterial sdt = new SysMaterial();//attention
            HttpContext.Current.Session[AppConstants.SESS_RECORDID] = null;
            if (sdt.Read(RecordId) > 0)
            {
                return sdt;
            }
            else
            {
                return null;
            }
        }
}


C#
FA.BLL - Material.cs
using System.Data;
using FA.DAL.CommonUtility;
using FA.DAL.SystemSettings;

namespace FA.BLL.SystemSettings
{

    public class Material
    {
        public DataTable GetMaterialList(string Code, string Name)
        {
            SysMaterial sft = new SysMaterial();

            DataTable _Material = sft.GetList(Code, Name).ToDataTable();

            return _Material;
        }
    }
}


C#
FA.DAL - SysMaterial.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using FA.DAL.CommonUtility;
using FA.DAL.DocumentTemplate;
using Microsoft.Practices.EnterpriseLibrary.Data;


namespace FA.DAL.SystemSettings
{
    public class SysMaterial
    {

        #region Properties

        private int _UserId;
        private string _IPAddress;
        private int _MenuId;

        private int _MaterialId;
        private string _MaterialCode;
        private string _MaterialDesc;
        private int _IsApproved;
        private int _IsDeleted;

        public int MaterialId
        {
            get { return _MaterialId; }
            set { _MaterialId = value; }
        }

        public string MaterialCode
        {
            get { return _MaterialCode; }
            set { _MaterialCode = value; }
        }

        public string MaterialDesc
        {
            get { return _MaterialDesc; }
            set { _MaterialDesc = value; }
        }

        public int IsApproved
        {
            get { return _IsApproved; }
            set { _IsApproved = value; }
        }

        public int IsDeleted
        {
            get { return _IsDeleted; }
            set { _IsDeleted = value; }
        }

        #endregion Properties

        public SysMaterial(int UserId, string IPAddress, int MenuId)
        {
            _UserId = UserId;
            _IPAddress = IPAddress;
            _MenuId = MenuId;
        }

        public SysMaterial()
        {
        }

        public int Read(int MaterialId)
        {
            Database db = DatabaseConnection.DatabaseConn.GetDbConnection();
            _MaterialId = -1;

            try
            {
                DbCommand dbCommand = db.GetSqlStringCommand("SELECT * FROM Sys_Material WHERE MaterialId = ?MaterialId");

                db.AddInParameter(dbCommand, "?MaterialId", DbType.Int32, MaterialId);

                using (IDataReader dr = db.ExecuteReader(dbCommand))
                {
                    if (dr.Read())
                    {
                        _MaterialId = dr.GetInt32("MaterialId");
                        _MaterialCode = dr.GetString("MaterialCode");
                        _MaterialDesc = dr.GetString("MaterialDesc");
                        _IsDeleted = dr.GetInt32("IsDeleted");
                        _IsApproved = dr.GetInt32("IsApproved");
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Read() : " + ex.Message + "; " + ex.InnerException.Message);
                }
                else
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Read() : " + ex.Message);
                }
            }
            return _MaterialId;
        }

        public int Save()
        {
            Database db = DatabaseConnection.DatabaseConn.GetDbConnection();

            try
            {
                string query = "INSERT INTO Sys_Material(MaterialCode, MaterialDesc, IsDeleted, IsApproved, CreatedDateTime, CreatedBy, CreatedIP)";
                query += " VALUES(?MaterialCode, ?MaterialDesc, ?IsDeleted, ?IsApproved, ?CreatedDateTime, ?CreatedBy, ?CreatedIP)";

                DataSet ds = new DataSet();
                DbCommand dbCommand = db.GetSqlStringCommand(query);
                db.AddInParameter(dbCommand, "?MaterialCode", DbType.String, _MaterialCode);
                db.AddInParameter(dbCommand, "?MaterialDesc", DbType.String, _MaterialDesc);
                db.AddInParameter(dbCommand, "?IsDeleted", DbType.Int32, _IsDeleted);
                db.AddInParameter(dbCommand, "?IsApproved", DbType.Int32, _IsApproved);
                db.AddInParameter(dbCommand, "?CreatedDateTime", DbType.DateTime, DateTime.Now);
                db.AddInParameter(dbCommand, "?CreatedBy", DbType.Int32, _UserId);
                db.AddInParameter(dbCommand, "?CreatedIP", DbType.String, _IPAddress);

                int retVal = db.ExecuteNonQuery(dbCommand);

                DbCommand dbCommand2 = db.GetSqlStringCommand("select last_insert_id() as NewUniqueId;");
                using (IDataReader dr = db.ExecuteReader(dbCommand2)) { }
                dbCommand2 = db.GetSqlStringCommand("select last_insert_id() as NewUniqueId;");
                using (IDataReader dr = db.ExecuteReader(dbCommand2))
                {
                    if (dr.Read())
                    {
                        retVal = dr.GetInt32("NewUniqueId");
                    }
                }
                return retVal;
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Save() : " + ex.Message + "; " + ex.InnerException.Message);
                }
                else
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Save() : " + ex.Message);
                }
                return -1;
            }
        }

        public int Update(int MaterialId)
        {
            Database db = DatabaseConnection.DatabaseConn.GetDbConnection();

            try
            {
                SysMaterial oOldSysMaterial = new SysMaterial(_UserId, _IPAddress, _MenuId);
                if (oOldSysMaterial.Read(MaterialId) == -1)
                {
                    return -1;
                }

                string query = "UPDATE Sys_Material SET ";
                query += " MaterialCode = ?MaterialCode,";
                query += " MaterialDesc = ?MaterialDesc,";
                query += " IsDeleted = ?IsDeleted,";
                query += " IsApproved = ?IsApproved,";
                query += " ModifiedDateTime = ?ModifiedDateTime,";
                query += " ModifiedBy = ?ModifiedBy,";
                query += " ModifiedIP = ?ModifiedIP";
                query += " WHERE MaterialId = ?MaterialId";

                DataSet ds = new DataSet();
                DbCommand dbCommand = db.GetSqlStringCommand(query);
                db.AddInParameter(dbCommand, "?MaterialCode", DbType.String, _MaterialCode);
                db.AddInParameter(dbCommand, "?MaterialDesc", DbType.String, _MaterialDesc);
                db.AddInParameter(dbCommand, "?IsDeleted", DbType.Int32, _IsDeleted);
                db.AddInParameter(dbCommand, "?IsApproved", DbType.Int32, _IsApproved);
                db.AddInParameter(dbCommand, "?ModifiedDateTime", DbType.DateTime, DateTime.Now);
                db.AddInParameter(dbCommand, "?ModifiedBy", DbType.Int32, _UserId);
                db.AddInParameter(dbCommand, "?ModifiedIP", DbType.String, _IPAddress);
                db.AddInParameter(dbCommand, "?MaterialId", DbType.Int32, MaterialId);

                int retVal = db.ExecuteNonQuery(dbCommand);

                if (retVal > 0)
                {
                    FA.DAL.AuthorityModule.AuthorityAuditLog AuditLog = new FA.DAL.AuthorityModule.AuthorityAuditLog();
                    AuditLog.UserId = _UserId;
                    AuditLog.IPAddress = _IPAddress;
                    AuditLog.MenuId = _MenuId;
                    AuditLog.TableName = "Sys_Material";
                    AuditLog.RecordId = _MaterialId;
                    AuditLog.TableColumn = _MaterialCode;

                    string sColumnNames = "";
                    string sOldValues = "";
                    string sNewValues = "";

                    if (oOldSysMaterial.MaterialCode != _MaterialCode)
                    {
                        sColumnNames += System.Convert.ToChar(255) + "MaterialCode";
                        sOldValues += System.Convert.ToChar(255) + oOldSysMaterial.MaterialCode.ToString();
                        sNewValues += System.Convert.ToChar(255) + _MaterialCode.ToString();
                    }
                    if (oOldSysMaterial.MaterialDesc != _MaterialDesc)
                    {
                        sColumnNames += System.Convert.ToChar(255) + "MaterialDesc";
                        sOldValues += System.Convert.ToChar(255) + oOldSysMaterial.MaterialDesc.ToString();
                        sNewValues += System.Convert.ToChar(255) + _MaterialDesc.ToString();
                    }
                    if (oOldSysMaterial.IsDeleted != _IsDeleted)
                    {
                        sColumnNames += System.Convert.ToChar(255) + "IsDeleted";
                        sOldValues += System.Convert.ToChar(255) + oOldSysMaterial.IsDeleted.ToString();
                        sNewValues += System.Convert.ToChar(255) + _IsDeleted.ToString();
                    }
                    if (oOldSysMaterial.IsApproved != _IsApproved)
                    {
                        sColumnNames += System.Convert.ToChar(255) + "IsApproved";
                        sOldValues += System.Convert.ToChar(255) + oOldSysMaterial.IsApproved.ToString();
                        sNewValues += System.Convert.ToChar(255) + _IsApproved.ToString();
                    }

                    if (sColumnNames.Length > 0)
                    {
                        AuditLog.ColumnNames = sColumnNames.Remove(0, 1);
                        AuditLog.OldValues = sOldValues.Remove(0, 1);
                        AuditLog.NewValues = sNewValues.Remove(0, 1);
                    }

                    retVal = AuditLog.Save();
                }

                return retVal;
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Update() : " + ex.Message + "; " + ex.InnerException.Message);
                }
                else
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Update() : " + ex.Message);
                }
                return -1;
            }
        }

        public int Delete()
        {
            Database db = DatabaseConnection.DatabaseConn.GetDbConnection();

            try
            {
                string query = "UPDATE Sys_Material SET IsDeleted = '1',";
                query += " DeletedDateTime = ?DeletedDateTime,";
                query += " DeletedBy = ?DeletedBy,";
                query += " DeletedIP = ?DeletedIP";
                query += " WHERE MaterialId = ?MaterialId";

                DataSet ds = new DataSet();
                DbCommand dbCommand = db.GetSqlStringCommand(query);
                db.AddInParameter(dbCommand, "?DeletedDateTime", DbType.DateTime, DateTime.Now);
                db.AddInParameter(dbCommand, "?DeletedBy", DbType.Int32, _UserId);
                db.AddInParameter(dbCommand, "?DeletedIP", DbType.String, _IPAddress);
                db.AddInParameter(dbCommand, "?MaterialId", DbType.Int32, _MaterialId);

                int retVal = db.ExecuteNonQuery(dbCommand);

                return MaterialId;
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Delete() : " + ex.Message + "; " + ex.InnerException.Message);
                }
                else
                {
                    ErrorLogging.WriteError("Class::SysMaterial-Delete() : " + ex.Message);
                }
                return -1;
            }
        }

        public List<SysMaterial> GetList(string MaterialCode = "", string MaterialDesc = "", int IsDeleted = -1, bool IncludeUnapprove = false)
        {
            Database db = DatabaseConnection.DatabaseConn.GetDbConnection();
            List<SysMaterial> lstSysMaterial = new List<SysMaterial>();

            try
            {
                string sSql = "SELECT * FROM Sys_Material WHERE IsDeleted <> '1'";
                if (IncludeUnapprove == false)
                {
                    sSql += " AND IsApproved = '1'";
                }
                if (MaterialCode != "")
                {
                    sSql += " AND MaterialCode like '%' ?MaterialCode '%'";
                }
                if (MaterialDesc != "")
                {
                    sSql += " AND MaterialDesc like '%' ?MaterialDesc '%'";
                }
                if (IsDeleted != -1)
                {
                    sSql += " AND IsDeleted = ?IsDeleted";
                }

                DbCommand dbCommand = db.GetSqlStringCommand(sSql);
                if (MaterialCode != "")
                {
                    db.AddInParameter(dbCommand, "?MaterialCode", DbType.String, MaterialCode);
                }
                if (MaterialDesc != "")
                {
                    db.AddInParameter(dbCommand, "?MaterialDesc", DbType.String, MaterialDesc);
                }
                if (IsDeleted != -1)
                {
                    db.AddInParameter(dbCommand, "?IsDeleted", DbType.Int32, IsDeleted);
                }

                using (IDataReader dr = db.ExecuteReader(dbCommand))
                {
                    while (dr.Read())
                    {
                        SysMaterial oSysMaterial = new SysMaterial(_UserId, _IPAddress, _MenuId);
                        oSysMaterial.MaterialId = dr.GetInt32("MaterialId");
                        oSysMaterial.MaterialCode = dr.GetString("MaterialCode");
                        oSysMaterial.MaterialDesc = dr.GetString("MaterialDesc");
                        oSysMaterial.IsDeleted = dr.GetInt32("IsDeleted");
                        oSysMaterial.IsApproved = dr.GetInt32("IsApproved");
                        lstSysMaterial.Add(oSysMaterial);
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    ErrorLogging.WriteError("Class::SysMaterial-GetList() : " + ex.Message + "; " + ex.InnerException.Message);
                }
                else
                {
                    ErrorLogging.WriteError("Class::SysMaterial-GetList() : " + ex.Message);
                }
            }
            return lstSysMaterial;
        }

        public int CheckExist(int MaterialId)
        {
            Database db = DatabaseConnection.DatabaseConn.GetDbConnection();
            int retVal = -1;

            try
            {
                DbCommand dbCommand = db.GetSqlStringCommand("SELECT * FROM Sys_Material WHERE MaterialId = ?MaterialId AND IsDeleted <> 1");

                db.AddInParameter(dbCommand, "?MaterialId", DbType.Int32, MaterialId);

                using (IDataReader dr = db.ExecuteReader(dbCommand))
                {
                    if (dr.Read())
                    {
                        retVal = dr.GetInt32("MaterialId");
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    ErrorLogging.WriteError("Class::SysMaterial-CheckExist() : " + ex.Message + "; " + ex.InnerException.Message);
                }
                else
                {
                    ErrorLogging.WriteError("Class::SysMaterial-CheckExist() : " + ex.Message);
                }
            }
            return retVal;
        }

        public int SaveChanges()
        {
            if (_MaterialId > 0)
            {
                if (this.CheckExist(_MaterialId) > 0)
                {
                    if (this.IsDeleted == 0)
                    {
                        return this.Update(_MaterialId);
                    }
                    else
                    {
                        return this.Save();
                    }
                }
                else
                {
                    return this.Save();
                }
            }
            else
            {
                return this.Save();
            }
        }

        /* other functions */

        public int CheckCodeExist(string Code)
        {
            Database db = DatabaseConnection.DatabaseConn.GetDbConnection();
            _MaterialId = -1;

            try
            {
                string sql = "SELECT MaterialId FROM sys_Material ";
                sql += "WHERE MaterialCode =?Code AND IsDeleted <> 1";

                DbCommand dbCommand = db.GetSqlStringCommand(sql);

                db.AddInParameter(dbCommand, "?Code", DbType.String, Code.Trim());

                using (IDataReader dr = db.ExecuteReader(dbCommand))
                {
                    if (dr.Read())
                    {
                        _MaterialId = dr.GetInt32("MaterialId");
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    ErrorLogging.WriteError("Class::SysMaterial-CheckCodeExist() : " + ex.Message + "; " + ex.InnerException.Message);
                }
                else
                {
                    ErrorLogging.WriteError("Class::SysMaterial-CheckCodeExist() : " + ex.Message);
                }
            }
            return _MaterialId;
        }

    }


}



C#
Server Error in '/' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'FA.SystemSettings.ManageMaterial'.

Source Error:


Line 1:  <%@ Page Title="Manage Material" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="ManageMaterial.aspx.cs" Inherits="FA.SystemSettings.ManageMaterial" %>
Line 2:  
Line 3:  


Source File: /SystemSettings/ManageMaterial.aspx    Line: 1

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 


sry cant post all coding, but i already post important part.
using telerik, masterpage, mvc3

error 1)
the type or namespace name SysMaterial could not be found (are you missing a using directive or an assembly reference?)

error 2)
found conflicts between different version of the same dependent assembly <-- this one just solve already, i run telerik ->open access -> option -> IntelliTrace -> enable. then restart VS2010 then run telerik ->open access ->upgrade reference

framework already is 4.0.

beside, i have search all article for adding reference, or change framework 4.0 client to framework 4.0 are not work for me.

needed your guy advice for help, thanks.
Posted
Updated 5-Aug-13 22:05pm
v6
Comments
Sergey Alexandrovich Kryukov 6-Aug-13 0:31am    
Are you serious? Not a single line of code show, and yet you want us to solve your problem. What article, for goodness sake? What are you even talking about?
—SA
_Damian S_ 6-Aug-13 2:19am    
ROFL... you asked for code!! ;-)
♥…ЯҠ…♥ 6-Aug-13 0:38am    
Above error refers to assembly that is not referenced in your application, Do onething come up with source code we'll try to come up with solution then
Sergey Alexandrovich Kryukov 6-Aug-13 0:56am    
If OP failed to realize that she/he did not really provide relevant information in first place, it's hard to expect clear answers to our questions. However, let's see...
—SA
kangyi.lee 6-Aug-13 2:21am    
actually i most for think is system problem....

1 solution

Not about coding problem, i just deleted Telerik OpenAccess Domain Context .tt file at FA.DAL and rebuild again already can run it.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900