public static COMN_ReaultSystem GetCOMN_ReaultSystemByReaultSystemID(int ReaultSystemID)
{
COMN_ReaultSystem cOMN_ReaultSystem = new COMN_ReaultSystem();
SqlCOMN_ReaultSystemProvider sqlCOMN_ReaultSystemProvider = new SqlCOMN_ReaultSystemProvider();
cOMN_ReaultSystem = sqlCOMN_ReaultSystemProvider.GetCOMN_ReaultSystemByReaultSystemID(ReaultSystemID);
return cOMN_ReaultSystem;
}
public COMN_ReaultSystem GetCOMN_ReaultSystemFromReader(IDataReader reader)
{
try
{
COMN_ReaultSystem cOMN_ReaultSystem = new COMN_ReaultSystem
(
DataAccessObject.IsNULL<int>(reader["ReaultSystemID"]),
DataAccessObject.IsNULL<string>(reader["ReaultSystemName"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return cOMN_ReaultSystem;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateCOMN_ReaultSystem(COMN_ReaultSystem cOMN_ReaultSystem)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateCOMN_ReaultSystem", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ReaultSystemID", SqlDbType.Int).Value = cOMN_ReaultSystem.ReaultSystemID;
cmd.Parameters.Add("@ReaultSystemName", SqlDbType.NVarChar).Value = cOMN_ReaultSystem.ReaultSystemName;
cmd.Parameters.Add("@ReaultSystemName", SqlDbType.NVarChar).Value = cOMN_ReaultSystem.ReaultSystemName;
cmd.Parameters.Add("@ReaultSystemName", SqlDbType.NVarChar).Value = cOMN_ReaultSystem.ReaultSystemName;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = cOMN_ReaultSystem.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = cOMN_ReaultSystem.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertCOMN_ReaultSystem(COMN_ReaultSystem cOMN_ReaultSystem)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertCOMN_ReaultSystem", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ReaultSystemID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ReaultSystemName", SqlDbType.NVarChar).Value = cOMN_ReaultSystem.ReaultSystemName;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = cOMN_ReaultSystem.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = cOMN_ReaultSystem.AddedDate;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = cOMN_ReaultSystem.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = cOMN_ReaultSystem.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@ReaultSystemID"].Value;
}
}
public static bool UpdateCOMN_ReaultSystem(COMN_ReaultSystem cOMN_ReaultSystem)
{
SqlCOMN_ReaultSystemProvider sqlCOMN_ReaultSystemProvider = new SqlCOMN_ReaultSystemProvider();
return sqlCOMN_ReaultSystemProvider.UpdateCOMN_ReaultSystem(cOMN_ReaultSystem);
}
public static int InsertCOMN_ReaultSystem(COMN_ReaultSystem cOMN_ReaultSystem)
{
SqlCOMN_ReaultSystemProvider sqlCOMN_ReaultSystemProvider = new SqlCOMN_ReaultSystemProvider();
return sqlCOMN_ReaultSystemProvider.InsertCOMN_ReaultSystem(cOMN_ReaultSystem);
}
