public ActionResult AddPurchase(string request)
{
tbl_Sale tbl_Sale = JsonConvert.DeserializeObject <tbl_Sale>(request);
if (SalesItemStock.Count > 0)
{
var t = JsonConvert.SerializeObject(tbl_Sale);
db.tbl_Sale.Add(tbl_Sale);
db.SaveChanges();
SalesItemStock.ForEach(q => q.tbl_Items = null);
db.tbl_ItemStock.AddRange(SalesItemStock);
db.SaveChanges();
tbl_Sequence NewSequenceValue = Helper.GenericHelper.GetNextUpdatedData("tbl_Sale");
db.Entry(NewSequenceValue).State = EntityState.Modified;
//db.SaveChanges();
tbl_Sequence NewSequenceValueItemStock = Helper.GenericHelper.GetNextUpdatedData("tbl_ItemStock");
db.Entry(NewSequenceValueItemStock).State = EntityState.Modified;
db.SaveChanges();
//return RedirectToAction("Index");
return(JavaScript("window.location = '/Sale/index'"));
}
else
{
ViewBag.CustomerID = new SelectList(db.tbl_vendor, "CustomerID", "Name", tbl_Sale.CustomerID);
throw new InvalidOperationException("Please add item to continue!!");
}
//return RedirectToAction("Index");
}
public static void printDuplicateRecipt(int saleId)
{
tbl_Sale sale = Sale.getById(saleId);
tbl_Customer customer = Customer.getById((int)sale.Customer_Id);
List <tbl_SaleItem> soldItems = SaleItem.getAllBySaleId(saleId);
List <ItemOrDealSaleModel> allMappedItems = Sale.getMappedListofDealsAndItemsToItemOrDealSaleModel();
List <ItemOrDealSaleModel> newSaleList = new List <ItemOrDealSaleModel>();
foreach (tbl_SaleItem item in soldItems)
{
ItemOrDealSaleModel s = new ItemOrDealSaleModel();
ItemOrDealSaleModel s1 = allMappedItems.Where(a => a.Id == (int)item.Item_id).FirstOrDefault();
s.Id = s1.Id;
s.Name = s1.Name;
s.Quantity = (int)item.Quantity;
s.SalePrice = s1.SalePrice;
s.Total = s1.SalePrice * s.Quantity;
newSaleList.Add(s);
}
//int salesId, List< ItemOrDealSaleModel > list, int totalBill,int remaining, int saleType,string customerAddress
string customerAddress;
if (customer != null)
{
customerAddress = customer.Address + " " + customer.PhoneNo;
}
else
{
customerAddress = "";
}
PrintingUtils.printSaleReceipt(sale.Id, newSaleList, (int)sale.Amount, 0, (int)sale.SaleType, customerAddress);
}
private void btn_SaleDetails(object sender, RoutedEventArgs e)
{
if (dg_AllSales.SelectedItem != null)
{
tbl_Sale sale = (tbl_Sale)dg_AllSales.SelectedItem;
new Form_SaleDetails(sale.Id).Show();
}
}
public static void deleteASaleById(int saleId)
{
RMSDBEntities db = DBContext.getInstance();
tbl_Sale sale = db.tbl_Sale.Find(saleId);
db.tbl_Sale.Remove(sale);
db.SaveChanges();
SaleItem.deleteSaleItemsBySaleId(saleId);
}
public static void performANewSale(List <ItemOrDealSaleModel> saleList, double discount, int totalBill, int remaining, int customerId, bool receipt1, bool receipt2, bool receipt3, int saletype, string customerAddress, int deliveryBoyId)
{
RMSDBEntities db = DBContext.getInstance();
tbl_Sale sale = new tbl_Sale();
sale.Staff_id = 0;
sale.Date_Time = DateTime.Now;
tbl_Customer c = Customer.getById(customerId);
if (c != null)
{
sale.Customer_Id = customerId;
}
sale.Amount = totalBill;
sale.SaleType = saletype;
db.tbl_Sale.Add(sale);
db.SaveChanges();
//3 is for delivery. therefor we have to add in Delivery Queue
if (saletype == 3)
{
tbl_DeliveryQueue dq = new tbl_DeliveryQueue();
dq.Customer_Id = customerId;
dq.Sale_Id = sale.Id;
dq.Delivered = false;
dq.DatenTime = DateTime.Now;
if (deliveryBoyId != 0)
{
dq.DeliveryBoyId = deliveryBoyId;
}
DeliveryQueue.insert(dq);
}
// printing
if (receipt1)
{
PrintingUtils.printSaleReceipt(sale.Id, saleList, totalBill, remaining, saletype, customerAddress);
}
if (receipt2)
{
PrintingUtils.printSaleReceipt(sale.Id, saleList, totalBill, remaining, saletype, customerAddress);
}
if (receipt3)
{
PrintingUtils.printSaleReceipt(sale.Id, saleList, totalBill, remaining, saletype, customerAddress);
}
foreach (ItemOrDealSaleModel item in saleList)
{
tbl_SaleItem saleItem = new tbl_SaleItem();
saleItem.Item_id = item.Id;
saleItem.Sale_id = sale.Id;
saleItem.Quantity = item.Quantity;
SaleItem.insert(saleItem);
}
DetuctInventory.detuctInventoryOfList(saleList);
}
public async Task <ActionResult> DeleteConfirmed(string id)
{
tbl_Sale tbl_Sale = await db.tbl_Sale.FindAsync(id);
db.tbl_Sale.Remove(tbl_Sale);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "AutoID,SaleID,InvoiceID,InvoiceDate,CustomerID,DiscountAfterTax,OtherChargeAfterTax,SubTotal,Tax,TotalValueafterTax,GrandTotal,CreatedDatetime")] tbl_Sale tbl_Sale)
{
if (ModelState.IsValid)
{
db.Entry(tbl_Sale).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.tbl_vendor, "ID", "Name", tbl_Sale.CustomerID);
return(View(tbl_Sale));
}
public static int getAmmountOfDeliveryOfaBoyWithDate(int deleiveryBoyId, DateTime fromDate, DateTime toDate)
{
RMSDBEntities db = DBContext.getInstance();
List <tbl_DeliveryQueue> list = db.tbl_DeliveryQueue.Where(a => a.DeliveryBoyId == deleiveryBoyId).Where(a => a.DatenTime >= fromDate).Where(a => a.DatenTime <= toDate).ToList();
int ammount = 0;
foreach (tbl_DeliveryQueue item in list)
{
tbl_Sale sale = Sale.getById((int)item.Sale_Id);
ammount += (int)sale.Amount;
}
return(ammount);
}
// GET: Sale/Details/5
public async Task <ActionResult> Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Sale tbl_Sale = await db.tbl_Sale.FindAsync(id);
if (tbl_Sale == null)
{
return(HttpNotFound());
}
return(View(tbl_Sale));
}
// GET: Sale/Edit/5
public async Task <ActionResult> Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Sale tbl_Sale = await db.tbl_Sale.FindAsync(id);
if (tbl_Sale == null)
{
return(HttpNotFound());
}
ViewBag.CustomerID = new SelectList(db.tbl_vendor, "ID", "Name", tbl_Sale.CustomerID);
return(View(tbl_Sale));
}
void initFormOperations(int saleId)
{
tbl_Sale sale = Sale.getById(saleId);
dg_ItemPurchased.ItemsSource = SaleItem.getAllBySaleId(saleId);
tbl_Customer customer = Customer.getById((int)sale.Customer_Id);
if (customer != null)
{
lbl_CustomerName.Content = customer.Name;
}
lbl_SaleId.Content = saleId;
lbl_Date.Content = ((DateTime)sale.Date_Time).ToShortDateString();
lbl_Total.Content = sale.Amount;
}
public static List <DeliveryQueueModel> getAllNotDeliveredMappedToDeliveryQueueModel()
{
List <DeliveryQueueModel> list = new List <DeliveryQueueModel>();
foreach (tbl_DeliveryQueue item in getAllNotDelivered())
{
DeliveryQueueModel dmq = new DeliveryQueueModel();
dmq.Id = item.Id;
dmq.SaleId = (int)item.Sale_Id;
dmq.CustomerId = (int)item.Customer_Id;
tbl_Sale sale = Sale.getById(dmq.SaleId);
dmq.TotalBill = (int)sale.Amount;
try
{
tbl_Staff staff = Staff.getById((int)item.DeliveryBoyId);
dmq.DeliveryBoyName = staff.Name;
} catch { }
list.Add(dmq);
}
return(list);
}
