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