//update data into database
public Int32?update(BusinessDirectoryClass obj)
{
try
{
obj_con.clearParameter();
obj = updateObject(obj);
createParameter(obj, DBTrans.Update);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_BusinessDirectory_update", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Businessid = Convert.ToInt32(obj_con.getValue("@Businessid")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_BusinessDirectory_update:" + ex.Message);
}
}
//Select Constructor
public BusinessDirectoryCtl(Int32?id)
{
obj_con = new ConnectionCls();
BusinessDirectoryClass obj_Bus = new BusinessDirectoryClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Bus.Businessid = Convert.ToInt32(dt.Rows[0]["Businessid"]);
obj_Bus.Businessname = Convert.ToString(dt.Rows[0]["Businessname"]);
obj_Bus.Website = Convert.ToString(dt.Rows[0]["Website"]);
obj_Bus.Businessurl = Convert.ToString(dt.Rows[0]["Businessurl"]);
obj_Bus.Phonenumber = Convert.ToString(dt.Rows[0]["Phonenumber"]);
obj_Bus.Businessimage = Convert.ToString(dt.Rows[0]["Businessimage"]);
obj_Bus.Locationid = Convert.ToInt32(dt.Rows[0]["Locationid"]);
obj_Bus.Address = Convert.ToString(dt.Rows[0]["Address"]);
obj_Bus.Addressline2 = Convert.ToString(dt.Rows[0]["Addressline2"]);
obj_Bus.City = Convert.ToString(dt.Rows[0]["City"]);
obj_Bus.State = Convert.ToString(dt.Rows[0]["State"]);
obj_Bus.Zipcode = Convert.ToString(dt.Rows[0]["Zipcode"]);
obj_Bus.Locationlatitude = Convert.ToString(dt.Rows[0]["Locationlatitude"]);
obj_Bus.Locationlongitude = Convert.ToString(dt.Rows[0]["Locationlongitude"]);
obj_Bus.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Bus.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
obj_Bus.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]);
obj_Bus.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]);
obj_Bus.Phonenumber2 = Convert.ToString(dt.Rows[0]["Phonenumber2"]);
obj_Bus.Email = Convert.ToString(dt.Rows[0]["Email"]);
obj_Bus.HasBrochure = Convert.ToBoolean(dt.Rows[0]["HasBrochure"]);
obj_Bus.IsFeatured = Convert.ToBoolean(dt.Rows[0]["IsFeatured"]);
obj_Bus.BusinessVideoURL = Convert.ToString(dt.Rows[0]["BusinessVideoURL"]);
obj_Bus.BusinessLogo = Convert.ToString(dt.Rows[0]["BusinessLogo"]);
}
}
}
//Convert DataTable To object method
public BusinessDirectoryClass ConvertToOjbect(DataTable dt)
{
BusinessDirectoryClass obj_BusinessDirectory = new BusinessDirectoryClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToString(dt.Rows[i]["Businessid"]) != "")
{
obj_BusinessDirectory.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]);
}
if (Convert.ToString(dt.Rows[i]["Businessname"]) != "")
{
obj_BusinessDirectory.Businessname = Convert.ToString(dt.Rows[i]["Businessname"]);
}
if (Convert.ToString(dt.Rows[i]["Website"]) != "")
{
obj_BusinessDirectory.Website = Convert.ToString(dt.Rows[i]["Website"]);
}
if (Convert.ToString(dt.Rows[i]["Businessurl"]) != "")
{
obj_BusinessDirectory.Businessurl = Convert.ToString(dt.Rows[i]["Businessurl"]);
}
if (Convert.ToString(dt.Rows[i]["Phonenumber"]) != "")
{
obj_BusinessDirectory.Phonenumber = Convert.ToString(dt.Rows[i]["Phonenumber"]);
}
if (Convert.ToString(dt.Rows[i]["Businessimage"]) != "")
{
obj_BusinessDirectory.Businessimage = Convert.ToString(dt.Rows[i]["Businessimage"]);
}
if (Convert.ToString(dt.Rows[i]["Locationid"]) != "")
{
obj_BusinessDirectory.Locationid = Convert.ToInt32(dt.Rows[i]["Locationid"]);
}
if (Convert.ToString(dt.Rows[i]["Address"]) != "")
{
obj_BusinessDirectory.Address = Convert.ToString(dt.Rows[i]["Address"]);
}
if (Convert.ToString(dt.Rows[i]["Addressline2"]) != "")
{
obj_BusinessDirectory.Addressline2 = Convert.ToString(dt.Rows[i]["Addressline2"]);
}
if (Convert.ToString(dt.Rows[i]["City"]) != "")
{
obj_BusinessDirectory.City = Convert.ToString(dt.Rows[i]["City"]);
}
if (Convert.ToString(dt.Rows[i]["State"]) != "")
{
obj_BusinessDirectory.State = Convert.ToString(dt.Rows[i]["State"]);
}
if (Convert.ToString(dt.Rows[i]["Zipcode"]) != "")
{
obj_BusinessDirectory.Zipcode = Convert.ToString(dt.Rows[i]["Zipcode"]);
}
if (Convert.ToString(dt.Rows[i]["Locationlatitude"]) != "")
{
obj_BusinessDirectory.Locationlatitude = Convert.ToString(dt.Rows[i]["Locationlatitude"]);
}
if (Convert.ToString(dt.Rows[i]["Locationlongitude"]) != "")
{
obj_BusinessDirectory.Locationlongitude = Convert.ToString(dt.Rows[i]["Locationlongitude"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_BusinessDirectory.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Isdeleted"]) != "")
{
obj_BusinessDirectory.Isdeleted = Convert.ToBoolean(dt.Rows[i]["Isdeleted"]);
}
if (Convert.ToString(dt.Rows[i]["Createdon"]) != "")
{
obj_BusinessDirectory.Createdon = Convert.ToDateTime(dt.Rows[i]["Createdon"]);
}
if (Convert.ToString(dt.Rows[i]["Deletedon"]) != "")
{
obj_BusinessDirectory.Deletedon = Convert.ToDateTime(dt.Rows[i]["Deletedon"]);
}
if (Convert.ToString(dt.Rows[i]["PhoneNumber2"]) != "")
{
obj_BusinessDirectory.Phonenumber2 = Convert.ToString(dt.Rows[i]["PhoneNumber2"]);
}
if (Convert.ToString(dt.Rows[i]["Email"]) != "")
{
obj_BusinessDirectory.Email = Convert.ToString(dt.Rows[i]["Email"]);
}
if (Convert.ToString(dt.Rows[i]["HasBrochure"]) != "")
{
obj_BusinessDirectory.HasBrochure = Convert.ToBoolean(dt.Rows[i]["HasBrochure"]);
}
if (Convert.ToString(dt.Rows[i]["IsFeatured"]) != "")
{
obj_BusinessDirectory.IsFeatured = Convert.ToBoolean(dt.Rows[i]["IsFeatured"]);
}
if (Convert.ToString(dt.Rows[i]["BusinessVideoURL"]) != "")
{
obj_BusinessDirectory.BusinessVideoURL = Convert.ToString(dt.Rows[i]["BusinessVideoURL"]);
}
if (Convert.ToString(dt.Rows[i]["CategoryId"]) != "")
{
obj_BusinessDirectory.CategoryIdWithComma = Convert.ToString(dt.Rows[i]["CategoryId"]).Replace(" ", "").Trim();
}
if (Convert.ToString(dt.Rows[i]["BusinessLogo"]) != "")
{
obj_BusinessDirectory.BusinessLogo = Convert.ToString(dt.Rows[i]["BusinessLogo"]);
}
}
return(obj_BusinessDirectory);
}
//Convert DataTable To List method
public List <BusinessDirectoryClass> ConvertToList(DataTable dt)
{
List <BusinessDirectoryClass> BusinessDirectorylist = new List <BusinessDirectoryClass>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BusinessDirectoryClass obj_BusinessDirectory = new BusinessDirectoryClass();
if (Convert.ToString(dt.Rows[i]["Businessid"]) != "")
{
obj_BusinessDirectory.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]);
}
if (Convert.ToString(dt.Rows[i]["Businessname"]) != "")
{
obj_BusinessDirectory.Businessname = Convert.ToString(dt.Rows[i]["Businessname"]);
}
if (Convert.ToString(dt.Rows[i]["Website"]) != "")
{
obj_BusinessDirectory.Website = Convert.ToString(dt.Rows[i]["Website"]);
}
if (Convert.ToString(dt.Rows[i]["Businessurl"]) != "")
{
obj_BusinessDirectory.Businessurl = Convert.ToString(dt.Rows[i]["Businessurl"]);
}
if (Convert.ToString(dt.Rows[i]["Phonenumber"]) != "")
{
obj_BusinessDirectory.Phonenumber = Convert.ToString(dt.Rows[i]["Phonenumber"]);
}
if (Convert.ToString(dt.Rows[i]["Businessimage"]) != "")
{
obj_BusinessDirectory.Businessimage = Convert.ToString(dt.Rows[i]["Businessimage"]);
}
if (Convert.ToString(dt.Rows[i]["Locationid"]) != "")
{
obj_BusinessDirectory.Locationid = Convert.ToInt32(dt.Rows[i]["Locationid"]);
}
if (Convert.ToString(dt.Rows[i]["Address"]) != "")
{
obj_BusinessDirectory.Address = Convert.ToString(dt.Rows[i]["Address"]);
}
if (Convert.ToString(dt.Rows[i]["Addressline2"]) != "")
{
obj_BusinessDirectory.Addressline2 = Convert.ToString(dt.Rows[i]["Addressline2"]);
}
if (Convert.ToString(dt.Rows[i]["City"]) != "")
{
obj_BusinessDirectory.City = Convert.ToString(dt.Rows[i]["City"]);
}
if (Convert.ToString(dt.Rows[i]["State"]) != "")
{
obj_BusinessDirectory.State = Convert.ToString(dt.Rows[i]["State"]);
}
if (Convert.ToString(dt.Rows[i]["Zipcode"]) != "")
{
obj_BusinessDirectory.Zipcode = Convert.ToString(dt.Rows[i]["Zipcode"]);
}
if (Convert.ToString(dt.Rows[i]["Locationlatitude"]) != "")
{
obj_BusinessDirectory.Locationlatitude = Convert.ToString(dt.Rows[i]["Locationlatitude"]);
}
if (Convert.ToString(dt.Rows[i]["Locationlongitude"]) != "")
{
obj_BusinessDirectory.Locationlongitude = Convert.ToString(dt.Rows[i]["Locationlongitude"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_BusinessDirectory.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Isdeleted"]) != "")
{
obj_BusinessDirectory.Isdeleted = Convert.ToBoolean(dt.Rows[i]["Isdeleted"]);
}
if (Convert.ToString(dt.Rows[i]["Createdon"]) != "")
{
obj_BusinessDirectory.Createdon = Convert.ToDateTime(dt.Rows[i]["Createdon"]);
}
if (Convert.ToString(dt.Rows[i]["Deletedon"]) != "")
{
obj_BusinessDirectory.Deletedon = Convert.ToDateTime(dt.Rows[i]["Deletedon"]);
}
BusinessDirectorylist.Add(obj_BusinessDirectory);
}
return(BusinessDirectorylist);
}
//update edited object
public BusinessDirectoryClass updateObject(BusinessDirectoryClass obj)
{
try
{
BusinessDirectoryClass oldObj = selectById(obj.Businessid);
if (obj.Businessname == null)
{
obj.Businessname = oldObj.Businessname;
}
if (obj.Website == null)
{
obj.Website = oldObj.Website;
}
if (obj.Businessurl == null)
{
obj.Businessurl = oldObj.Businessurl;
}
if (obj.Phonenumber == null)
{
obj.Phonenumber = oldObj.Phonenumber;
}
if (obj.Businessimage == null)
{
obj.Businessimage = oldObj.Businessimage;
}
if (obj.BusinessLogo == null)
{
obj.BusinessLogo = oldObj.BusinessLogo;
}
if (obj.Locationid == null)
{
obj.Locationid = oldObj.Locationid;
}
if (obj.Address == null)
{
obj.Address = oldObj.Address;
}
if (obj.Addressline2 == null)
{
obj.Addressline2 = oldObj.Addressline2;
}
if (obj.City == null)
{
obj.City = oldObj.City;
}
if (obj.State == null)
{
obj.State = oldObj.State;
}
if (obj.Zipcode == null)
{
obj.Zipcode = oldObj.Zipcode;
}
if (obj.Locationlatitude == null)
{
obj.Locationlatitude = oldObj.Locationlatitude;
}
if (obj.Locationlongitude == null)
{
obj.Locationlongitude = oldObj.Locationlongitude;
}
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(BusinessDirectoryClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
if (Convert.ToString(obj.Businessname) != "")
{
obj_con.addParameter("@Businessname", string.IsNullOrEmpty(Convert.ToString(obj.Businessname)) ? "" : obj.Businessname);
}
else
{
obj_con.addParameter("@Businessname", DBNull.Value);
}
if (Convert.ToString(obj.Website) != "")
{
obj_con.addParameter("@Website", string.IsNullOrEmpty(Convert.ToString(obj.Website)) ? "" : obj.Website);
}
else
{
obj_con.addParameter("@Website", DBNull.Value);
}
if (Convert.ToString(obj.Businessurl) != "")
{
obj_con.addParameter("@Businessurl", string.IsNullOrEmpty(Convert.ToString(obj.Businessurl)) ? "" : obj.Businessurl);
}
else
{
obj_con.addParameter("@Businessurl", DBNull.Value);
}
if (Convert.ToString(obj.Categories) != "")
{
obj_con.addParameter("@Categories", string.IsNullOrEmpty(Convert.ToString(obj.Categories)) ? "" : obj.Categories);
}
else
{
obj_con.addParameter("@Categories", DBNull.Value);
}
if (Convert.ToString(obj.Phonenumber) != "")
{
obj_con.addParameter("@Phonenumber", string.IsNullOrEmpty(Convert.ToString(obj.Phonenumber)) ? "" : obj.Phonenumber);
}
else
{
obj_con.addParameter("@Phonenumber", DBNull.Value);
}
if (Convert.ToString(obj.Phonenumber2) != "")
{
obj_con.addParameter("@Phonenumber2", string.IsNullOrEmpty(Convert.ToString(obj.Phonenumber2)) ? "" : obj.Phonenumber2);
}
else
{
obj_con.addParameter("@Phonenumber2", DBNull.Value);
}
if (Convert.ToString(obj.Email) != "")
{
obj_con.addParameter("@Email", string.IsNullOrEmpty(Convert.ToString(obj.Email)) ? "" : obj.Email);
}
else
{
obj_con.addParameter("@Email", DBNull.Value);
}
if (Convert.ToString(obj.BusinessVideoURL) != "")
{
obj_con.addParameter("@BusinessVideoURL", string.IsNullOrEmpty(Convert.ToString(obj.BusinessVideoURL)) ? "" : obj.BusinessVideoURL);
}
else
{
obj_con.addParameter("@BusinessVideoURL", DBNull.Value);
}
if (Convert.ToString(obj.BusinessLogo) != "")
{
obj_con.addParameter("@BusinessLogo", string.IsNullOrEmpty(Convert.ToString(obj.BusinessLogo)) ? "" : obj.BusinessLogo);
}
else
{
obj_con.addParameter("@BusinessLogo", DBNull.Value);
}
if (Convert.ToString(obj.Businessimage) != "")
{
obj_con.addParameter("@Businessimage", string.IsNullOrEmpty(Convert.ToString(obj.Businessimage)) ? "" : obj.Businessimage);
}
else
{
obj_con.addParameter("@Businessimage", DBNull.Value);
}
if (Convert.ToString(obj.Locationid) != "")
{
obj_con.addParameter("@Locationid", string.IsNullOrEmpty(Convert.ToString(obj.Locationid)) ? 0 : obj.Locationid);
}
else
{
obj_con.addParameter("@Locationid", DBNull.Value);
}
if (Convert.ToString(obj.Address) != "")
{
obj_con.addParameter("@Address", string.IsNullOrEmpty(Convert.ToString(obj.Address)) ? "" : obj.Address);
}
else
{
obj_con.addParameter("@Address", DBNull.Value);
}
if (Convert.ToString(obj.Addressline2) != "")
{
obj_con.addParameter("@Addressline2", string.IsNullOrEmpty(Convert.ToString(obj.Addressline2)) ? "" : obj.Addressline2);
}
else
{
obj_con.addParameter("@Addressline2", DBNull.Value);
}
if (Convert.ToString(obj.City) != "")
{
obj_con.addParameter("@City", string.IsNullOrEmpty(Convert.ToString(obj.City)) ? "" : obj.City);
}
else
{
obj_con.addParameter("@City", DBNull.Value);
}
if (Convert.ToString(obj.State) != "")
{
obj_con.addParameter("@State", string.IsNullOrEmpty(Convert.ToString(obj.State)) ? "" : obj.State);
}
else
{
obj_con.addParameter("@State", DBNull.Value);
}
if (Convert.ToString(obj.Zipcode) != "")
{
obj_con.addParameter("@Zipcode", string.IsNullOrEmpty(Convert.ToString(obj.Zipcode)) ? "" : obj.Zipcode);
}
else
{
obj_con.addParameter("@Zipcode", DBNull.Value);
}
if (Convert.ToString(obj.Locationlatitude) != "")
{
obj_con.addParameter("@Locationlatitude", string.IsNullOrEmpty(Convert.ToString(obj.Locationlatitude)) ? "" : obj.Locationlatitude);
}
else
{
obj_con.addParameter("@Locationlatitude", DBNull.Value);
}
if (Convert.ToString(obj.Locationlongitude) != "")
{
obj_con.addParameter("@Locationlongitude", string.IsNullOrEmpty(Convert.ToString(obj.Locationlongitude)) ? "" : obj.Locationlongitude);
}
else
{
obj_con.addParameter("@Locationlongitude", 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.IsFeatured) != "")
{
obj_con.addParameter("@IsFeatured", string.IsNullOrEmpty(Convert.ToString(obj.IsFeatured)) ? false : obj.IsFeatured);
}
else
{
obj_con.addParameter("@IsFeatured", DBNull.Value);
}
if (Convert.ToString(obj.HasBrochure) != "")
{
obj_con.addParameter("@HasBrochure", string.IsNullOrEmpty(Convert.ToString(obj.HasBrochure)) ? false : obj.HasBrochure);
}
else
{
obj_con.addParameter("@HasBrochure", 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.Businessid) != "")
{
obj_con.addParameter("@Businessid", Convert.ToInt32(obj.Businessid), trans);
}
else
{
obj_con.addParameter("@Businessid", DBNull.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}