//Convert DataTable To object method public BusinessGalleryClass ConvertToOjbect(DataTable dt) { BusinessGalleryClass obj_BusinessGallery = new BusinessGalleryClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Businessgalleryid"]) != "") { obj_BusinessGallery.Businessgalleryid = Convert.ToInt32(dt.Rows[i]["Businessgalleryid"]); } if (Convert.ToString(dt.Rows[i]["Businessid"]) != "") { obj_BusinessGallery.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]); } if (Convert.ToString(dt.Rows[i]["Imagename"]) != "") { obj_BusinessGallery.Imagename = Convert.ToString(dt.Rows[i]["Imagename"]); } if (Convert.ToString(dt.Rows[i]["Isactive"]) != "") { obj_BusinessGallery.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]); } if (Convert.ToString(dt.Rows[i]["Sequence"]) != "") { obj_BusinessGallery.Sequence = Convert.ToInt32(dt.Rows[i]["Sequence"]); } } return(obj_BusinessGallery); }
//update edited object public BusinessGalleryClass updateObject(BusinessGalleryClass obj) { try { BusinessGalleryClass oldObj = selectById(obj.Businessgalleryid); if (obj.Businessid == null) { obj.Businessid = oldObj.Businessid; } if (obj.Imagename == null) { obj.Imagename = oldObj.Imagename; } if (obj.Isactive == null) { obj.Isactive = oldObj.Isactive; } if (obj.Sequence == null) { obj.Sequence = oldObj.Sequence; } return(obj); } catch (Exception ex) { throw new Exception(ex.Message); } }
//create parameter public void createParameter(BusinessGalleryClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); if (Convert.ToString(obj.Businessid) != "") { obj_con.addParameter("@Businessid", string.IsNullOrEmpty(Convert.ToString(obj.Businessid)) ? 0 : obj.Businessid); } else { obj_con.addParameter("@Businessid", DBNull.Value); } if (Convert.ToString(obj.Imagename) != "") { obj_con.addParameter("@Imagename", string.IsNullOrEmpty(Convert.ToString(obj.Imagename)) ? "" : obj.Imagename); } else { obj_con.addParameter("@Imagename", 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.Sequence) != "") { obj_con.addParameter("@Sequence", string.IsNullOrEmpty(Convert.ToString(obj.Sequence)) ? 0 : obj.Sequence); } else { obj_con.addParameter("@Sequence", DBNull.Value); } if (Convert.ToString(obj.Businessgalleryid) != "") { obj_con.addParameter("@Businessgalleryid", Convert.ToInt32(obj.Businessgalleryid), trans); } else { obj_con.addParameter("@Businessgalleryid", DBNull.Value); } } catch (Exception ex) { throw ex; } }
//Select Constructor public BusinessGalleryCtl(Int32?id) { obj_con = new ConnectionCls(); BusinessGalleryClass obj_Bus = new BusinessGalleryClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_Bus.Businessgalleryid = Convert.ToInt32(dt.Rows[0]["Businessgalleryid"]); obj_Bus.Businessid = Convert.ToInt32(dt.Rows[0]["Businessid"]); obj_Bus.Imagename = Convert.ToString(dt.Rows[0]["Imagename"]); obj_Bus.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]); obj_Bus.Sequence = Convert.ToInt32(dt.Rows[0]["Sequence"]); } } }
//insert data into database public Int32?insert(BusinessGalleryClass obj) { try { obj.Businessgalleryid = 0; obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_BusinessGallery_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Businessgalleryid = Convert.ToInt32(obj_con.getValue("@Businessgalleryid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_BusinessGallery_insert:" + ex.Message); } }
//Convert DataTable To List method public List <BusinessGalleryClass> ConvertToList(DataTable dt) { List <BusinessGalleryClass> BusinessGallerylist = new List <BusinessGalleryClass>(); for (int i = 0; i < dt.Rows.Count; i++) { BusinessGalleryClass obj_BusinessGallery = new BusinessGalleryClass(); if (Convert.ToString(dt.Rows[i]["Businessgalleryid"]) != "") { obj_BusinessGallery.Businessgalleryid = Convert.ToInt32(dt.Rows[i]["Businessgalleryid"]); } if (Convert.ToString(dt.Rows[i]["Businessid"]) != "") { obj_BusinessGallery.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]); } if (Convert.ToString(dt.Rows[i]["Imagename"]) != "") { obj_BusinessGallery.Imagename = Convert.ToString(dt.Rows[i]["Imagename"]); } if (Convert.ToString(dt.Rows[i]["Isactive"]) != "") { obj_BusinessGallery.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]); } if (Convert.ToString(dt.Rows[i]["Sequence"]) != "") { obj_BusinessGallery.Sequence = Convert.ToInt32(dt.Rows[i]["Sequence"]); } BusinessGallerylist.Add(obj_BusinessGallery); } return(BusinessGallerylist); }