//Convert DataTable To object method public systemelementClass ConvertToOjbect(DataTable dt) { systemelementClass obj_systemelement = new systemelementClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Systemelementid"]) != "") { obj_systemelement.Systemelementid = Convert.ToInt32(dt.Rows[i]["Systemelementid"]); } else { obj_systemelement.Systemelementid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Buildingsystemid"]) != "") { obj_systemelement.Buildingsystemid = Convert.ToInt32(dt.Rows[i]["Buildingsystemid"]); } else { obj_systemelement.Buildingsystemid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Systemelementname"]) != "") { obj_systemelement.Systemelementname = Convert.ToString(dt.Rows[i]["Systemelementname"]); } else { obj_systemelement.Systemelementname = Convert.ToString(""); } } return(obj_systemelement); }
//create parameter public void createParameter(systemelementClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); obj_con.addParameter("@Buildingsystemid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingsystemid)) ? 0 : obj.Buildingsystemid); obj_con.addParameter("@Systemelementname", string.IsNullOrEmpty(Convert.ToString(obj.Systemelementname)) ? "" : obj.Systemelementname); obj_con.addParameter("@Systemelementid", obj.Systemelementid, trans); } catch (Exception ex) { throw ex; } }
//Select Constructor public systemelementCtl(Int32 id) { obj_con = new ConnectionCls(); systemelementClass obj_sys = new systemelementClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_sys.Systemelementid = Convert.ToInt32(dt.Rows[0]["Systemelementid"]); obj_sys.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]); obj_sys.Systemelementname = Convert.ToString(dt.Rows[0]["Systemelementname"]); } } }
//insert data into database public Int32 insert(systemelementClass obj) { try { obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_systemelement_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Systemelementid = Convert.ToInt32(obj_con.getValue("@Systemelementid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_systemelement_insert"); } }
//Convert DataTable To List method public List <systemelementClass> ConvertToList(DataTable dt) { List <systemelementClass> systemelementlist = new List <systemelementClass>(); for (int i = 0; i < dt.Rows.Count; i++) { systemelementClass obj_systemelement = new systemelementClass(); if (Convert.ToString(dt.Rows[i]["Systemelementid"]) != "") { obj_systemelement.Systemelementid = Convert.ToInt32(dt.Rows[i]["Systemelementid"]); } else { obj_systemelement.Systemelementid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Buildingsystemid"]) != "") { obj_systemelement.Buildingsystemid = Convert.ToInt32(dt.Rows[i]["Buildingsystemid"]); } else { obj_systemelement.Buildingsystemid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Systemelementname"]) != "") { obj_systemelement.Systemelementname = Convert.ToString(dt.Rows[i]["Systemelementname"]); } else { obj_systemelement.Systemelementname = Convert.ToString(""); } systemelementlist.Add(obj_systemelement); } return(systemelementlist); }
//update edited object public systemelementClass updateObject(systemelementClass obj) { try { systemelementClass oldObj = selectById(obj.Systemelementid); if (obj.Buildingsystemid == null || obj.Buildingsystemid.ToString().Trim() == "0") { obj.Buildingsystemid = oldObj.Buildingsystemid; } if (obj.Systemelementname == null || obj.Systemelementname.ToString().Trim() == "update") { obj.Systemelementname = oldObj.Systemelementname; } return(obj); } catch (Exception ex) { throw new Exception(ex.Message); } }