/// <summary>
/// code for updation of property details
/// </summary>
/// <param name="ids"></param>
/// <param name="price"></param>
/// <param name="_for"></param>
/// <returns></returns>
public static int updatePropertyDetails(int ids, string add, long price, int bed, int bath, long area, string _for, int flat)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblProperty property = objdata.tblProperties.Where(x => x.Id == ids).FirstOrDefault();
if (property != null)
{
property.Address = add;
property.Bedroom = bed;
property.Bathroom = bath;
property.Area = area;
property.Price = Convert.ToInt64(price);
property.For = _for;
property.FlatId = flat;
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult PuttblProperty(int id, tblProperty tblProperty)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (db)
{
var cust = db.tblProperties.Where(g => g.Prop_id.Equals(id)).FirstOrDefault();
if (cust != null)
{
cust.Prop_Desc = tblProperty.Prop_Desc;
cust.Prop_Type = tblProperty.Prop_Type;
cust.Prop_Stat = tblProperty.Prop_Stat;
cust.BedRoom = tblProperty.BedRoom;
cust.BathRoom = tblProperty.BathRoom;
cust.Garage = tblProperty.Garage;
cust.Price = tblProperty.Price;
cust.Cities = tblProperty.Cities;
cust.Address = tblProperty.Address;
var res = db.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult PosttblProperty(tblProperty tblProperty)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblProperties.Add(tblProperty);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (tblPropertyExists(tblProperty.Prop_id))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = tblProperty.Prop_id }, tblProperty));
}
/// <summary>
/// Saves all changes to the ViewModel
/// </summary>
private void SaveLevel(TD.ObservableItemCollection <PropertyModel> treeLevel, EDBEntities eDB)
{
try
{
if (treeLevel != null)
{
foreach (var propertyItem in treeLevel)
{
if (propertyItem.IsNew)
{
tblProperty NewRec = new tblProperty();
var Rec = eDB.tblProperties.Add(NewRec);
Rec.ID = propertyItem.ID;
Rec.Parent_ID = propertyItem.Parent_ID;
Rec.PropertyName = propertyItem.PropertyName;
Rec.Description = propertyItem.Description;
Rec.Project_ID = propertyItem.Project_ID;
Rec.PropertyType_ID = propertyItem.PropertyType_ID;
Rec.Aspect = propertyItem.Aspect;
Rec.Attribute1 = propertyItem.Attribute1;
Rec.Attribute2 = propertyItem.Attribute2;
Rec.Attribute3 = propertyItem.Attribute3;
Rec.Value = propertyItem.Value;
propertyItem.IsNew = false;
}
if (propertyItem.IsChanged)
{
tblProperty Rec = eDB.tblProperties.Where(o => o.ID == propertyItem.ID).FirstOrDefault();
Rec.Parent_ID = propertyItem.Parent_ID;
Rec.PropertyName = propertyItem.PropertyName;
Rec.Description = propertyItem.Description;
Rec.Project_ID = propertyItem.Project_ID;
Rec.PropertyType_ID = propertyItem.PropertyType_ID;
Rec.Aspect = propertyItem.Aspect;
Rec.Attribute1 = propertyItem.Attribute1;
Rec.Attribute2 = propertyItem.Attribute2;
Rec.Attribute3 = propertyItem.Attribute3;
Rec.Value = propertyItem.Value;
propertyItem.IsChanged = false;
}
// DeleteRecursive call to add/Update children
if (propertyItem.ChildProperties != null)
{
SaveLevel(propertyItem.ChildProperties, eDB);
}
}
}
}
catch (Exception ex)
{
RadWindow.Alert(new DialogParameters()
{
Header = "Error",
Content = "Fault while adding/updating to database:\n" + ex.Message
});
}
}
public IHttpActionResult GettblProperty(int id)
{
tblProperty tblProperty = db.tblProperties.Find(id);
if (tblProperty == null)
{
return(NotFound());
}
return(Ok(tblProperty));
}
public IHttpActionResult DeletetblProperty(int id)
{
tblProperty tblProperty = db.tblProperties.Find(id);
if (tblProperty == null)
{
return(NotFound());
}
db.tblProperties.Remove(tblProperty);
db.SaveChanges();
return(Ok(tblProperty));
}
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
objCommon = new clsCommon();
if (e.CommandName == "IsShowInSearch")
{
objProperty = new tblProperty();
if (objProperty.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (objProperty.AppIsShowInSearch == true)
{
objProperty.AppIsShowInSearch = false;
}
else if (objProperty.AppIsShowInSearch == false)
{
objProperty.AppIsShowInSearch = true;
}
objProperty.Save();
LoadDataGrid(false, false, "", "");
}
}
else if (e.CommandName == "Up")
{
LinkButton inkButton = (LinkButton)e.CommandSource;
GridViewRow drCurrent = (GridViewRow)inkButton.Parent.Parent;
if (drCurrent.RowIndex > 0)
{
GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex - 1];
objCommon.SetDisplayOrder("tblProperty", tblProperty.ColumnNames.AppPropertyID, tblProperty.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]);
LoadDataGrid(false, false);
objCommon = null;
}
}
else if (e.CommandName == "Down")
{
LinkButton lnkButton = (LinkButton)e.CommandSource;
GridViewRow drCurrent = (GridViewRow)lnkButton.Parent.Parent;
if (drCurrent.RowIndex < dgvGridView.Rows.Count - 1)
{
GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex + 1];
objCommon.SetDisplayOrder("tblProperty", tblProperty.ColumnNames.AppPropertyID, tblProperty.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]);
LoadDataGrid(false, false);
objCommon = null;
}
objProperty = null;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SetUpPageContent(ref metaDescription, ref metaKeywords);
objCommon = new clsCommon();
hdnProduct.Value = objCommon.GetParameterFromUrl(Enums.Enums_URLParameterType.ByNumber, "1");
lblLiteral.Text = " / " + hdnProduct.Value;
this.Page.Title = hdnCategory.Value;
objCommon = null;
tblProperty objProperty = new tblProperty();
RepProperty.DataSource = objProperty.LoadProductWiseProperty(hdnProduct.Value);
RepProperty.DataBind();
objProperty = null;
tblProduct objProduct = new tblProduct();
decimal iPrice = objProduct.GetProductNameWiseMaxPrice(hdnProduct.Value);
objProduct = null;
iPrice = Math.Round(Convert.ToDecimal(HttpContext.Current.Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString()) * iPrice, 0) + 100;
hdnMaxPrice.Value = iPrice.ToString();
dtColor.DataSource = null;
dtColor.DataBind();
tblColor objColor = new tblColor();
objColor.Where.AppIsActive.Value = true;
objColor.Query.AddOrderBy(tblColor.ColumnNames.AppDisplayOrder, MyGeneration.dOOdads.WhereParameter.Dir.ASC);
objColor.Query.Load();
if (objColor.RowCount > 0)
{
if (objColor.RowCount == 1)
{
if (objColor.s_AppIsDefault != "")
{
if (objColor.AppIsDefault)
{
Seccolor.Style.Add("display", "none");
}
}
}
dtColor.DataSource = objColor.DefaultView.Table;;
dtColor.DataBind();
}
objColor = null;
hdnOrderBy.Value = " vw_SerachProduct.appProductId Desc";
}
}
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "")
{
objProperty = new tblProperty();
objDataTable = objProperty.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim());
//'Reset PageIndex of gridviews
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
//'Check for data into datatable
if (objDataTable.Rows.Count <= 0)
{
DInfo.ShowMessage("No data found", Enums.MessageType.Information);
return;
}
else
{
if (ddlPerPage.SelectedItem.Text.ToLower() == "all")
{
dgvGridView.AllowPaging = false;
}
else
{
dgvGridView.AllowPaging = true;
dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text);
}
lblCount.Text = objDataTable.Rows.Count.ToString();
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objProperty = null;
}
public int CreateProperty(Property property)
{
using (var scope = new TransactionScope())
{
var newproperty = new tblProperty
{
Description = property.Description,
Price = property.Price,
IsSold = property.IsSold
};
_unitOfWork.PropertyRepository.Insert(newproperty);
_unitOfWork.Save();
scope.Complete();
return(newproperty.PropertyID);
}
}
private bool Delete(int intPKID)
{
bool retval = false;
objProperty = new tblProperty();
var _with1 = objProperty;
if (_with1.LoadByPrimaryKey(intPKID))
{
_with1.MarkAsDeleted();
_with1.Save();
}
retval = true;
objProperty = null;
return(retval);
}
public static int PropertyUpdation(tblProperty property)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
property.Crdt = DateTime.Now;
property.Updt = DateTime.Now;
property.IsActive = true;
objdata.tblProperties.InsertOnSubmit(property);
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// code to delete properties....
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public static int DeletePropertiesDetails(int ids)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblProperty property = objdata.tblProperties.Where(x => x.Id == ids).FirstOrDefault();
if (property != null)
{
property.IsActive = false;
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// code for updation of property details
/// </summary>
/// <param name="ids"></param>
/// <param name="price"></param>
/// <param name="_for"></param>
/// <returns></returns>
public static int updatePropertyDetails(int ids, long price, string _for)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblProperty property = objdata.tblProperties.Where(x => x.Id == ids).FirstOrDefault();
if (property != null)
{
property.Price = Convert.ToInt64(price);
property.For = _for;
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void SetValuesToControls()
{
if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "")
{
objProperty = new tblProperty();
if (objProperty.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)))
{
txtPropertyName.Text = objProperty.AppPropertyName;
txtDisplayName.Text = objProperty.AppDisplayName;
txtDescription.Text = objProperty.AppDescription;
chkIsPredefine.Checked = objProperty.AppIsPredefine;
ChkIsShowInSearch.Checked = objProperty.AppIsShowInSearch;
if (!objProperty.AppIsPredefine)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "SomeShoW()", true);
}
LoadAllData();
}
objProperty = null;
}
}
private bool SaveData()
{
objCommon = new clsCommon();
if (objCommon.IsRecordExists("tblProperty", tblProperty.ColumnNames.AppPropertyName, tblProperty.ColumnNames.AppPropertyID, txtPropertyName.Text, hdnPKID.Value))
{
DInfo.ShowMessage("Property Name alredy exits.", Enums.MessageType.Error);
return(false);
}
if (objCommon.IsRecordExists("tblProperty", tblProperty.ColumnNames.AppDisplayName, tblProperty.ColumnNames.AppPropertyID, txtDisplayName.Text, hdnPKID.Value))
{
DInfo.ShowMessage("Display Name alredy exits.", Enums.MessageType.Error);
return(false);
}
objProperty = new tblProperty();
if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "")
{
objProperty.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value));
}
else
{
objProperty.AddNew();
objProperty.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblProperty", tblProperty.ColumnNames.AppDisplayOrder);
objProperty.s_AppCreatedBy = Session[appFunctions.Session.UserID.ToString()].ToString();
objProperty.AppCreatedDate = DateTime.Now;
// objBanner.AppDisplayOrder = objClsCommon.GetNextDisplayOrder("tblBanner", tblBanner.ColumnNames.AppDisplayOrder);
}
objProperty.AppPropertyName = txtPropertyName.Text;
objProperty.AppDisplayName = txtDisplayName.Text;
objProperty.AppDescription = txtDescription.Text;
objProperty.AppIsPredefine = chkIsPredefine.Checked;
objProperty.AppIsShowInSearch = ChkIsShowInSearch.Checked;
objProperty.Save();
intPkId = objProperty.AppPropertyID;
objProperty = null;
objCommon = null;
return(true);
}
public ActionResult Create(PropertyVM mod)
{
if (ModelState.IsValid)
{
try
{
if (mod.SocietyID <= 0)
{
tblSociety soc = new tblSociety
{
CityID = mod.CityID,
Society = mod.OtherSociety,
Status = true
};
db.tblSocieties.Add(soc);
db.SaveChanges();
mod.SocietyID = soc.SocietyID;
}
tblProperty tbl = new tblProperty
{
CityID = mod.CityID,
Description = mod.Description,
IsFeatured = mod.IsFeatured,
LandArea = mod.LandArea,
Price = mod.Price,
PropertyTitle = mod.PropertyTitle,
Purpose = mod.Purpose,
SocietyID = mod.SocietyID,
Status = "H",
TransDate = DateTime.Now.AddHours(12),
TypeID = mod.TypeID,
UOMID = mod.UOMID,
UserID = bl.GetUserID(System.Web.HttpContext.Current),
Block = mod.Block,
ContactNo = mod.ContactNo,
Estate = mod.Estate,
IsDealer = mod.IsDealer,
Owner = mod.Owner,
PlotNo = mod.PlotNo
};
db.tblProperties.Add(tbl);
db.SaveChanges();
var coun = Request.Files.Count;
for (int i = 0; i < coun; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetExtension(file.FileName);
tblImage img = new tblImage
{
PropertyID = tbl.PropertyID,
ImagePath = fileName,
Status = true
};
db.tblImages.Add(img);
db.SaveChanges();
var path = Path.Combine(Server.MapPath("~/Images/"), img.ImageID + fileName);
file.SaveAs(path);
}
}
return(RedirectToAction("Create"));
}
catch (Exception)
{
}
}
return(View(mod));
}
