/// <summary>
/// Generates a list of seller specific by ProvinceID.
/// </summary>
/// <param name="intCategoryID"></param>
/// <param name="intSubcategoryID"></param>
/// <param name="intProfileID"></param>
/// <param name="strCountry"></param>
private void LoadList_LatestPosted_RealEstate_ByArea_InsideDhaka(int intCategoryID, int intSubcategoryID, int intAreaID)
{
try
{
using (BC_RealEstate bcRealEstate = new BC_RealEstate())
{
RealEstate objRealEstate = new RealEstate();
objRealEstate.CategoryID = intCategoryID;
objRealEstate.SubcategoryID = intSubcategoryID;
objRealEstate.AreaID = intAreaID;
DataTable dt = bcRealEstate.Load_List_RealEstate_ByArea_InsideDhaka(objRealEstate);
if (dt.Rows.Count > 0)
{
InitializeGridView(dt, grvRealEstate);
}
else
{
InitializeGridView(null, grvRealEstate);
}
}
}
catch (Exception ex)
{
lblSystemMessage.Text = ex.Message;
}
}
/// <summary>
/// Loads all Area with Number of Posted Classified items Posted For Specific Classified Category.
/// </summary>
/// <param name="intCategoryID"></param>
private void LoadList_CL_Items_ByArea(int intCategoryID, int intSubCategoryID)
{
try
{
using (BC_RealEstate bcRealEstate = new BC_RealEstate())
{
DataTable dtClassified = bcRealEstate.LoadList_CL_Items_ByArea(intCategoryID, intSubCategoryID);
if (dtClassified.Rows.Count > 0)
{
repProvince.DataSource = dtClassified;
repProvince.DataBind();
}
else
{
repProvince.DataSource = null;
repProvince.DataBind();
this.Visible = false;
}
}
}
catch (Exception Exp)
{
Response.Write(Exp.Message.ToString());
}
}
public RealEstate SelectRecord_RealEstate(RealEstate objRealEstate)
{
int _ActionResult = -1;
RealEstate obj = new RealEstate();
try
{
using (BC_RealEstate bc = new BC_RealEstate())
{
DataTable dt = bc.SelectRecord_RealEstate(objRealEstate);
if (dt.Rows.Count > 0)
{
obj.ProductID = Convert.ToInt32(dt.Rows[0]["ProductID"]);
obj.ProfileID = Convert.ToInt32(dt.Rows[0]["ProfileID"]);
obj.UserType = Convert.ToBoolean(dt.Rows[0]["UserType"]);
obj.SKU = dt.Rows[0]["SKU"].ToString();
obj.CategoryID = Convert.ToInt32(dt.Rows[0]["CategoryID"]);
obj.SubcategoryID = Convert.ToInt32(dt.Rows[0]["SubcategoryID"]);
obj.SecondSubcatID = Convert.ToInt32(dt.Rows[0]["SecondsubcatID"]);
obj.SellerType = Convert.ToInt32(dt.Rows[0]["SellerType"]);
obj.SellerName = dt.Rows[0]["SellerName"].ToString();
obj.ProjectName = dt.Rows[0]["ProjectName"].ToString();
obj.ProjectType = dt.Rows[0]["ProjectType"].ToString();
obj.ProvinceID = Convert.ToInt32(dt.Rows[0]["ProvinceID"]);
obj.AreaID = Convert.ToInt32(dt.Rows[0]["AreaID"]);
obj.Area = dt.Rows[0]["Area"].ToString();
obj.Address = dt.Rows[0]["Address"].ToString();
obj.Size = Convert.ToDouble(dt.Rows[0]["Size"]);
obj.SizeUnit = dt.Rows[0]["SizeUnit"].ToString();
obj.LandNature = dt.Rows[0]["LandNature"].ToString();
obj.Quantity = Convert.ToInt32(dt.Rows[0]["Quantity"]);
obj.Price = Convert.ToDouble(dt.Rows[0]["Price"]);
obj.Currency = dt.Rows[0]["Currency"].ToString();
obj.NoOfBedRoom = dt.Rows[0]["NoOfBedRoom"].ToString();
obj.NoOfWashRoom = dt.Rows[0]["NoOfWashRoom"].ToString();
obj.ServiceCharge = Convert.ToDouble(dt.Rows[0]["ServiceCharge"]);
obj.IsCarParkingAvailable = Convert.ToBoolean(dt.Rows[0]["IsCarParkingAvailable"]);
obj.Description = dt.Rows[0]["Description"].ToString();
obj.IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"]);
obj.IsInsideDhaka = Convert.ToBoolean(dt.Rows[0]["IsInsideDhaka"]);
//obj.HitCounter = dt.Rows[0]["HitCounter"];
obj.ProductImage = dt.Rows[0]["ProductImage"].ToString();
obj.IsAlternativeAddress = Convert.ToBoolean(dt.Rows[0]["IsAlternativeAddress"]);
obj.Source = dt.Rows[0]["Source"].ToString();
//obj.UpdatedOn = dt.Rows[0]["UpdatedOn"];
}
}
}
catch
{
throw;
}
return(obj);
}
public DataTable LoadList_RealEstate_BySecondSubcateogry(RealEstate objRealEstate)
{
try
{
using (BC_RealEstate bc = new BC_RealEstate())
{
return(bc.LoadList_RealEstate_BySecondSubcategory(objRealEstate));
}
}
catch
{
throw;
}
}
public DataTable LoadRecord_Detail_RealEstate(RealEstate objRealEstate)
{
try
{
using (BC_RealEstate bc = new BC_RealEstate())
{
return(bc.LoadRecord_Detail_RealEstate(objRealEstate));
}
}
catch
{
throw;
}
}
public DataTable Load_RealEstate_CLProductList_BySubcategory(RealEstate objRealEstate)
{
try
{
using (BC_RealEstate bc = new BC_RealEstate())
{
return(bc.Load_List_RealEstate_ClassifiedSellerProduct_BySubcategory(objRealEstate));
}
}
catch
{
throw;
}
}
public DataTable Load_LeftMenu_SecondSubcategory(RealEstate objRealEstate)
{
//int _ActionResult = -1;
try
{
using (BC_RealEstate bc = new BC_RealEstate())
{
return(bc.Load_LeftMenu_SecondSubcategory(objRealEstate));
}
}
catch
{
throw;
}
}
public DataTable LoadList_PostedRealEstate(RealEstate objRealEstate)
{
int _ActionResult = -1;
try
{
using (BC_RealEstate bc = new BC_RealEstate())
{
return(bc.LoadList_PostedRealEstate(objRealEstate));
}
}
catch
{
throw;
}
}
/// <summary>
/// Inserts Real Estate Product in the Database.
/// </summary>
/// <param name="objRealEstate"></param>
/// <returns></returns>
public int AddRealEstate(RealEstate objRealEstate)
{
int _ActionResult = -1;
try
{
using (BC_RealEstate bc = new BC_RealEstate())
{
if (!bc.BeforeInsert_IsRealEstateTitle_Duplicate(objRealEstate))
{
return(bc.InsertRealEstate(objRealEstate));
}
else
{
return(-1);
}
}
}
catch
{
throw;
}
}
