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