//update edited object public locationphotoClass updateObject(locationphotoClass obj) { try { locationphotoClass oldObj = selectById(obj.Locationphotoid); if (obj.Locationid == null || obj.Locationid.ToString().Trim() == "0") { obj.Locationid = oldObj.Locationid; } if (obj.Photodescription == null || obj.Photodescription.ToString().Trim() == "update") { obj.Photodescription = oldObj.Photodescription; } if (obj.Photouploadeddate == null || obj.Photouploadeddate == Convert.ToDateTime("1900-01-01")) { obj.Photouploadeddate = oldObj.Photouploadeddate; } if (obj.Buildingid == null || obj.Buildingid.ToString().Trim() == "0") { obj.Buildingid = oldObj.Buildingid; } if (obj.Buildingdeficiencyrepairid == null || obj.Buildingdeficiencyrepairid.ToString().Trim() == "0") { obj.Buildingdeficiencyrepairid = oldObj.Buildingdeficiencyrepairid; } if (obj.Buildingworkorderid == null || obj.Buildingworkorderid.ToString().Trim() == "0") { obj.Buildingworkorderid = oldObj.Buildingworkorderid; } if (obj.Workorderfollowupid == null || obj.Workorderfollowupid.ToString().Trim() == "0") { obj.Workorderfollowupid = oldObj.Workorderfollowupid; } 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(locationphotoClass obj) { try { obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_locationphoto_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Locationphotoid = Convert.ToInt32(obj_con.getValue("@Locationphotoid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_locationphoto_insert"); } }
//create parameter public void createParameter(locationphotoClass 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("@Photodescription", string.IsNullOrEmpty(Convert.ToString(obj.Photodescription)) ? "" : obj.Photodescription); obj_con.addParameter("@Photouploadeddate", string.IsNullOrEmpty(Convert.ToString(obj.Photouploadeddate)) ? Convert.ToDateTime("1900-01-01") : obj.Photouploadeddate); obj_con.addParameter("@Buildingid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingid)) ? 0 : obj.Buildingid); obj_con.addParameter("@Buildingdeficiencyrepairid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingdeficiencyrepairid)) ? 0 : obj.Buildingdeficiencyrepairid); obj_con.addParameter("@Buildingworkorderid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingworkorderid)) ? 0 : obj.Buildingworkorderid); obj_con.addParameter("@Workorderfollowupid", string.IsNullOrEmpty(Convert.ToString(obj.Workorderfollowupid)) ? 0 : obj.Workorderfollowupid); 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("@Locationphotoid", obj.Locationphotoid, trans); } catch (Exception ex) { throw ex; } }
//Select Constructor public locationphotoCtl(Int32 id) { obj_con = new ConnectionCls(); locationphotoClass obj_loc = new locationphotoClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_loc.Locationphotoid = Convert.ToInt32(dt.Rows[0]["Locationphotoid"]); obj_loc.Locationid = Convert.ToInt32(dt.Rows[0]["Locationid"]); obj_loc.Photodescription = Convert.ToString(dt.Rows[0]["Photodescription"]); obj_loc.Photouploadeddate = Convert.ToDateTime(dt.Rows[0]["Photouploadeddate"]); obj_loc.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]); obj_loc.Buildingdeficiencyrepairid = Convert.ToInt32(dt.Rows[0]["Buildingdeficiencyrepairid"]); obj_loc.Buildingworkorderid = Convert.ToInt32(dt.Rows[0]["Buildingworkorderid"]); obj_loc.Workorderfollowupid = Convert.ToInt32(dt.Rows[0]["Workorderfollowupid"]); obj_loc.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]); obj_loc.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]); } } }
//Convert DataTable To object method public locationphotoClass ConvertToOjbect(DataTable dt) { locationphotoClass obj_locationphoto = new locationphotoClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Locationphotoid"]) != "") { obj_locationphoto.Locationphotoid = Convert.ToInt32(dt.Rows[i]["Locationphotoid"]); } else { obj_locationphoto.Locationphotoid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Locationid"]) != "") { obj_locationphoto.Locationid = Convert.ToInt32(dt.Rows[i]["Locationid"]); } else { obj_locationphoto.Locationid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Photodescription"]) != "") { obj_locationphoto.Photodescription = Convert.ToString(dt.Rows[i]["Photodescription"]); } else { obj_locationphoto.Photodescription = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Photouploadeddate"]) != "") { obj_locationphoto.Photouploadeddate = Convert.ToDateTime(dt.Rows[i]["Photouploadeddate"]); } else { obj_locationphoto.Photouploadeddate = Convert.ToDateTime("01/01/1900"); } if (Convert.ToString(dt.Rows[i]["Buildingid"]) != "") { obj_locationphoto.Buildingid = Convert.ToInt32(dt.Rows[i]["Buildingid"]); } else { obj_locationphoto.Buildingid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Buildingdeficiencyrepairid"]) != "") { obj_locationphoto.Buildingdeficiencyrepairid = Convert.ToInt32(dt.Rows[i]["Buildingdeficiencyrepairid"]); } else { obj_locationphoto.Buildingdeficiencyrepairid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Buildingworkorderid"]) != "") { obj_locationphoto.Buildingworkorderid = Convert.ToInt32(dt.Rows[i]["Buildingworkorderid"]); } else { obj_locationphoto.Buildingworkorderid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Workorderfollowupid"]) != "") { obj_locationphoto.Workorderfollowupid = Convert.ToInt32(dt.Rows[i]["Workorderfollowupid"]); } else { obj_locationphoto.Workorderfollowupid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Userid"]) != "") { obj_locationphoto.Userid = Convert.ToInt32(dt.Rows[i]["Userid"]); } else { obj_locationphoto.Userid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Inserteddatetime"]) != "") { obj_locationphoto.Inserteddatetime = Convert.ToDateTime(dt.Rows[i]["Inserteddatetime"]); } else { obj_locationphoto.Inserteddatetime = Convert.ToDateTime("01/01/1900"); } } return(obj_locationphoto); }