public JsonResult GetProductByConsainmentNumberForSale(string consignmentNumber)
{
SaleBLL objSaleBLL = new SaleBLL();
var product = objSaleBLL.GetProductByConsainmentNumberForSale(consignmentNumber);
return(Json(product, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCustomerDueAmount(int id)
{
SaleBLL objSaleBLL = new SaleBLL();
var data = objSaleBLL.GetCustomerDueAmount(id);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductNameByConsignment(string truck, string consignmentNumber)
{
SaleBLL objSaleBLL = new SaleBLL();
var productName = objSaleBLL.GetProductNameByConsignment(truck, consignmentNumber);
return(Json(productName, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUnitBagKgPriceByProdcutName(int productId, string consignmentNumber)
{
SaleBLL objSaleBLL = new SaleBLL();
var productDetail = objSaleBLL.GetUnitBagKgPriceByProdcutName(productId, consignmentNumber);
return(Json(productDetail, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTruckNumberByConsainmentNumber(string consignmentNumber)
{
SaleBLL objSaleBLL = new SaleBLL();
var truckNumber = objSaleBLL.GetTruckNumberByConsainmentNumber(consignmentNumber);
return(Json(truckNumber, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTotalAmountByConsignment(string consignmentNumber)
{
SaleBLL objSaleBLL = new SaleBLL();
var saleDetail = objSaleBLL.GetTotalAmountByConsignmentNumber(consignmentNumber);
return(Json(saleDetail, JsonRequestBehavior.AllowGet));
}
public JsonResult AutoCompleteByConsignment(string term)
{
SaleBLL objSaleBLL = new SaleBLL();
List <String> result = new List <String>();
result = objSaleBLL.GetAllConsignmentNumber().Where(x => x.ConsignmentNumber.ToString().StartsWith(term)).Select(y => y.ConsignmentNumber.ToString()).Distinct().ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public FormCheckOut()
{
InitializeComponent();
_checkOutBLL = new CheckOutBLL();
_clientBLL = new ClientBLL();
_roomBLL = new RoomBLL();
_saleBLL = new SaleBLL();
sale = new Sale();
_checkIn = new CheckIn();
_sales = new List <Sale>();
}
// End Return Sale Part //
public ActionResult DemurageSale()
{
SaleBLL objSaleBLL = new SaleBLL();
List <CustomerDetail> CustomerNameList = objSaleBLL.GetAllCustomerName();
ViewBag.CustomerNameList = CustomerNameList;
ProductBLL objProductBll = new ProductBLL();
List <Product> ProductList = objProductBll.GetAllProduct();
ViewBag.productList = ProductList;
return(View());
}
// GET: Sale/Sale
public ActionResult Index()
{
SaleBLL objSaleBLL = new SaleBLL();
List <CustomerDetail> CustomerNameList = objSaleBLL.GetAllCustomerName();
ViewBag.CustomerNameList = CustomerNameList;
TruckDetailBLL objTruckDetailBLL = new TruckDetailBLL();
List <TruckDetail> truckDetailList = objTruckDetailBLL.GetAllTruckDetail();
ViewBag.truckList = truckDetailList;
return(View());
}
public FormRegisterSale()
{
InitializeComponent();
_clientBLL = new ClientBLL();
_checkinBLL = new CheckInBLL();
_checkIn = new CheckIn();
_roomBLL = new RoomBLL();
_productBLL = new ProductBLL();
_saleBLL = new SaleBLL();
_product = new Product();
_saleItems = new List <SaleItem>();
ClearNameProduct();
}
public ActionResult Save(SaleModel objSales)
{
bool status = false;
if (ModelState.IsValid)
{
SaleBLL objSaleBLL = new SaleBLL();
SaleModel objSaleModel = new SaleModel();
SaleDetail objSaleDetail = new SaleDetail();
objSaleDetail.Sales.ConsignmentNumber = objSales.ConsignmentNumber;
objSaleDetail.Sales.SellingDate = objSales.SellingDate;
objSaleDetail.Sales.SellingAmount = objSales.SellingAmount;
objSaleDetail.Sales.PaidAmount = objSales.PaidAmount;
objSaleDetail.Sales.AdjustmentAmount = objSales.AdjustmentAmount;
objSaleDetail.Sales.TotalAmount = objSales.TotalAmount;
objSaleDetail.Sales.PaymentMethod = objSales.PaymentMethod;
objSaleDetail.Sales.OrderNumber = objSales.OrderNumber;
objSaleDetail.Sales.ChequeNumber = objSales.ChequeNumber;
objSaleDetail.Sales.TTNUmber = objSales.TTNUmber;
objSaleDetail.Sales.CustomerId = objSales.CustomerId;
objSaleDetail.Sales.Remarks = objSales.Remarks;
foreach (SaleDetail pd in objSales.SaleDetails)
{
objSaleDetail.ProductId = pd.ProductId;
objSaleDetail.TruckNumber = pd.TruckNumber;
objSaleDetail.SalePrice = pd.SalePrice;
objSaleDetail.SaleUnitBag = pd.SaleUnitBag;
objSaleDetail.SaleUnitKG = pd.SaleUnitKG;
objSaleBLL.SaveSale(objSaleDetail);
objSaleDetail.Sales.CustomerId = 0;
status = true;
}
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult StockHandforBag(int?saleUnitBag, int?saleUnitKg, string productName)
{
SaleBLL objSaleBLL = new SaleBLL();
if (saleUnitBag > 0)
{
var data = objSaleBLL.GetTotalBag(saleUnitBag, saleUnitKg, productName);
return(Json(data, JsonRequestBehavior.AllowGet));
}
else if (saleUnitKg > 0)
{
var data = objSaleBLL.GetTotalBag(saleUnitBag, saleUnitKg, productName);
return(Json(data, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult DemurrageSave(SaleModel objSales)
{
bool status = false;
//if (ModelState.IsValid)
//{
SaleBLL objSaleBLL = new SaleBLL();
SaleModel objSaleModel = new SaleModel();
SaleDetail objSaleDetail = new SaleDetail();
objSaleDetail.Sales.ConsignmentNumber = objSales.ConsignmentNumber;
objSaleDetail.Sales.CustomerId = objSales.CustomerId;
objSaleDetail.Sales.SellingDate = objSales.SellingDate;
objSaleDetail.Sales.TotalReturnAmount = objSales.TotalReturnAmount;
objSaleDetail.Sales.TotalAmount = objSales.TotalAmount;
objSaleDetail.Sales.Remarks = objSales.Remarks;
foreach (SaleDetail pd in objSales.SaleDetails)
{
objSaleDetail.ProductId = pd.ProductId;
objSaleDetail.TruckNumber = pd.TruckNumber;
objSaleDetail.ReturnSaleUnitBag = pd.ReturnSaleUnitBag;
objSaleDetail.ReturnSaleUnitKG = pd.ReturnSaleUnitKG;
objSaleDetail.SalePrice = pd.SalePrice;
objSaleBLL.DemurrageSave(objSaleDetail);
objSaleDetail.Sales.CustomerId = 0;
status = true;
}
//}
//else
//{
// status = false;
//}
return(new JsonResult {
Data = new { status = status }
});
//return RedirectToAction("Index", "Purchase");
}
public void createSale()
{
Console.Clear();
System.Console.WriteLine("New Sale\n\n");
SaleBO sale = new SaleBO();
SaleBLL saleB = new SaleBLL();
int id = saleB.readId();
System.Console.WriteLine("Sales ID: " + id);
DateTime thisDay = DateTime.Today;
System.Console.WriteLine("Sales Date: " + thisDay.ToString("dd/MM/yyyy"));
System.Console.Write("Enter CustomerID: ");
int custid;
String c = System.Console.ReadLine();
if (c.Length != 0)
{
custid = int.Parse(c);
}
else
{
custid = 0;
}
CustomerBLL custB = new CustomerBLL();
CustomerBO custO = custB.find(custid);
int choice = 0;
if (custO.Custid != 0)
{
List <SaleLineItemBO> lineList = new List <SaleLineItemBO>();
SaleLineItemBLL lineBI = new SaleLineItemBLL(); //I-initial
SaleLineItemBO lineitemI = makenewSale();
if (lineitemI.Itemid != 0)
{
lineitemI.Lineid = lineBI.readId();
lineitemI.Orderid = id;
lineitemI.Amount = lineBI.calculatesubTotal(lineitemI);
System.Console.WriteLine("Sub-Total: Rs." + lineitemI.Amount);
lineList.Add(lineitemI);
}
while (choice != 4)
{
System.Console.WriteLine("\nPress 1 to Enter New Item");
System.Console.WriteLine("Press 2 to End Sale");
System.Console.WriteLine("Press 3 to Remove an existing Item from the current sale");
System.Console.WriteLine("Press 4 to Cancel Sale");
System.Console.WriteLine("Choose from option 1 – 4:");
System.Console.Write("Enter Choice: ");
c = System.Console.ReadLine();
if (c.Length != 0)
{
choice = int.Parse(c);
}
else
{
choice = 0;
}
while (choice < 1 || choice > 4)
{
System.Console.Write("InValid Choice! Enter again: ");
c = System.Console.ReadLine();
if (c.Length != 0)
{
choice = int.Parse(c);
}
else
{
choice = 0;
}
}
if (choice == 1)
{
SaleLineItemBLL lineB = new SaleLineItemBLL();
SaleLineItemBO lineitem = makenewSale();
if (lineitem.Itemid != 0)
{
lineitem.Lineid = lineB.readId();
lineitem.Orderid = id;
lineitem.Amount = lineB.calculatesubTotal(lineitem);
System.Console.WriteLine("Sub-Total: Rs." + lineitem.Amount);
lineList.Add(lineitem);
}
}
else if (choice == 2)
{
SaleLineItemBLL lineB = new SaleLineItemBLL();
if (lineList.Count > 0)
{
sale.Orderid = id;
sale.Date = thisDay.ToString("dd/MM/yyyy");
sale.Custid = custO.Custid;
sale.Total = saleB.calculateTotal(lineList);
if (saleB.checkSaleLimit(sale))
{
lineB.save(lineList);
saleB.save(sale);
displayInvoice(sale, lineList);
}
else
{
Console.Clear();
System.Console.WriteLine("\n\n\n\n\n\n ***Error! Sale Limit Exceeded***");
System.Threading.Thread.Sleep(2000);
}
}
break;
}
else if (choice == 3)
{
int itemid; bool flag = true;
System.Console.Write("\nEnter ItemID to be removed: ");
c = System.Console.ReadLine();
if (c.Length != 0)
{
itemid = int.Parse(c);
}
else
{
itemid = 0;
}
List <SaleLineItemBO> removeList = new List <SaleLineItemBO>();
foreach (var line in lineList)
{
if (line.Itemid == itemid)
{
removeList.Add(line);
flag = false;
}
}
foreach (var line in removeList)
{
lineList.Remove(line);
}
if (flag)
{
System.Console.WriteLine("Error! Item not included in sale");
}
}
}
}
else
{
Console.Clear();
System.Console.WriteLine("\n\n\n\n\n\n ***Error! Customer Not Found***");
System.Threading.Thread.Sleep(2000);
}
}
public void makepayment()
{
Console.Clear();
System.Console.WriteLine("Payment\n\n");
ReceiptBO rec = new ReceiptBO();
ReceiptBLL recB = new ReceiptBLL();
int recid = recB.readId();
DateTime thisDay = DateTime.Today;
System.Console.Write("Enter SaleID: ");
int saleid;
String c = System.Console.ReadLine();
if (c.Length != 0)
{
saleid = int.Parse(c);
}
else
{
saleid = 0;
}
SaleBLL saleB = new SaleBLL();
SaleBO saleO = saleB.find(saleid);
CustomerBLL custB = new CustomerBLL();
CustomerBO custO = custB.find(saleO.Custid);
if (saleO.Orderid != 0)
{
double amountpaid = recB.amountpaid(saleid);
double remain = saleO.Total - amountpaid;
System.Console.WriteLine("Customer Name: " + custO.Name);
System.Console.WriteLine("Total Sales Amount: " + saleO.Total);
System.Console.WriteLine("Amount paid: " + amountpaid);
System.Console.WriteLine("Remaining Amount: " + remain);
System.Console.Write("Enter Amount: ");
double amt;
c = System.Console.ReadLine();
if (c.Length != 0)
{
amt = double.Parse(c);
}
else
{
amt = 0;
}
while (amt < 0 || amt > remain)
{
System.Console.Write("InValid Amount! Enter again: ");
c = System.Console.ReadLine();
if (c.Length != 0)
{
amt = double.Parse(c);
}
else
{
amt = 0;
}
}
if (remain > 0)
{
custO.Amount = custO.Amount - amt;
custB.modify(custO);
rec.Receiptid = recid;
rec.Orderid = saleid;
rec.Amountpaid = amt;
recB.save(rec);
}
else
{
System.Console.WriteLine("Back to Main Menu...");
System.Threading.Thread.Sleep(2000);
}
}
}
public FormSearchSale()
{
InitializeComponent();
_productBLL = new ProductBLL();
_saleBLL = new SaleBLL();
}
