public List <ENT.FurnaceSwitch> GetFurnaceSwitch(ENT.FurnaceSwitch objENT)
{
List <ENT.FurnaceSwitch> lstENT = new List <ENT.FurnaceSwitch>();
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "GetFurnaceSwitch";
sqlCMD.Parameters.AddWithValue("@fur_id", objENT.fur_id);
sqlCMD.Parameters.AddWithValue("@fur_name", objENT.fur_name);
sqlCMD.Parameters.AddWithValue("@fur_no", objENT.fur_no);
sqlCMD.Parameters.AddWithValue("@fur_status", objENT.fur_status);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
lstENT = DBHelper.GetEntityList <ENT.FurnaceSwitch>(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(lstENT);
}
public bool InsertUpdateDeleteFurnaceSwitch(ENT.FurnaceSwitch objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteFurnaceSwitch";
sqlCMD.Parameters.AddWithValue("@fur_id", objENT.fur_id);
sqlCMD.Parameters.AddWithValue("@fur_name", objENT.fur_name);
sqlCMD.Parameters.AddWithValue("@fur_no", objENT.fur_no);
sqlCMD.Parameters.AddWithValue("@fur_status", objENT.fur_status);
sqlCMD.Parameters.AddWithValue("@fur_file_time", objENT.fur_file_time);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}