//update edited object
public workorderfollowupClass updateObject(workorderfollowupClass obj)
{
try
{
workorderfollowupClass oldObj = selectById(obj.Workorderfollowupid);
if (obj.Workorderid == null || obj.Workorderid.ToString().Trim() == "0")
{
obj.Workorderid = oldObj.Workorderid;
}
if (obj.Datecompleted == null || obj.Datecompleted == Convert.ToDateTime("1900-01-01"))
{
obj.Datecompleted = oldObj.Datecompleted;
}
if (obj.Labour == null || obj.Labour.ToString().Trim() == "0")
{
obj.Labour = oldObj.Labour;
}
if (obj.Partssuppies == null || obj.Partssuppies.ToString().Trim() == "update")
{
obj.Partssuppies = oldObj.Partssuppies;
}
if (obj.Note == null || obj.Note.ToString().Trim() == "update")
{
obj.Note = oldObj.Note;
}
if (obj.Userid == null || obj.Userid.ToString().Trim() == "0")
{
obj.Userid = oldObj.Userid;
}
if (obj.Inserteddatetime == null || obj.Inserteddatetime == Convert.ToDateTime("1900-01-01"))
{
obj.Inserteddatetime = oldObj.Inserteddatetime;
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//insert data into database
public Int32 insert(workorderfollowupClass obj)
{
try
{
obj_con.clearParameter();
createParameter(obj, DBTrans.Insert);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_workorderfollowup_insert", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Workorderfollowupid = Convert.ToInt32(obj_con.getValue("@Workorderfollowupid")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_workorderfollowup_insert");
}
}
//create parameter
public void createParameter(workorderfollowupClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
obj_con.addParameter("@Workorderid", string.IsNullOrEmpty(Convert.ToString(obj.Workorderid)) ? 0 : obj.Workorderid);
obj_con.addParameter("@Datecompleted", string.IsNullOrEmpty(Convert.ToString(obj.Datecompleted)) ? Convert.ToDateTime("1900-01-01") : obj.Datecompleted);
obj_con.addParameter("@Labour", string.IsNullOrEmpty(Convert.ToString(obj.Labour)) ? 0 : obj.Labour);
obj_con.addParameter("@Partssuppies", string.IsNullOrEmpty(Convert.ToString(obj.Partssuppies)) ? "" : obj.Partssuppies);
obj_con.addParameter("@Note", string.IsNullOrEmpty(Convert.ToString(obj.Note)) ? "" : obj.Note);
obj_con.addParameter("@Userid", string.IsNullOrEmpty(Convert.ToString(obj.Userid)) ? 0 : obj.Userid);
obj_con.addParameter("@Inserteddatetime", string.IsNullOrEmpty(Convert.ToString(obj.Inserteddatetime)) ? Convert.ToDateTime("1900-01-01") : obj.Inserteddatetime);
obj_con.addParameter("@Workorderfollowupid", obj.Workorderfollowupid, trans);
}
catch (Exception ex)
{
throw ex;
}
}
//Select Constructor
public workorderfollowupCtl(Int32 id)
{
obj_con = new ConnectionCls();
workorderfollowupClass obj_wor = new workorderfollowupClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_wor.Workorderfollowupid = Convert.ToInt32(dt.Rows[0]["Workorderfollowupid"]);
obj_wor.Workorderid = Convert.ToInt32(dt.Rows[0]["Workorderid"]);
obj_wor.Datecompleted = Convert.ToDateTime(dt.Rows[0]["Datecompleted"]);
obj_wor.Labour = Convert.ToInt32(dt.Rows[0]["Labour"]);
obj_wor.Partssuppies = Convert.ToString(dt.Rows[0]["Partssuppies"]);
obj_wor.Note = Convert.ToString(dt.Rows[0]["Note"]);
obj_wor.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_wor.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
//Convert DataTable To object method
public workorderfollowupClass ConvertToOjbect(DataTable dt)
{
workorderfollowupClass obj_workorderfollowup = new workorderfollowupClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToString(dt.Rows[i]["Workorderfollowupid"]) != "")
{
obj_workorderfollowup.Workorderfollowupid = Convert.ToInt32(dt.Rows[i]["Workorderfollowupid"]);
}
else
{
obj_workorderfollowup.Workorderfollowupid = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Workorderid"]) != "")
{
obj_workorderfollowup.Workorderid = Convert.ToInt32(dt.Rows[i]["Workorderid"]);
}
else
{
obj_workorderfollowup.Workorderid = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Datecompleted"]) != "")
{
obj_workorderfollowup.Datecompleted = Convert.ToDateTime(dt.Rows[i]["Datecompleted"]);
}
else
{
obj_workorderfollowup.Datecompleted = Convert.ToDateTime("01/01/1900");
}
if (Convert.ToString(dt.Rows[i]["Labour"]) != "")
{
obj_workorderfollowup.Labour = Convert.ToInt32(dt.Rows[i]["Labour"]);
}
else
{
obj_workorderfollowup.Labour = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Partssuppies"]) != "")
{
obj_workorderfollowup.Partssuppies = Convert.ToString(dt.Rows[i]["Partssuppies"]);
}
else
{
obj_workorderfollowup.Partssuppies = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Note"]) != "")
{
obj_workorderfollowup.Note = Convert.ToString(dt.Rows[i]["Note"]);
}
else
{
obj_workorderfollowup.Note = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Userid"]) != "")
{
obj_workorderfollowup.Userid = Convert.ToInt32(dt.Rows[i]["Userid"]);
}
else
{
obj_workorderfollowup.Userid = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Inserteddatetime"]) != "")
{
obj_workorderfollowup.Inserteddatetime = Convert.ToDateTime(dt.Rows[i]["Inserteddatetime"]);
}
else
{
obj_workorderfollowup.Inserteddatetime = Convert.ToDateTime("01/01/1900");
}
}
return(obj_workorderfollowup);
}
