public bool ConvertToBook(App_Sale saleRequest) { var parmsCollection = new ParmsCollection(); var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[convertTobook]", parmsCollection .AddParm("@ReserveID", SqlDbType.Int, saleRequest.ReserveID) .AddParm("@SaleID", SqlDbType.Int, saleRequest.SaleID) .AddParm("@UnitID", SqlDbType.Int, saleRequest.UnitID) .AddParm("@BookStartDate", SqlDbType.DateTime, saleRequest.ReserveDate) .AddParm("@BookEndDate", SqlDbType.DateTime, saleRequest.ExpiryDate) .AddParm("@Remark", SqlDbType.NVarChar, saleRequest.Remark) .AddParm("@BookAmt", SqlDbType.Int, saleRequest.BookAmt) .AddParm("@ReferenceNo", SqlDbType.NVarChar, saleRequest.ReferenceNo) .AddParm("@PayMethod", SqlDbType.Int, saleRequest.PayMethod) .AddParm("@CurrencyID", SqlDbType.Int, saleRequest.CurrencyID) .AddParm("@BankAccountID", SqlDbType.Int, saleRequest.BankAccountID) .AddParm("@CreatedBy", SqlDbType.Int, saleRequest.CreateUserID) ); return(true); }
public IActionResult ConvertToSale([FromBody] App_Sale saleRequest) { saleRequest.SaleAgentID = this.userContext.SaleAgentId; saleRequest.CreateUserID = this.userContext.LoggedInUserId; saleRequest.CreateDate = DateTime.Now; saleRequest.ModifyUserID = this.userContext.LoggedInUserId; saleRequest.ModifyDate = DateTime.Now; return(Ok(propertyBusinessAccess.ConvertToSale(saleRequest))); }
public IActionResult AddAppSale([FromBody] App_Sale sale) { sale.SaleAgentID = this.userContext.SaleAgentId; sale.CreateUserID = this.userContext.LoggedInUserId; sale.CreateDate = DateTime.Now; sale.ModifyUserID = this.userContext.LoggedInUserId; sale.ModifyDate = DateTime.Now; return(Ok(propertyBusinessAccess.AddAppSale(sale))); }
public bool ConvertToSale(App_Sale saleRequest) { var parmsCollection = new ParmsCollection(); var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[convertToSale]", parmsCollection .AddParm("@SaleID", SqlDbType.Int, saleRequest.SaleID) .AddParm("@UnitID", SqlDbType.Int, saleRequest.UnitID) .AddParm("@SaleDate", SqlDbType.DateTime, saleRequest.SaleDate) .AddParm("@Remark", SqlDbType.NVarChar, saleRequest.Remark) .AddParm("@CreatedBy", SqlDbType.Int, saleRequest.CreateUserID) ); return(true); }
public bool CancelBooking(App_Sale saleRequest) { var parmsCollection = new ParmsCollection(); var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[cancelBooking]", parmsCollection .AddParm("@ReserveID", SqlDbType.Int, saleRequest.ReserveID) .AddParm("@SaleID", SqlDbType.Int, saleRequest.SaleID) .AddParm("@Remark", SqlDbType.NVarChar, saleRequest.Remark) .AddParm("@cancelReasonId", SqlDbType.Int, saleRequest.CancelReasonId) .AddParm("@createdBy", SqlDbType.Int, saleRequest.CreateUserID) ); return(true); }
public bool AddAppSale(App_Sale sale) { var parmsCollection = new ParmsCollection(); var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[addApp_Sale]", parmsCollection .AddParm("@RowID", SqlDbType.Int, sale.RowID) .AddParm("@AppProspectID", SqlDbType.VarChar, sale.AppProspectID) .AddParm("@AccountNo", SqlDbType.VarChar, sale.AccountNo) .AddParm("@ProspectID", SqlDbType.Int, sale.ProspectID) .AddParm("@AccountID", SqlDbType.Int, sale.AccountID) .AddParm("@CompanyID", SqlDbType.Int, sale.CompanyID) .AddParm("@ProjectID", SqlDbType.Int, sale.ProjectID) .AddParm("@PhaseID", SqlDbType.Int, sale.PhaseID) .AddParm("@BlockID", SqlDbType.Int, sale.BlockID) .AddParm("@UnitID", SqlDbType.Int, sale.UnitID) .AddParm("@UnitNo", SqlDbType.VarChar, sale.UnitNo) .AddParm("@CustomerName", SqlDbType.NVarChar, sale.CustomerName) .AddParm("@MobilePhone", SqlDbType.NVarChar, sale.MobilePhone) .AddParm("@Email", SqlDbType.VarChar, sale.Email) .AddParm("@ReserveDate", SqlDbType.DateTime, (sale.ReserveDate == default(DateTime) ? DateTime.Now.Date : sale.ReserveDate.Date)) .AddParm("@ExpiryDate", SqlDbType.DateTime, ((sale.ExpiryDate == default(DateTime) || !sale.ExpiryDate.HasValue) ? ((sale.ReserveDate == default(DateTime) ? DateTime.Now.Date : sale.ReserveDate.Date)).AddDays(5) : sale.ExpiryDate.Value.Date)) .AddParm("@Remark", SqlDbType.VarChar, sale.Remark) .AddParm("@SaleAgentID", SqlDbType.Int, userContext.SaleAgentId) .AddParm("@ApproveByID", SqlDbType.Int, userContext.SaleAgentId) .AddParm("@ApproveDate", SqlDbType.DateTime, DateTime.Now.Date) .AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId) .AddParm("@CreateDate", SqlDbType.DateTime, DateTime.Now) .AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId) .AddParm("@ModifyDate", SqlDbType.DateTime, DateTime.Now) .AddParm("@SaleType", SqlDbType.NVarChar, sale.SaleType) .AddParm("@BookAmt", SqlDbType.Int, sale.BookAmt) .AddParm("@ReferenceNo", SqlDbType.NVarChar, sale.ReferenceNo) .AddParm("@PayMethod", SqlDbType.Int, sale.PayMethod) .AddParm("@CurrencyID", SqlDbType.Int, sale.CurrencyID) .AddParm("@BankAccountID", SqlDbType.Int, sale.BankAccountID) ); return(true); }
public bool AddAppSale(App_Sale sale) { return(this.propertyDataAccess.AddAppSale(sale)); }
public bool ConvertToBook(App_Sale saleRequest) { return(this.propertyDataAccess.ConvertToBook(saleRequest)); }
public bool CancelBooking(App_Sale saleRequest) { return(this.propertyDataAccess.CancelBooking(saleRequest)); }