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.
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)
{
SysMaterial sdt = new SysMaterial();
HttpContext.Current.Session[AppConstants.SESS_RECORDID] = null;
if (sdt.Read(RecordId) > 0)
{
return sdt;
}
else
{
return null;
}
}
}
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;
}
}
}
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();
}
}
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;
}
}
}
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.