//update edited object public buildingworkorderClass updateObject(buildingworkorderClass obj) { try { buildingworkorderClass oldObj = selectById(obj.Workorderid); if (obj.Buildingid == null || obj.Buildingid.ToString().Trim() == "0") { obj.Buildingid = oldObj.Buildingid; } if (obj.Buildingsystemid == null || obj.Buildingsystemid.ToString().Trim() == "0") { obj.Buildingsystemid = oldObj.Buildingsystemid; } if (obj.Component == null || obj.Component.ToString().Trim() == "0") { obj.Component = oldObj.Component; } if (obj.Description == null || obj.Description.ToString().Trim() == "update") { obj.Description = oldObj.Description; } if (obj.Priority == null || obj.Priority.ToString().Trim() == "update") { obj.Priority = oldObj.Priority; } if (obj.Requestor == null || obj.Requestor.ToString().Trim() == "update") { obj.Requestor = oldObj.Requestor; } 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(buildingworkorderClass obj) { try { obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_buildingworkorder_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Workorderid = Convert.ToInt32(obj_con.getValue("@Workorderid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_buildingworkorder_insert"); } }
//create parameter public void createParameter(buildingworkorderClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); obj_con.addParameter("@Buildingid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingid)) ? 0 : obj.Buildingid); obj_con.addParameter("@Buildingsystemid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingsystemid)) ? 0 : obj.Buildingsystemid); obj_con.addParameter("@Component", string.IsNullOrEmpty(Convert.ToString(obj.Component)) ? 0 : obj.Component); obj_con.addParameter("@Description", string.IsNullOrEmpty(Convert.ToString(obj.Description)) ? "" : obj.Description); obj_con.addParameter("@Priority", string.IsNullOrEmpty(Convert.ToString(obj.Priority)) ? "" : obj.Priority); obj_con.addParameter("@Requestor", string.IsNullOrEmpty(Convert.ToString(obj.Requestor)) ? "" : obj.Requestor); 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("@Workorderid", obj.Workorderid, trans); } catch (Exception ex) { throw ex; } }
//Select Constructor public buildingworkorderCtl(Int32 id) { obj_con = new ConnectionCls(); buildingworkorderClass obj_bui = new buildingworkorderClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_bui.Workorderid = Convert.ToInt32(dt.Rows[0]["Workorderid"]); obj_bui.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]); obj_bui.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]); obj_bui.Component = Convert.ToInt32(dt.Rows[0]["Component"]); obj_bui.Description = Convert.ToString(dt.Rows[0]["Description"]); obj_bui.Priority = Convert.ToString(dt.Rows[0]["Priority"]); obj_bui.Requestor = Convert.ToString(dt.Rows[0]["Requestor"]); obj_bui.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]); obj_bui.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]); } } }
//Convert DataTable To object method public buildingworkorderClass ConvertToOjbect(DataTable dt) { buildingworkorderClass obj_buildingworkorder = new buildingworkorderClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Workorderid"]) != "") { obj_buildingworkorder.Workorderid = Convert.ToInt32(dt.Rows[i]["Workorderid"]); } else { obj_buildingworkorder.Workorderid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Buildingid"]) != "") { obj_buildingworkorder.Buildingid = Convert.ToInt32(dt.Rows[i]["Buildingid"]); } else { obj_buildingworkorder.Buildingid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Buildingsystemid"]) != "") { obj_buildingworkorder.Buildingsystemid = Convert.ToInt32(dt.Rows[i]["Buildingsystemid"]); } else { obj_buildingworkorder.Buildingsystemid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Component"]) != "") { obj_buildingworkorder.Component = Convert.ToInt32(dt.Rows[i]["Component"]); } else { obj_buildingworkorder.Component = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Description"]) != "") { obj_buildingworkorder.Description = Convert.ToString(dt.Rows[i]["Description"]); } else { obj_buildingworkorder.Description = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Priority"]) != "") { obj_buildingworkorder.Priority = Convert.ToString(dt.Rows[i]["Priority"]); } else { obj_buildingworkorder.Priority = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Requestor"]) != "") { obj_buildingworkorder.Requestor = Convert.ToString(dt.Rows[i]["Requestor"]); } else { obj_buildingworkorder.Requestor = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Userid"]) != "") { obj_buildingworkorder.Userid = Convert.ToInt32(dt.Rows[i]["Userid"]); } else { obj_buildingworkorder.Userid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Inserteddatetime"]) != "") { obj_buildingworkorder.Inserteddatetime = Convert.ToDateTime(dt.Rows[i]["Inserteddatetime"]); } else { obj_buildingworkorder.Inserteddatetime = Convert.ToDateTime("01/01/1900"); } } return(obj_buildingworkorder); }