public TransactionStatus DeleteFacility(FacilityBo facilityBo)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Facility_Id", facilityBo.Facility_Id), //0
new SqlParameter("@opReturnValue", SqlDbType.Int), //1
};
Params[1].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_DeleteFacility", Params);
return(transactionStatus);
}
public TransactionStatus CreateFacility(FacilityBo facilityBo)
{
var transactionStatus = new TransactionStatus();
var facility = BuiltFacilityDomain(facilityBo);
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_AddFacility", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Facility_Name", facilityBo.Facility_Name);
cmd.Parameters.AddWithValue("@Facility_Type", facilityBo.Facility_Type);
cmd.Parameters.AddWithValue("@Facility_descr", facilityBo.Facility_descr);
cmd.Parameters.AddWithValue("@Facility_Image_dir", facilityBo.Facility_Image_dir);
cmd.Parameters.AddWithValue("@Facility_Active_flag", "true");
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
cmd.ExecuteNonQuery();
return(transactionStatus);
}
public TransactionStatus EditFacility(FacilityBo bankBo)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
var facil = BuiltFacilityDomain(bankBo);
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@Facility_Name", facil.Facility_Name), //2
new SqlParameter("@Facility_Type", facil.Facility_Type), //3
new SqlParameter("@Facility_descr", facil.Facility_descr), //4
new SqlParameter("@Facility_Image_dir", facil.Facility_Image_dir), //5
new SqlParameter("@Facility_Id", facil.Facility_Id), //5
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateFacility", Params);
return(transactionStatus);
}
private Facility BuiltFacilityDomain(FacilityBo facilityBo)
{
return((Facility) new Facility().InjectFrom(facilityBo));
}
