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); } }