//Convert DataTable To List method public List <LocationClass> ConvertToList(DataTable dt) { List <LocationClass> Locationlist = new List <LocationClass>(); for (int i = 0; i < dt.Rows.Count; i++) { LocationClass obj_Location = new LocationClass(); if (Convert.ToString(dt.Rows[i]["Locationid"]) != "") { obj_Location.Locationid = Convert.ToInt32(dt.Rows[i]["Locationid"]); } if (Convert.ToString(dt.Rows[i]["Locationname"]) != "") { obj_Location.Locationname = Convert.ToString(dt.Rows[i]["Locationname"]); } if (Convert.ToString(dt.Rows[i]["Locationurl"]) != "") { obj_Location.Locationurl = Convert.ToString(dt.Rows[i]["Locationurl"]); } if (Convert.ToString(dt.Rows[i]["Isactive"]) != "") { obj_Location.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]); } if (Convert.ToString(dt.Rows[i]["Isdeleted"]) != "") { obj_Location.Isdeleted = Convert.ToBoolean(dt.Rows[i]["Isdeleted"]); } if (Convert.ToString(dt.Rows[i]["Createdon"]) != "") { obj_Location.Createdon = Convert.ToDateTime(dt.Rows[i]["Createdon"]); } if (Convert.ToString(dt.Rows[i]["Deletedon"]) != "") { obj_Location.Deletedon = Convert.ToDateTime(dt.Rows[i]["Deletedon"]); } Locationlist.Add(obj_Location); } return(Locationlist); }
//insert data into database public Int32?insert(LocationClass obj) { try { obj.Locationid = 0; obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_Location_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Locationid = Convert.ToInt32(obj_con.getValue("@Locationid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_Location_insert:" + ex.Message); } }
//Select Constructor public LocationCtl(Int32?id) { obj_con = new ConnectionCls(); LocationClass obj_Loc = new LocationClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_Loc.Locationid = Convert.ToInt32(dt.Rows[0]["Locationid"]); obj_Loc.Locationname = Convert.ToString(dt.Rows[0]["Locationname"]); obj_Loc.Locationurl = Convert.ToString(dt.Rows[0]["Locationurl"]); obj_Loc.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]); obj_Loc.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]); obj_Loc.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]); obj_Loc.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]); } } }
//update edited object public LocationClass updateObject(LocationClass obj) { try { LocationClass oldObj = selectById(obj.Locationid); if (obj.Locationname == null) { obj.Locationname = oldObj.Locationname; } if (obj.Locationurl == null) { obj.Locationurl = oldObj.Locationurl; } if (obj.Isactive == null) { obj.Isactive = oldObj.Isactive; } if (obj.Isdeleted == null) { obj.Isdeleted = oldObj.Isdeleted; } if (obj.Createdon == null) { obj.Createdon = oldObj.Createdon; } if (obj.Deletedon == null) { obj.Deletedon = oldObj.Deletedon; } return(obj); } catch (Exception ex) { throw new Exception(ex.Message); } }
//create parameter public void createParameter(LocationClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); if (Convert.ToString(obj.Locationname) != "") { obj_con.addParameter("@Locationname", string.IsNullOrEmpty(Convert.ToString(obj.Locationname)) ? "" : obj.Locationname); } else { obj_con.addParameter("@Locationname", DBNull.Value); } if (Convert.ToString(obj.Locationurl) != "") { obj_con.addParameter("@Locationurl", string.IsNullOrEmpty(Convert.ToString(obj.Locationurl)) ? "" : obj.Locationurl); } else { obj_con.addParameter("@Locationurl", DBNull.Value); } if (Convert.ToString(obj.Isactive) != "") { obj_con.addParameter("@Isactive", string.IsNullOrEmpty(Convert.ToString(obj.Isactive)) ? false : obj.Isactive); } else { obj_con.addParameter("@Isactive", DBNull.Value); } if (Convert.ToString(obj.Isdeleted) != "") { obj_con.addParameter("@Isdeleted", string.IsNullOrEmpty(Convert.ToString(obj.Isdeleted)) ? false : obj.Isdeleted); } else { obj_con.addParameter("@Isdeleted", DBNull.Value); } if (Convert.ToString(obj.Createdon) != "") { obj_con.addParameter("@Createdon", string.IsNullOrEmpty(Convert.ToString(obj.Createdon)) ? Convert.ToDateTime("1900-01-01") : obj.Createdon); } else { obj_con.addParameter("@Createdon", DBNull.Value); } if (Convert.ToString(obj.Deletedon) != "") { obj_con.addParameter("@Deletedon", string.IsNullOrEmpty(Convert.ToString(obj.Deletedon)) ? Convert.ToDateTime("1900-01-01") : obj.Deletedon); } else { obj_con.addParameter("@Deletedon", DBNull.Value); } if (Convert.ToString(obj.Locationid) != "") { obj_con.addParameter("@Locationid", Convert.ToInt32(obj.Locationid), trans); } else { obj_con.addParameter("@Locationid", DBNull.Value); } } catch (Exception ex) { throw ex; } }