public static Comn_Status GetComn_StatusByID(int id)
{
Comn_Status comn_Status = new Comn_Status();
SqlComn_StatusProvider sqlComn_StatusProvider = new SqlComn_StatusProvider();
comn_Status = sqlComn_StatusProvider.GetComn_StatusByID(id);
return(comn_Status);
}
public int InsertComn_Status(Comn_Status comn_Status)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_InsertComn_Status", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_StatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Comn_StatusName", SqlDbType.NVarChar).Value = comn_Status.Comn_StatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Comn_StatusID"].Value);
}
}
public bool UpdateComn_Status(Comn_Status comn_Status)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateComn_Status", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_StatusID", SqlDbType.Int).Value = comn_Status.Comn_StatusID;
cmd.Parameters.Add("@Comn_StatusName", SqlDbType.NVarChar).Value = comn_Status.Comn_StatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Comn_Status GetComn_StatusFromReader(IDataReader reader)
{
try
{
Comn_Status comn_Status = new Comn_Status
(
(int)reader["Comn_StatusID"],
reader["Comn_StatusName"].ToString()
);
return(comn_Status);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateComn_Status(Comn_Status comn_Status)
{
SqlComn_StatusProvider sqlComn_StatusProvider = new SqlComn_StatusProvider();
return(sqlComn_StatusProvider.UpdateComn_Status(comn_Status));
}
public static int InsertComn_Status(Comn_Status comn_Status)
{
SqlComn_StatusProvider sqlComn_StatusProvider = new SqlComn_StatusProvider();
return(sqlComn_StatusProvider.InsertComn_Status(comn_Status));
}
