public ActionResult Create(Sale sale)
{
if (sale.IdSale > 0)
{
Sale currentSale = db.Sale.Find(sale.IdSale);
int companyId = (int)Session["idCompany"];
string[] productsInCookie = Request.Cookies["products"].Value.Split('/');
if (productsInCookie == null || (productsInCookie.Length == 1 && string.IsNullOrEmpty(productsInCookie[0])) || productsInCookie.Length == 0)
{
//this sale has no product, so it will be deleted
Sale saleNoProducts = db.Sale.Find(sale.IdSale);
db.Sale.Remove(saleNoProducts);
db.SaveChanges();
TempData["message"] = "UNSAVED SALE";
}
else
{
List <SaleProduct> saleProducts = SalesProductsService.ReturnSaleProducts(productsInCookie, companyId, sale.IdSale);
decimal TotalPrice = SalesProductsService.GetTotalPrice(saleProducts);
db.SaleProduct.AddRange(saleProducts);
db.SaveChanges();
currentSale.TotalPrice = TotalPrice;
db.SaveChanges();
TempData["message"] = "SALE SAVED WITH PENDING STATUS";
}
return(RedirectToAction("Index"));
}
return(View(sale));
}
public ActionResult Create([Bind(Include = "SaleId,TypePayment,DebitCardId,CreditCardId,CompanyId,forecastDatePayment,InstallmentNumber,CodePaymentCard,DiscontApply")] Payment payment)
{
string[] productsInCookie = Request.Cookies["products"].Value.Split('/');
int companyId = (int)Session["idCompany"];
List <SaleProduct> saleProducts = SalesProductsService.ReturnSaleProducts(productsInCookie, companyId, payment.SaleId);
decimal TotalPrice = SalesProductsService.GetTotalPrice(saleProducts);
if (payment.DiscontApply != null)
{
TotalPrice -= Convert.ToDecimal(payment.DiscontApply);
}
if (payment.SaleId > 0)
{
int idUser = (int)Session["idUser"]; //who is login
Sale sale = db.Sale.Find(payment.SaleId);
if (sale != null)
{
using (var trans = db.Database.BeginTransaction())
{
try
{
if (payment.TypePayment == (TypePayment)2 || payment.TypePayment == (TypePayment)3)
{
#region SALE ON CARD
if (payment.CreditCardId > 0)
{
#region CREDIT SALE
CreditCard card = db.CreditCard.Find(payment.CreditCardId);
List <Payment> installmentSale = new List <Payment>();
List <Log> logs = new List <Log>();
if (payment.InstallmentNumber == 0)
{
payment.InstallmentNumber = 1;
}
decimal tax = ((TotalPrice / payment.InstallmentNumber) * card.RateCreditCard) / 100;
decimal installment = Math.Round((TotalPrice / payment.InstallmentNumber) - tax, 2);
#region CREATE CREATE PAYMENT FOR EACH INSTALLMENT
for (int i = 1; i <= payment.InstallmentNumber; i++)
{
int days = 30 * i;
int status = card.Company.FlAuthoritativeReceipt ? 1 : 2; //Pay or Payable
Payment pay = new Payment
{
SaleId = payment.SaleId,
Created = payment.Created,
EmployeeId = idUser,
CreditCardId = payment.CreditCardId,
CompanyId = payment.CompanyId,
TypePayment = payment.TypePayment,
Status = (StatusPayment)status,
InstallmentNumber = i,
CodePaymentCard = payment.CodePaymentCard,
TotalPrice = TotalPrice,
InstallmentPrice = installment,
forecastDatePayment = DateTime.Now.AddDays(days),
DiscontApply = payment.DiscontApply
};
installmentSale.Add(pay);
}
db.Payment.AddRange(installmentSale);
db.SaveChanges();
#endregion
#region CREATE LOGS
for (int i = 0; i < installmentSale.Count; i++)
{
Log log = new Log
{
//[C] in DB refers to an Create
New = "[C]" + installmentSale[i].TypePayment + " " + installmentSale[i].CreditCardId + " " + installmentSale[i].InstallmentNumber + " " + installmentSale[i].forecastDatePayment + " " + installmentSale[i].InstallmentPrice + " " + installmentSale[i].TotalPrice + " " + installmentSale[i].Status,
Who = idUser,
PaymentId = installmentSale[i].IdPayment,
SaleId = installmentSale[i].SaleId,
CompanyId = installmentSale[i].CompanyId
};
logs.Add(log);
}
db.Log.AddRange(logs);
db.SaveChanges();
#endregion
#endregion //CREDIT SALE
}
else if (payment.DebitCardId > 0)
{
#region DEBIT SALE
DebitCard card = db.DebitCard.Find(payment.DebitCardId);
payment.EmployeeId = idUser;
payment.Status = card.Company.FlAuthoritativeReceipt ? (StatusPayment)1 : (StatusPayment)2; //Pay or Payable
payment.InstallmentNumber = 0;
payment.forecastDatePayment = payment.Created.Date.AddDays(1);
payment.TotalPrice = TotalPrice;
decimal tax = (TotalPrice * card.Rate) / 100;
decimal installment = Math.Round(TotalPrice - tax, 2);
payment.InstallmentPrice = installment;
db.Payment.Add(payment);
db.SaveChanges();
Log log = new Log
{
//[C] in DB refers to an Create
New = "[C]" + payment.TypePayment + " " + payment.CreditCardId + " " + payment.InstallmentNumber + " " + payment.Status,
Who = idUser,
PaymentId = payment.IdPayment,
SaleId = payment.SaleId,
CompanyId = payment.CompanyId,
};
db.Log.Add(log);
db.SaveChanges();
#endregion
}
else
{
trans.Rollback();
ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER";
goto ReturnIfError;
}
#endregion //SALE ON CARD
}
else
{
#region CASH SALE
payment.EmployeeId = idUser;
payment.Status = (StatusPayment)1; //Pay
payment.InstallmentNumber = 0;
payment.forecastDatePayment = payment.Created.Date;
payment.TotalPrice = TotalPrice;
payment.InstallmentPrice = TotalPrice;
db.Payment.Add(payment);
db.SaveChanges();
Log log = new Log
{
//[C] in DB refers to an Create
New = "[C]" + payment.TypePayment + " " + payment.CreditCardId + " " + payment.InstallmentNumber + " " + payment.Status,
Who = idUser,
PaymentId = payment.IdPayment,
SaleId = payment.SaleId,
CompanyId = payment.CompanyId,
};
db.Log.Add(log);
db.SaveChanges();
#endregion
}
sale.TotalPrice = TotalPrice;
sale.Status = (SaleStatus)2; //FINISHED
db.SaveChanges();
trans.Commit();
TempData["confirm"] = "SALE SAVED WITH FINISHED STATUS";
return(RedirectToAction("Index", "Sales"));
}
catch
{
trans.Rollback();
ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER";
goto ReturnIfError;
}
}
}
}
ReturnIfError:
int permission = (int)Session["permission"];
int idCompany = (int)Session["idCompany"];
if (Check.IsSuperAdmin(permission))
{
ViewBag.CompanyId = new SelectList(db.Company, "IdCompany", "NameCompany", payment.CompanyId);
ViewBag.CreditCardId = new SelectList(db.CreditCard, "IdCreditCard", "NameCreditCard", payment.CreditCardId);
ViewBag.DebitCardId = new SelectList(db.DebitCard, "IdDebitCard", "NameDebitCard", payment.DebitCardId);
}
else if (Check.IsSupervisor(permission))
{
Company company = db.Company.Where(c => c.IdCompany == idCompany).FirstOrDefault();
List <Company> companies = new List <Company>();
companies.Add(company);
ViewBag.CompanyId = new SelectList(companies, "IdCompany", "NameCompany", idCompany);
ViewBag.CreditCardId = new SelectList(db.CreditCard.Where(c => c.CompanyId == idCompany), "IdCreditCard", "NameCreditCard", payment.CreditCardId);
ViewBag.DebitCardId = new SelectList(db.DebitCard.Where(c => c.CompanyId == idCompany), "IdDebitCard", "NameDebitCard", payment.DebitCardId);
}
IEnumerable <SelectListItem> typePayment = new SelectList(Enum.GetValues(typeof(TypePayment)));
ViewBag.TypePayment = typePayment;
ViewBag.SaleId = new SelectList(db.Sale, "IdSale", "IdSale", payment.SaleId);
return(View(payment));
}