//create parameter public void createParameter(buildingClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); obj_con.addParameter("@Locationid", string.IsNullOrEmpty(Convert.ToString(obj.Locationid)) ? 0 : obj.Locationid); obj_con.addParameter("@Buildingcode", string.IsNullOrEmpty(Convert.ToString(obj.Buildingcode)) ? "" : obj.Buildingcode); obj_con.addParameter("@Buildingsystemid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingsystemid)) ? 0 : obj.Buildingsystemid); obj_con.addParameter("@Systemelementid", string.IsNullOrEmpty(Convert.ToString(obj.Systemelementid)) ? 0 : obj.Systemelementid); obj_con.addParameter("@Systemtypeid", string.IsNullOrEmpty(Convert.ToString(obj.Systemtypeid)) ? 0 : obj.Systemtypeid); obj_con.addParameter("@Rating", string.IsNullOrEmpty(Convert.ToString(obj.Rating)) ? 0 : obj.Rating); obj_con.addParameter("@Details", string.IsNullOrEmpty(Convert.ToString(obj.Details)) ? "" : obj.Details); obj_con.addParameter("@Isdeficiencyrepair", string.IsNullOrEmpty(Convert.ToString(obj.Isdeficiencyrepair)) ? false : obj.Isdeficiencyrepair); obj_con.addParameter("@Projectid", string.IsNullOrEmpty(Convert.ToString(obj.Projectid)) ? 0 : obj.Projectid); obj_con.addParameter("@Servicecontractid", string.IsNullOrEmpty(Convert.ToString(obj.Servicecontractid)) ? 0 : obj.Servicecontractid); obj_con.addParameter("@Workorder", string.IsNullOrEmpty(Convert.ToString(obj.Workorder)) ? "" : obj.Workorder); obj_con.addParameter("@Compliance", string.IsNullOrEmpty(Convert.ToString(obj.Compliance)) ? "" : obj.Compliance); obj_con.addParameter("@Height", string.IsNullOrEmpty(Convert.ToString(obj.Height)) ? 0 : obj.Height); obj_con.addParameter("@Width", string.IsNullOrEmpty(Convert.ToString(obj.Width)) ? 0 : obj.Width); obj_con.addParameter("@Materialid", string.IsNullOrEmpty(Convert.ToString(obj.Materialid)) ? 0 : obj.Materialid); 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("@Addressline1", string.IsNullOrEmpty(Convert.ToString(obj.Addressline1)) ? "" : obj.Addressline1); obj_con.addParameter("@Addressline2", string.IsNullOrEmpty(Convert.ToString(obj.Addressline2)) ? "" : obj.Addressline2); obj_con.addParameter("@Locationcity", string.IsNullOrEmpty(Convert.ToString(obj.Locationcity)) ? "" : obj.Locationcity); obj_con.addParameter("@Stateid", string.IsNullOrEmpty(Convert.ToString(obj.Stateid)) ? 0 : obj.Stateid); obj_con.addParameter("@Locationzip", string.IsNullOrEmpty(Convert.ToString(obj.Locationzip)) ? "" : obj.Locationzip); obj_con.addParameter("@Buildingid", obj.Buildingid, trans); } catch (Exception ex) { throw ex; } }
//Select Constructor public buildingCtl(Int32 id) { obj_con = new ConnectionCls(); buildingClass obj_bui = new buildingClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_bui.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]); obj_bui.Locationid = Convert.ToInt32(dt.Rows[0]["Locationid"]); obj_bui.Buildingcode = Convert.ToString(dt.Rows[0]["Buildingcode"]); obj_bui.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]); obj_bui.Systemelementid = Convert.ToInt32(dt.Rows[0]["Systemelementid"]); obj_bui.Systemtypeid = Convert.ToInt32(dt.Rows[0]["Systemtypeid"]); obj_bui.Rating = Convert.ToInt32(dt.Rows[0]["Rating"]); obj_bui.Details = Convert.ToString(dt.Rows[0]["Details"]); obj_bui.Isdeficiencyrepair = Convert.ToBoolean(dt.Rows[0]["Isdeficiencyrepair"]); obj_bui.Projectid = Convert.ToInt32(dt.Rows[0]["Projectid"]); obj_bui.Servicecontractid = Convert.ToInt32(dt.Rows[0]["Servicecontractid"]); obj_bui.Workorder = Convert.ToString(dt.Rows[0]["Workorder"]); obj_bui.Compliance = Convert.ToString(dt.Rows[0]["Compliance"]); obj_bui.Height = Convert.ToInt32(dt.Rows[0]["Height"]); obj_bui.Width = Convert.ToInt32(dt.Rows[0]["Width"]); obj_bui.Materialid = Convert.ToInt32(dt.Rows[0]["Materialid"]); obj_bui.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]); obj_bui.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]); obj_bui.Addressline1 = Convert.ToString(dt.Rows[0]["Addressline1"]); obj_bui.Addressline2 = Convert.ToString(dt.Rows[0]["Addressline2"]); obj_bui.Locationcity = Convert.ToString(dt.Rows[0]["Locationcity"]); obj_bui.Stateid = Convert.ToInt32(dt.Rows[0]["Stateid"]); obj_bui.Locationzip = Convert.ToString(dt.Rows[0]["Locationzip"]); } } }
//insert data into database public Int32 insert(buildingClass obj) { try { obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_building_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Buildingid = Convert.ToInt32(obj_con.getValue("@Buildingid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_building_insert"); } }
//Convert DataTable To object method public buildingClass ConvertToOjbect(DataTable dt) { buildingClass obj_building = new buildingClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Buildingid"]) != "") { obj_building.Buildingid = Convert.ToInt32(dt.Rows[i]["Buildingid"]); } else { obj_building.Buildingid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Locationid"]) != "") { obj_building.Locationid = Convert.ToInt32(dt.Rows[i]["Locationid"]); } else { obj_building.Locationid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Buildingcode"]) != "") { obj_building.Buildingcode = Convert.ToString(dt.Rows[i]["Buildingcode"]); } else { obj_building.Buildingcode = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Buildingsystemid"]) != "") { obj_building.Buildingsystemid = Convert.ToInt32(dt.Rows[i]["Buildingsystemid"]); } else { obj_building.Buildingsystemid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Systemelementid"]) != "") { obj_building.Systemelementid = Convert.ToInt32(dt.Rows[i]["Systemelementid"]); } else { obj_building.Systemelementid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Systemtypeid"]) != "") { obj_building.Systemtypeid = Convert.ToInt32(dt.Rows[i]["Systemtypeid"]); } else { obj_building.Systemtypeid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Rating"]) != "") { obj_building.Rating = Convert.ToInt32(dt.Rows[i]["Rating"]); } else { obj_building.Rating = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Details"]) != "") { obj_building.Details = Convert.ToString(dt.Rows[i]["Details"]); } else { obj_building.Details = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Isdeficiencyrepair"]) != "") { obj_building.Isdeficiencyrepair = Convert.ToBoolean(dt.Rows[i]["Isdeficiencyrepair"]); } else { obj_building.Isdeficiencyrepair = Convert.ToBoolean(0); } if (Convert.ToString(dt.Rows[i]["Projectid"]) != "") { obj_building.Projectid = Convert.ToInt32(dt.Rows[i]["Projectid"]); } else { obj_building.Projectid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Servicecontractid"]) != "") { obj_building.Servicecontractid = Convert.ToInt32(dt.Rows[i]["Servicecontractid"]); } else { obj_building.Servicecontractid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Workorder"]) != "") { obj_building.Workorder = Convert.ToString(dt.Rows[i]["Workorder"]); } else { obj_building.Workorder = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Compliance"]) != "") { obj_building.Compliance = Convert.ToString(dt.Rows[i]["Compliance"]); } else { obj_building.Compliance = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Height"]) != "") { obj_building.Height = Convert.ToInt32(dt.Rows[i]["Height"]); } else { obj_building.Height = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Width"]) != "") { obj_building.Width = Convert.ToInt32(dt.Rows[i]["Width"]); } else { obj_building.Width = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Materialid"]) != "") { obj_building.Materialid = Convert.ToInt32(dt.Rows[i]["Materialid"]); } else { obj_building.Materialid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Userid"]) != "") { obj_building.Userid = Convert.ToInt32(dt.Rows[i]["Userid"]); } else { obj_building.Userid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Inserteddatetime"]) != "") { obj_building.Inserteddatetime = Convert.ToDateTime(dt.Rows[i]["Inserteddatetime"]); } else { obj_building.Inserteddatetime = Convert.ToDateTime("01/01/1900"); } if (Convert.ToString(dt.Rows[i]["Addressline1"]) != "") { obj_building.Addressline1 = Convert.ToString(dt.Rows[i]["Addressline1"]); } else { obj_building.Addressline1 = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Addressline2"]) != "") { obj_building.Addressline2 = Convert.ToString(dt.Rows[i]["Addressline2"]); } else { obj_building.Addressline2 = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Locationcity"]) != "") { obj_building.Locationcity = Convert.ToString(dt.Rows[i]["Locationcity"]); } else { obj_building.Locationcity = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Stateid"]) != "") { obj_building.Stateid = Convert.ToInt32(dt.Rows[i]["Stateid"]); } else { obj_building.Stateid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Locationzip"]) != "") { obj_building.Locationzip = Convert.ToString(dt.Rows[i]["Locationzip"]); } else { obj_building.Locationzip = Convert.ToString(""); } } return(obj_building); }
//update edited object public buildingClass updateObject(buildingClass obj) { try { buildingClass oldObj = selectById(obj.Buildingid); if (obj.Locationid == null || obj.Locationid.ToString().Trim() == "0") { obj.Locationid = oldObj.Locationid; } if (obj.Buildingcode == null || obj.Buildingcode.ToString().Trim() == "update") { obj.Buildingcode = oldObj.Buildingcode; } if (obj.Buildingsystemid == null || obj.Buildingsystemid.ToString().Trim() == "0") { obj.Buildingsystemid = oldObj.Buildingsystemid; } if (obj.Systemelementid == null || obj.Systemelementid.ToString().Trim() == "0") { obj.Systemelementid = oldObj.Systemelementid; } if (obj.Systemtypeid == null || obj.Systemtypeid.ToString().Trim() == "0") { obj.Systemtypeid = oldObj.Systemtypeid; } if (obj.Rating == null || obj.Rating.ToString().Trim() == "0") { obj.Rating = oldObj.Rating; } if (obj.Details == null || obj.Details.ToString().Trim() == "update") { obj.Details = oldObj.Details; } if (obj.Isdeficiencyrepair == null || obj.Isdeficiencyrepair.ToString().Trim() == "0") { obj.Isdeficiencyrepair = oldObj.Isdeficiencyrepair; } if (obj.Projectid == null || obj.Projectid.ToString().Trim() == "0") { obj.Projectid = oldObj.Projectid; } if (obj.Servicecontractid == null || obj.Servicecontractid.ToString().Trim() == "0") { obj.Servicecontractid = oldObj.Servicecontractid; } if (obj.Workorder == null || obj.Workorder.ToString().Trim() == "update") { obj.Workorder = oldObj.Workorder; } if (obj.Compliance == null || obj.Compliance.ToString().Trim() == "update") { obj.Compliance = oldObj.Compliance; } if (obj.Height == null || obj.Height.ToString().Trim() == "0") { obj.Height = oldObj.Height; } if (obj.Width == null || obj.Width.ToString().Trim() == "0") { obj.Width = oldObj.Width; } if (obj.Materialid == null || obj.Materialid.ToString().Trim() == "0") { obj.Materialid = oldObj.Materialid; } 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; } if (obj.Addressline1 == null || obj.Addressline1.ToString().Trim() == "update") { obj.Addressline1 = oldObj.Addressline1; } if (obj.Addressline2 == null || obj.Addressline2.ToString().Trim() == "update") { obj.Addressline2 = oldObj.Addressline2; } if (obj.Locationcity == null || obj.Locationcity.ToString().Trim() == "update") { obj.Locationcity = oldObj.Locationcity; } if (obj.Stateid == null || obj.Stateid.ToString().Trim() == "0") { obj.Stateid = oldObj.Stateid; } if (obj.Locationzip == null || obj.Locationzip.ToString().Trim() == "update") { obj.Locationzip = oldObj.Locationzip; } return(obj); } catch (Exception ex) { throw new Exception(ex.Message); } }