예제 #1
0
        public int SaveVisitRequest(VisitRequest _objVisitRequest, out int VisitReqId)
        {
            var noOfAffacted = 0;

            objDataAccess = DataAccess.NewDataAccess();
            objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
            objDbCommand.AddInOutParameter("VisitReqId", _objVisitRequest.VisitReqId, ParameterDirection.InputOutput, DbType.Int32, 16);
            objDbCommand.AddInParameter("LandlordId", _objVisitRequest.LandlordId);
            objDbCommand.AddInParameter("PropertyId", _objVisitRequest.PropertyId);
            objDbCommand.AddInParameter("ApartmentId", _objVisitRequest.ApartmentId);
            objDbCommand.AddInParameter("ClientName", _objVisitRequest.ClientName);
            objDbCommand.AddInParameter("ClientEmail", _objVisitRequest.ClientEmail);
            objDbCommand.AddInParameter("ClientMobileNo", _objVisitRequest.ClientMobileNo);
            objDbCommand.AddInParameter("MessageToLandlord", _objVisitRequest.MessageToLandlord);
            objDbCommand.AddInParameter("RequestDate", _objVisitRequest.RequestDate);

            try
            {
                noOfAffacted =
                    objDataAccess.ExecuteNonQuery(objDbCommand, "ams.uspInsertVisitRequest", CommandType.StoredProcedure);
                VisitReqId = Convert.ToInt32(objDbCommand.Parameters["VisitReqId"].Value.ToString());

                if (noOfAffacted > 0)
                {
                    objDbCommand.Transaction.Commit();
                    return noOfAffacted;
                }
                else
                {
                    objDbCommand.Transaction.Rollback();
                    return noOfAffacted;
                }

            }
            catch (Exception ex)
            {
                objDbCommand.Transaction.Rollback();
                throw new Exception("Database Error Occured", ex);
            }
            finally
            {
                objDataAccess.Dispose(objDbCommand);
            }
        }
예제 #2
0
        public int SaveApartmentInfo(Apartment objApartment)
        {
            var noOfAffacted = 0;
            int apartmentId;

            //string spName = "";
            //if (referenceType==EnumBiz.ReferanceType.New.ToString())
            //{
            //    spName = "AHL.prInsertApllicant";
            //}
            objDataAccess = DataAccess.NewDataAccess();
            objDbCommand  = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
            objDbCommand.AddInOutParameter("ApartmentId", objApartment.ApartmentId, ParameterDirection.InputOutput, DbType.Int32, 16);

            objDbCommand.AddInParameter("PropertyId", objApartment.PropertyId);
            objDbCommand.AddInParameter("ApartmentNoOrName", objApartment.ApartmentNoOrName);
            objDbCommand.AddInParameter("LandloadId", objApartment.LandloadId.Trim());
            objDbCommand.AddInParameter("FloorNo", objApartment.FloorNo);
            objDbCommand.AddInParameter("ApartmentSpace", objApartment.ApartmentSpace);
            objDbCommand.AddInParameter("Beds", objApartment.Beds);
            objDbCommand.AddInParameter("AttachBatch", objApartment.AttachBatch);
            objDbCommand.AddInParameter("CommonBath", objApartment.CommonBath);
            objDbCommand.AddInParameter("DiningPosition", objApartment.DiningPosition);
            objDbCommand.AddInParameter("StaffRoom", objApartment.StaffRoom);
            objDbCommand.AddInParameter("StaffToilet", objApartment.StaffToilet);
            objDbCommand.AddInParameter("Balconies", objApartment.Balconies);
            objDbCommand.AddInParameter("FloorTypeId", objApartment.FloorTypeId);
            objDbCommand.AddInParameter("Rent", objApartment.Rent);
            objDbCommand.AddInParameter("Advance", objApartment.Advance);
            objDbCommand.AddInParameter("SecurityAmount", objApartment.SecurityAmount);
            objDbCommand.AddInParameter("ServiceCharge", objApartment.ServiceCharge);
            objDbCommand.AddInParameter("GasBill", objApartment.GasBill);
            objDbCommand.AddInParameter("CableTvBill", objApartment.CableTvBill);
            objDbCommand.AddInParameter("InternetBill", objApartment.InternetBill);
            objDbCommand.AddInParameter("Description", objApartment.Description);
            objDbCommand.AddInParameter("VacancyStatusId", objApartment.VacancyStatusId);



            try
            {
                noOfAffacted = objDataAccess.ExecuteNonQuery(objDbCommand, "ams.uspInsertApartmentDetailInfo", CommandType.StoredProcedure);
                //   apartmentId = Convert.ToInt32(objDbCommand.Parameters["ApartmentId"].Value.ToString());



                //noOfAffacted += PropertyFacilityTypeBiz.SaveFacilities(objDataAccess, objDbCommand, objApartment.PropertyFacilityTypeList, propertyId);
                //noOfAffacted += PropertySecurityTypeBiz.SaveSecurities(objDataAccess, objDbCommand, objApartment.PropertySecurityTypeList, propertyId);

                if (noOfAffacted > 0)
                {
                    objDbCommand.Transaction.Commit();
                    return(noOfAffacted);
                }
                else
                {
                    objDbCommand.Transaction.Rollback();
                    return(noOfAffacted);
                }
            }
            catch (Exception ex)
            {
                objDbCommand.Transaction.Rollback();
                throw new Exception("Database Error Occured", ex);
            }
            finally
            {
                objDataAccess.Dispose(objDbCommand);
            }
        }
예제 #3
0
        public int SavePropertyInfo(Property objProperty)
        {
            var noOfAffacted = 0;
            int propertyId;
            PropertyFacilityType objFacilityType;
            PropertySecurityType objSecurityType;

            //string spName = "";
            //if (referenceType==EnumBiz.ReferanceType.New.ToString())
            //{
            //    spName = "AHL.prInsertApllicant";
            //}
            objDataAccess = DataAccess.NewDataAccess();
            objDbCommand  = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
            objDbCommand.AddInOutParameter("PropertyId", objProperty.PropertyId, ParameterDirection.InputOutput, DbType.Int32, 16);
            objDbCommand.AddInParameter("PropertyName", objProperty.PropertyName.Trim());
            objDbCommand.AddInParameter("PropertyTypeId", objProperty.PropertyTypeId);
            objDbCommand.AddInParameter("LandloadId", objProperty.LandloadId.Trim());
            objDbCommand.AddInParameter("BuiltYear", objProperty.BuiltYear);
            objDbCommand.AddInParameter("CountryID", objProperty.CountryID);
            objDbCommand.AddInParameter("DivisionId", objProperty.DivisionId);
            objDbCommand.AddInParameter("DistrictId", objProperty.DistrictId);
            objDbCommand.AddInParameter("UpazilaId", objProperty.UpazilaId);
            objDbCommand.AddInParameter("HoldingNo", objProperty.HoldingNo);
            objDbCommand.AddInParameter("RoadNo", objProperty.RoadNo.Trim());
            objDbCommand.AddInParameter("SectorOrBlock", objProperty.SectorOrBlock.Trim());
            objDbCommand.AddInParameter("TotalSpace", objProperty.TotalSpace);
            objDbCommand.AddInParameter("NoOfFloors", objProperty.NoOfFloors);
            objDbCommand.AddInParameter("IsParkingAvailable", objProperty.IsParkingAvailable);
            if (objProperty.IsParkingAvailable)
            {
                objDbCommand.AddInParameter("TotalParkingSpace", objProperty.TotalParkingSpace);
            }



            try
            {
                noOfAffacted = objDataAccess.ExecuteNonQuery(objDbCommand, "ams.uspInsertPropertyDetailInfo", CommandType.StoredProcedure);
                propertyId   = Convert.ToInt32(objDbCommand.Parameters["PropertyId"].Value.ToString());



                noOfAffacted += PropertyFacilityTypeBiz.SaveFacilities(objDataAccess, objDbCommand, objProperty.PropertyFacilityTypeList, propertyId);
                noOfAffacted += PropertySecurityTypeBiz.SaveSecurities(objDataAccess, objDbCommand, objProperty.PropertySecurityTypeList, propertyId);

                if (noOfAffacted > 0)
                {
                    objDbCommand.Transaction.Commit();
                    return(noOfAffacted);
                }
                else
                {
                    objDbCommand.Transaction.Rollback();
                    return(noOfAffacted);
                }
            }
            catch (Exception ex)
            {
                objDbCommand.Transaction.Rollback();
                throw new Exception("Database Error Occured", ex);
            }
            finally
            {
                objDataAccess.Dispose(objDbCommand);
            }
        }