public async Task <int> CreateFlatSaleAsync(FlatSale flatSale, CancellationToken ct)
{
try
{
using var context = contextFactory.GetAdvContext();
await context.FlatSales.AddAsync(flatSale, ct).ConfigureAwait(false);
var result = await context.SaveChangesAsync(ct).ConfigureAwait(false);
return(result > 0 ? flatSale.Id : throw new BadCreateException("Мы не смогли создать объявление"));
}
catch (Exception e)
{
Debug.WriteLine(e);
throw;
}
}
// Save New Customer data (Booking or sale)
public HttpResponseMessage SaveCustomer(FlatSale newCust)
{
int ii = newCust.PlanID.Value;
try
{
if (newCust.AppTitle == null) newCust.AppTitle = "";
if (newCust.AppFName == null) newCust.AppFName = "";
if (newCust.AppMName == null) newCust.AppMName = "";
if (newCust.AppLName == null) newCust.AppLName = "";
if (newCust.CoTitle == null) newCust.CoTitle = "";
if (newCust.CoFName == null) newCust.CoFName = "";
if (newCust.CoMName == null) newCust.CoMName = "";
if (newCust.CoLName == null) newCust.CoLName = "";
DateTimeFormatInfo dtinfo = new DateTimeFormatInfo();
dtinfo.DateSeparator = "/";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
newCust.BookingDate = Convert.ToDateTime(newCust.SrtSaleDate, dtinfo);
//newCust.BookingDate = newCust.SaleDate;
int i = SbpEntity.INSERT_RBookFlat(newCust.FlatName, newCust.SaleDate, newCust.BookingAmount, newCust.AppFName, newCust.AppMName, newCust.AppLName, newCust.Title,
newCust.PName, newCust.Address1, newCust.Address2, newCust.City, newCust.Distt, newCust.State, newCust.Country, newCust.AppPAN, newCust.MobileNo, newCust.DateOfBirth,
newCust.CoFName, newCust.CoMName, newCust.CoLName, newCust.CoAddress1,
newCust.CoAddress2, newCust.CoCity, newCust.CoState, newCust.CoCountry, newCust.CoPAN, newCust.CoMobileNo, newCust.AlternateMobile, newCust.LandLine,
newCust.EmailID, newCust.AlternateEmail, newCust.LoanAmount, newCust.LienField, newCust.BankID, newCust.IsPAN,
newCust.IsPhoto, newCust.IsAddressPf, newCust.Type, newCust.CustomerID, newCust.SecCoFName, newCust.SecCoMName, newCust.SecCoLName, newCust.SecCoAddress1,
newCust.SecCoAddress2, newCust.SecCoCity, newCust.SecCoState, newCust.SecCoCountry, newCust.SecCoMobileNo, newCust.SecCoPAN,
newCust.CoTitle, newCust.CoPName, newCust.SecCoTitle, newCust.SecCoPName, newCust.IsConstruction, newCust.AppTitle, newCust.CoAppTitle, newCust.SecCoAppTitle, newCust.IsRationCard, newCust.IsDrivingLicence, newCust.IsVoterCard, newCust.IsPassport, newCust.PhotoImagePath, newCust.AddPfImagePath, newCust.DVImagePath, newCust.VoterCardImagePath, newCust.PassportImagePath,
newCust.RationCardImagePath, newCust.Remarks, newCust.CoDOB, newCust.SecCoDOB, newCust.PANImagePath, newCust.CoIsPAN, newCust.CoIsPhoto, newCust.CoIsAddressPf, newCust.CoIsRationCard, newCust.CoIsDrivingLicence, newCust.CoIsVoterCard, newCust.CoIsPassport, newCust.CoPhotoImagePath, newCust.CoAddPfImagePath, newCust.CoDVImagePath, newCust.CoVoterCardImagePath, newCust.CoPhotoImagePath,
newCust.CoRationCardImagePath, newCust.CoPANImagePath, newCust.SecCoIsPAN, newCust.SecCoIsPhoto, newCust.CoIsAddressPf, newCust.SecCoIsRationCard, newCust.SecCoIsDrivingLicence, newCust.SecCoIsVoterCard, newCust.SecCoIsPassport, newCust.SecCoPhotoImagePath,
newCust.SecCoAddPfImagePath, newCust.SecCoDVImagePath, newCust.SecCoVoterCardImagePath, newCust.SecCoPhotoImagePath, newCust.SecCoRationCardImagePath, newCust.SecCoPhotoImagePath, newCust.BankBranch, newCust.PinCode, newCust.ExecutiveName, newCust.CoPinCode, newCust.SecCoPinCode, newCust.TransferAmount, newCust.affidavit, newCust.PropertyID, newCust.PaymentFor, newCust.BookingDate, newCust.PropertyTypeID, newCust.PropertySizeID, newCust.PlanID, User.Identity.Name, newCust.SaleRate, newCust.SaleRateInWords);
DataTable dt = obj.GetDataTable("select FlatID from tblsFlat where FlatName='" + newCust.FlatName + "' and PID='" + newCust.PropertyID + "' and Status=1");
if (dt.Rows.Count > 0)
{
Session["FlatId"] = dt.Rows[0]["FlatID"].ToString();
}
else
{
Session["FlatId"] = newCust.FlatID;
}
Session["PID"] = newCust.PropertyID;
Session["FlatName"] = newCust.FlatName;
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
}
return new HttpResponseMessage(HttpStatusCode.Created);
}