//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); }