private static int SaveSecurities(IDataAccess objDataAccess, DbCommand objDCommand, PropertySecurityType objSecurity, int propertyId)
{
objDCommand.Parameters.Clear();
objDCommand.AddInParameter("SecurityTypeId", objSecurity.SecurityTypeId);
objDCommand.AddInParameter("PropertyId", propertyId);
return(objDataAccess.ExecuteNonQuery(objDCommand, "ams.uspInsertPropertyWiseSecurity", CommandType.StoredProcedure));
}
private void BuildModel(DbDataReader objDataReader, PropertySecurityType objSecurityType)
{
var objDataTable = objDataReader.GetSchemaTable();
foreach (DataRow dr in objDataTable.Rows)
{
var column = dr.ItemArray[0].ToString();
switch (column)
{
case "SecurityTypeId":
if (!Convert.IsDBNull(objDataReader["SecurityTypeId"]))
{
objSecurityType.SecurityTypeId = Convert.ToInt32(objDataReader["SecurityTypeId"].ToString());
}
break;
case "SecurityType":
if (!Convert.IsDBNull(objDataReader["SecurityType"]))
{
objSecurityType.SecurityType = objDataReader["SecurityType"].ToString();
}
break;
case "Status":
if (!Convert.IsDBNull(objDataReader["Status"]))
{
objSecurityType.Status = Convert.ToBoolean(objDataReader["Status"]);
}
break;
case "EntryDate":
if (!Convert.IsDBNull(objDataReader["EntryDate"]))
{
objSecurityType.EntryDate = Convert.ToDateTime(objDataReader["EntryDate"]);
}
break;
case "EntryBy":
if (!Convert.IsDBNull(objDataReader["EntryBy"]))
{
objSecurityType.EntryBy = objDataReader["EntryBy"].ToString();
}
break;
case "UpdateDate":
if (!Convert.IsDBNull(objDataReader["UpdateDate"]))
{
objSecurityType.UpdateDate = Convert.ToDateTime(objDataReader["UpdateDate"]);
}
break;
case "UpdateBy":
if (!Convert.IsDBNull(objDataReader["UpdateBy"]))
{
objSecurityType.UpdateBy = objDataReader["UpdateBy"].ToString();
}
break;
default:
break;
}
}
objSecurityType.IsNew = false;
objSecurityType.IsDirty = true;
objSecurityType.IsDelete = false;
}
private int SendRequestToSave()
{
try
{
objProperty = new Property();
int result = 0;
objFacilityTypeList = new List <PropertyFacilityType>();
objSecurityTypesList = new List <PropertySecurityType>();
objPropertyBiz = new PropertyBiz();
foreach (ListItem item in ckblPropertyFacilities.Items)
{
objFacilityType = new PropertyFacilityType();
if (item.Selected)
{
objFacilityType.FacilityTypeId = Convert.ToInt32(item.Value);
objFacilityType.FacilityName = item.Text;
objFacilityTypeList.Add(objFacilityType);
}
}
foreach (ListItem item in ckblPropertySecurity.Items)
{
objSecurityType = new PropertySecurityType();
if (item.Selected)
{
objSecurityType.SecurityTypeId = Convert.ToInt32(item.Value);
objSecurityType.SecurityType = item.Text;
objSecurityTypesList.Add(objSecurityType);
}
}
objProperty.PropertyName = txtPropertyName.Text.Trim();
objProperty.LandloadId = objUserDetail.UserID;
objProperty.PropertyTypeId = string.IsNullOrEmpty(ddlPropertyType.SelectedValue.Trim()) ? 0 : Convert.ToInt32(ddlPropertyType.SelectedValue.Trim());
objProperty.BuiltYear = string.IsNullOrEmpty(txtBuiltYear.Text.Trim()) ? DateTime.MinValue : Convert.ToDateTime(txtBuiltYear.Text.Trim());
objProperty.CountryID = string.IsNullOrEmpty(ddlCountry.SelectedValue.Trim()) ? 0 : Convert.ToInt32(ddlCountry.SelectedValue.Trim());
objProperty.DivisionId = string.IsNullOrEmpty(ddlDivision.SelectedValue.Trim()) ? 0 : Convert.ToInt32(ddlDivision.SelectedValue.Trim()); //Division=State
objProperty.DistrictId = string.IsNullOrEmpty(ddlCity.SelectedValue.Trim()) ? 0 : Convert.ToInt32(ddlCity.SelectedValue.Trim()); //District =City
objProperty.UpazilaId = string.IsNullOrEmpty(dllThanaOrArea.SelectedValue.Trim()) ? 0 : Convert.ToInt32(dllThanaOrArea.SelectedValue.Trim()); //UpazilaId=Thana/Area
objProperty.HoldingNo = txtHoldingOrHouseNo.Text.Trim();
objProperty.RoadNo = txtRoadNo.Text.Trim();
objProperty.SectorOrBlock = txtSector.Text.Trim();
objProperty.TotalSpace = string.IsNullOrEmpty(txtTotalSpace.Text.Trim()) ? 0 : Convert.ToInt32(txtTotalSpace.Text.Trim());
objProperty.NoOfFloors = string.IsNullOrEmpty(txtNoOfFloors.Text.Trim()) ? 0 : Convert.ToInt32(txtNoOfFloors.Text.Trim());
objProperty.IsParkingAvailable = Convert.ToBoolean(rblIsParkingAvailabel.SelectedValue);
if (Convert.ToBoolean(rblIsParkingAvailabel.SelectedValue))
{
objProperty.TotalParkingSpace = string.IsNullOrEmpty(txtParkingTotalSpace.Text.Trim()) ? 0 : Convert.ToInt32(txtParkingTotalSpace.Text.Trim());
}
objProperty.PropertyFacilityTypeList = objFacilityTypeList;
objProperty.PropertySecurityTypeList = objSecurityTypesList;
result = objPropertyBiz.SavePropertyInfo(objProperty);
return(result);
}
catch (Exception exception)
{
MessageBox(exception.Message);
return(0);
}
}
