public int GetSalesmanId(VoyagerContext db, string salesman)
{
try
{
var id = db.Salesmen.Where(c => c.SalesmanName == salesman).FirstOrDefault().SalesmanId;
if (id > 0)
{
return(id);
}
else
{
Salesman sm = new Salesman {
SalesmanName = salesman
};
db.Salesmen.Add(sm); db.SaveChanges();
return(sm.SalesmanId);
}
}
catch (Exception)
{
Salesman sm = new Salesman {
SalesmanName = salesman
};
db.Salesmen.Add(sm); db.SaveChanges();
return(sm.SalesmanId);
}
}
public IActionResult Booking(HomeVM model)
{
//Kullanıcı loginse işlemi yap değilse login sayfasına yönlendir!!
if (HttpContext.User.Identity.IsAuthenticated)
{
Payment payment = new Payment();
payment.Price = 10;
_context.Payments.Add(payment);
_context.SaveChanges();
int passengerid = Convert.ToInt32(HttpContext.User.Claims.ToArray()[0].Value);
Trip trip = new Trip();
trip.DriverID = model.DriverID;
trip.DeparturePoint = model.Source;
trip.ArrivalPoint = model.Destination;
trip.PassengerID = passengerid;
trip.PaymentID = payment.ID;
_context.Trips.Add(trip);
_context.SaveChanges();
TempData["message"] = "Booking işlemi başarılı!";
return(RedirectToAction("Index", "Home"));
}
else
{
return(RedirectToAction("Index", "passengerlogin"));
}
}
public int CreatePurchaseTaxType(VoyagerContext db, ImportPurchase purchase, bool IsLocal = false)
{
//Calculate tax rate
int taxRate = 0;
taxRate = (int)((purchase.TaxAmt * 100) / purchase.CostValue);
if (IsLocal)
{
try
{
int id = db.PurchaseTaxTypes.Where(c => c.CompositeRate == taxRate).Select(c => c.PurchaseTaxTypeId).FirstOrDefault();
if (id == 0)
{
PurchaseTaxType taxType = new PurchaseTaxType {
CompositeRate = taxRate, TaxType = TaxType.GST, TaxName = "Input Tax GST(SGST+CGST) @" + taxRate
};
db.PurchaseTaxTypes.Add(taxType);
db.SaveChanges();
return(taxType.PurchaseTaxTypeId);
}
return(id);
}
catch (Exception)
{
PurchaseTaxType taxType = new PurchaseTaxType {
CompositeRate = taxRate, TaxType = TaxType.GST, TaxName = "Input Tax GST(SGST+CGST) @" + taxRate
};
db.PurchaseTaxTypes.Add(taxType);
db.SaveChanges();
return(taxType.PurchaseTaxTypeId);
}
}
try
{
int id = db.PurchaseTaxTypes.Where(c => c.CompositeRate == taxRate).Select(c => c.PurchaseTaxTypeId).FirstOrDefault();
if (id == 0)
{
PurchaseTaxType taxType = new PurchaseTaxType {
CompositeRate = taxRate, TaxType = TaxType.IGST, TaxName = "Input Tax IGST @" + taxRate
};
db.PurchaseTaxTypes.Add(taxType);
db.SaveChanges();
return(taxType.PurchaseTaxTypeId);
}
return(id);
}
catch (Exception)
{
PurchaseTaxType taxType = new PurchaseTaxType {
CompositeRate = taxRate, TaxType = TaxType.IGST, TaxName = "Input Tax IGST @" + taxRate
};
db.PurchaseTaxTypes.Add(taxType);
db.SaveChanges();
return(taxType.PurchaseTaxTypeId);
}
}
public ActionResult Create([Bind(Include = "SaleTaxTypeId,TaxName,TaxType,CompositeRate")] SaleTaxType saleTaxType)
{
if (ModelState.IsValid)
{
db.SaleTaxTypes.Add(saleTaxType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(saleTaxType));
}
public ActionResult Create([Bind(Include = "ImportPurchaseId,GRNNo,GRNDate,InvoiceNo,InvoiceDate,SupplierName,Barcode,ProductName,StyleCode,ItemDesc,Quantity,MRP,MRPValue,Cost,CostValue,TaxAmt,IsDataConsumed,ImportTime")] ImportPurchase importPurchase)
{
if (ModelState.IsValid)
{
db.ImportPurchases.Add(importPurchase);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(importPurchase));
}
public ActionResult Create([Bind(Include = "ImportSaleRegisterId,InvoiceNo,InvoiceType,InvoiceDate,Quantity,MRP,Discount,BasicRate,Tax,RoundOff,BillAmnt,PaymentType,ImportTime")] ImportSaleRegister importSaleRegister)
{
if (ModelState.IsValid)
{
db.ImportSaleRegisters.Add(importSaleRegister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(importSaleRegister));
}
public IActionResult Add(int id)
{
Comment comment = new Comment();
comment.TripID = id;
comment.Point = 0;
comment.Content = " ";
_context.Comments.Add(comment);
_context.SaveChanges();
return(RedirectToAction("Edit", "Comment", new { id = id }));
}
public ActionResult Create([Bind(Include = "StoreID,StoreCode,StoreName,Address,City,PinCode,PhoneNo,StoreManagerName,StoreManagerPhoneNo,PanNo,GSTNO,NoOfEmployees,OpeningDate,ClosingDate,Status")] Store store)
{
if (ModelState.IsValid)
{
db.Stores.Add(store);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(store));
}
public ActionResult Create([Bind(Include = "ImportSaleItemWiseId,InvoiceDate,InvoiceNo,InvoiceType,BrandName,ProductName,ItemDesc,HSNCode,Barcode,StyleCode,Quantity,MRP,Discount,BasicRate,Tax,SGST,CGST,LineTotal,RoundOff,BillAmnt,PaymentType,Saleman,IsDataConsumed,ImportTime")] ImportSaleItemWise importSaleItemWise)
{
if (ModelState.IsValid)
{
db.ImportSaleItemWises.Add(importSaleItemWise);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(importSaleItemWise));
}
public ActionResult Create([Bind(Include = "ImportInWardId,InWardNo,InWardDate,InvoiceNo,InvoiceDate,PartyName,TotalQty,TotalMRPValue,TotalCost,ImportDate")] ImportInWard importInWard)
{
if (ModelState.IsValid)
{
db.ImportInWards.Add(importInWard);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(importInWard));
}
public ActionResult Create([Bind(Include = "ProductItemId,Barcode,BrandId,StyleCode,ProductName,ItemDesc,Categorys,MRP,TaxRate,Cost,Size,Units")] ProductItem productItem)
{
if (ModelState.IsValid)
{
db.ProductItems.Add(productItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BrandId = new SelectList(db.Brands, "BrandId", "BrandName", productItem.BrandId);
return(View(productItem));
}
public ActionResult Create([Bind(Include = "CustomerID,FirstName,LastName,Age,DateOfBirth,City,MobileNo,Gender,NoOfBills,TotalAmount,CreatedDate")] Customer customer)
{
if (ModelState.IsValid)
{
customer.CreatedDate = DateTime.Now;
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "ProductPurchaseId,InWardNo,InWardDate,PurchaseDate,InvoiceNo,TotalQty,TotalBasicAmount,ShippingCost,TotalTax,TotalAmount,Remarks,SupplierID,IsPaid")] ProductPurchase productPurchase)
{
if (ModelState.IsValid)
{
db.ProductPurchases.Add(productPurchase);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "SuppilerName", productPurchase.SupplierID);
return(View(productPurchase));
}
public ActionResult Create([Bind(Include = "StockID,ProductItemId,Quantity,SaleQty,PurchaseQty,Units")] Stock stock)
{
if (ModelState.IsValid)
{
db.Stocks.Add(stock);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductItemId = new SelectList(db.ProductItems, "ProductItemId", "Barcode", stock.ProductItemId);
return(View(stock));
}
public async Task <IActionResult> Index(PassengerLoginVM model)
{
if (ModelState.IsValid)
{
var passenger = _context.Passengers.FirstOrDefault(x => x.Email == model.Email && x.Password == model.Password);
if (passenger != null)
{
var claims = new List <Claim>
{
//new Claim(ClaimTypes.Email, model.Email),
new Claim(ClaimTypes.Sid, passenger.ID.ToString()),
new Claim(ClaimTypes.Name, passenger.Name),
new Claim(ClaimTypes.UserData, "User")
};
var userIdentity = new ClaimsIdentity(claims, "login");
ClaimsPrincipal principal = new ClaimsPrincipal(userIdentity);
await HttpContext.SignInAsync(principal);
/*passenger.LastLoginDate = DateTime.Now*/
_context.SaveChanges();
//TempData["UserID"] = HttpContext.User.Claims.ToArray()[0].Value;
//TempData["UserName"] = HttpContext.User.Claims.ToArray()[1].Value;
if (HttpContext.User.Identity.IsAuthenticated)
{
if (HttpContext.User.Claims.ToArray()[2].Value == "User")
{
TempData["UserID"] = HttpContext.User.Claims.ToArray()[0].Value;
TempData["UserName"] = HttpContext.User.Claims.ToArray()[1].Value;
}
}
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.error = "E-Mail or Password wrong!";
return(View());
}
}
else
{
return(View());
}
}
public IActionResult Edit(PassengerVM model)
{
Passenger passenger = _context.Passengers.FirstOrDefault(q => q.ID == model.ID);
if (ModelState.IsValid)
{
passenger.Name = model.Name;
passenger.Surname = model.Surname;
passenger.Email = model.Email;
passenger.Password = model.Password;
_context.SaveChanges();
return(View(model));
}
return(RedirectToAction("Index", "AdminPassenger"));
}
public int CreateSaleEntry(VoyagerContext db, DateTime onDate, AprajitaRetailsContext arDB)
{
int ctr = 0;
bool isVat = false;
if (onDate < new DateTime(2017, 7, 1))
{
isVat = true;
return(-1);// TODO: Temp implement for vat system
}
RegularInvoice saleInvoice = null;
var data = db.ImportSaleItemWises.Where(c => c.IsDataConsumed == false && c.InvoiceDate.Date == onDate.Date).OrderBy(c => c.InvoiceNo).ToList();
if (data != null)
{
foreach (var item in data)
{
saleInvoice = CreateSaleInvoice(db, arDB, item, saleInvoice); //Create SaleInvoice
saleInvoice.SaleItems.Add(CreateSaleItem(db, item)); // Create SaleItems
ctr++;
}
if (saleInvoice != null)
{
db.RegularInvoices.Add(saleInvoice); // Save Last Sale Invoice
db.SaveChanges();
CreateDailySale(arDB, db, saleInvoice); // Create DailySale Entry
}
return(ctr);
}
else
{
return(ctr);
}
}
public void CreateStockItem(VoyagerContext db, ImportPurchase purchase, int pItemId)
{
Stock stcks = db.Stocks.Where(c => c.ProductItemId == pItemId).FirstOrDefault();
if (stcks != null)
{
stcks.PurchaseQty += purchase.Quantity;
stcks.Quantity += purchase.Quantity;
db.Entry(stcks).State = EntityState.Modified;
}
else
{
Stock stock = new Stock
{
PurchaseQty = purchase.Quantity,
Quantity = purchase.Quantity,
ProductItemId = pItemId,
SaleQty = 0,
Units = db.ProductItems.Find(pItemId).Units,
StoreId = StoreID
};
db.Stocks.Add(stock);
}
db.SaveChanges();
}
public int CreateProductItem(VoyagerContext db, ImportPurchase purchase)
{
int barc = db.ProductItems.Where(c => c.Barcode == purchase.Barcode).Count();
if (barc <= 0)
{
ProductItem item = new ProductItem
{
Barcode = purchase.Barcode,
Cost = purchase.Cost,
MRP = purchase.MRP,
StyleCode = purchase.StyleCode,
ProductName = purchase.ProductName,
ItemDesc = purchase.ItemDesc,
BrandId = GetBrand(db, purchase.StyleCode),
};
//spliting ProductName
string[] PN = purchase.ProductName.Split('/');
// Apparel / Work / Blazers
if (PN[0] == "Apparel")
{
item.Units = Units.Pcs;
item.Categorys = ProductCategorys.ReadyMade;
}
else if (PN[0] == "Suiting" || PN[0] == "Shirting")
{
item.Units = Units.Meters;
item.Categorys = ProductCategorys.Fabric;
}
else
{
item.Units = Units.Nos;
item.Categorys = ProductCategorys.Others; //TODO: For time being
}
List <Category> catIds = GetCategory(db, PN[0], PN[1], PN[2]);
item.MainCategory = catIds[0];
item.ProductCategory = catIds[1];
item.ProductType = catIds[2];
db.ProductItems.Add(item);
db.SaveChanges();
return(item.ProductItemId);
}
else if (barc > 0)
{
barc = db.ProductItems.Where(c => c.Barcode == purchase.Barcode).First().ProductItemId;
return(barc);
// Already Added
}
else
{
return(-999); //TODO: Handel this options
// See ever here come.
}
}
// Converting purchase items to stock
public int ProcessPurchaseInward(DateTime inDate, bool IsLocal)
{
using (VoyagerContext db = new VoyagerContext())
{
int ctr = 0;
var data = db.ImportPurchases.Where(c => c.IsDataConsumed == false && DbFunctions.TruncateTime(c.GRNDate) == DbFunctions.TruncateTime(inDate)).OrderBy(c => c.InvoiceNo).ToList();
if (data != null && data.Count() > 0)
{
ProductPurchase PurchasedProduct = null;
foreach (var item in data)
{
int pid = CreateProductItem(db, item);
if (pid != -999)
{
CreateStockItem(db, item, pid);
}
PurchasedProduct = CreatePurchaseInWard(db, item, PurchasedProduct);
PurchasedProduct.PurchaseItems.Add(CreatePurchaseItem(db, item, pid, IsLocal));
item.IsDataConsumed = true;
db.Entry(item).State = EntityState.Modified;
ctr++;
}
if (PurchasedProduct != null)
{
db.ProductPurchases.Add(PurchasedProduct);
}
db.SaveChanges();
}
return(ctr);
}//end of using
}
private int CreateSaleTax(VoyagerContext db, ImportSaleItemWise item)
{
// Always GST and with Local Sale
//Calulate Rate
decimal rate = 0;
rate = ((item.SGST + item.CGST) * 100) / item.BasicRate;
int taxId = 1;
try
{
taxId = db.SaleTaxTypes.Where(c => c.CompositeRate == rate).FirstOrDefault().SaleTaxTypeId;
return(taxId);
}
catch (Exception)
{
SaleTaxType taxType = new SaleTaxType {
CompositeRate = rate, TaxName = "OutPut Tax GST(CGST+SGST) @" + rate, TaxType = TaxType.GST
};
db.SaleTaxTypes.Add(taxType);
db.SaveChanges();
return(taxType.SaleTaxTypeId);
}
}
private SaleInvoice CreateSaleInvoice(VoyagerContext db, ImportSaleItemWise item, SaleInvoice invoice)
{
if (invoice != null)
{
if (invoice.InvoiceNo == item.InvoiceNo)
{
// invoice.InvoiceNo = item.InvoiceNo;
//invoice.OnDate = item.InvoiceDate;
invoice.TotalDiscountAmount += item.Discount;
invoice.TotalBillAmount += item.LineTotal;
invoice.TotalItems += 1;//TODO: Check for count
invoice.TotalQty += item.Quantity;
invoice.RoundOffAmount += item.RoundOff;
invoice.TotalTaxAmount += item.SGST; //TODO: Check
invoice.PaymentDetail = CreatePaymentDetails(db, item);
invoice.CustomerId = GetCustomerId(db, item);
}
else
{
db.SaleInvoices.Add(invoice);
db.SaveChanges();
invoice = new SaleInvoice
{
InvoiceNo = item.InvoiceNo,
OnDate = item.InvoiceDate,
TotalDiscountAmount = item.Discount,
TotalBillAmount = item.LineTotal,
TotalItems = 1,//TODO: Check for count
TotalQty = item.Quantity,
RoundOffAmount = item.RoundOff,
TotalTaxAmount = item.SGST, //TODO: Check
PaymentDetail = CreatePaymentDetails(db, item),
CustomerId = GetCustomerId(db, item),
SaleItems = new List <SaleItem>()
};
}
}
else
{
invoice = new SaleInvoice
{
InvoiceNo = item.InvoiceNo,
OnDate = item.InvoiceDate,
TotalDiscountAmount = item.Discount,
TotalBillAmount = item.LineTotal,
TotalItems = 1,//TODO: Check for count
TotalQty = item.Quantity,
RoundOffAmount = item.RoundOff,
TotalTaxAmount = item.SGST, //TODO: Check
PaymentDetail = CreatePaymentDetails(db, item),
CustomerId = GetCustomerId(db, item),
SaleItems = new List <SaleItem>()
};
}
return(invoice);
}
public IActionResult Add(AdminUserVM model)
{
if (ModelState.IsValid)
{
AdminUser adminuser = new AdminUser();
adminuser.Name = model.Name;
adminuser.Surname = model.Surname;
adminuser.Email = model.EMail;
adminuser.Password = model.Password;
//adminuser.Roles = model.Roles;
_context.AdminUsers.Add(adminuser);
_context.SaveChanges();
//return RedirectToAction("Index", "AdminUser");
return(Redirect("/AdminArea/AdminUser/Index/"));
}
return(View());
}
public ProductPurchase CreatePurchaseInWard(VoyagerContext db, ImportPurchase purchase, ProductPurchase product)
{
if (product != null)
{
if (purchase.InvoiceNo == product.InvoiceNo)
{
product.TotalAmount += (purchase.CostValue + purchase.TaxAmt);
product.ShippingCost += 0;//TODO: add option for adding shipping cost for fabric
product.TotalBasicAmount += purchase.CostValue;
product.TotalTax += purchase.TaxAmt;
product.TotalQty += purchase.Quantity;
}
else
{
db.ProductPurchases.Add(product);
db.SaveChanges();
product = new ProductPurchase
{
InvoiceNo = purchase.InvoiceNo,
InWardDate = purchase.GRNDate,
InWardNo = purchase.GRNNo,
IsPaid = false,
PurchaseDate = purchase.InvoiceDate,
ShippingCost = 0,//TODO: add option for adding shipping cost for fabric
TotalBasicAmount = purchase.CostValue,
TotalTax = purchase.TaxAmt,
TotalQty = purchase.Quantity,
TotalAmount = purchase.CostValue + purchase.TaxAmt,// TODO: Check for actual DATA.
Remarks = "",
SupplierID = GetSupplierIdOrAdd(db, purchase.SupplierName),
StoreId = StoreID
};
product.PurchaseItems = new List <PurchaseItem> ();
}
}
else
{
product = new ProductPurchase
{
InvoiceNo = purchase.InvoiceNo,
InWardDate = purchase.GRNDate,
InWardNo = purchase.GRNNo,
IsPaid = false,
PurchaseDate = purchase.InvoiceDate,
ShippingCost = 0,//TODO: add option for adding shipping cost for fabric
TotalBasicAmount = purchase.CostValue,
TotalTax = purchase.TaxAmt,
TotalQty = purchase.Quantity,
TotalAmount = purchase.CostValue + purchase.TaxAmt,// TODO: Check for actual DATA.
Remarks = "",
SupplierID = GetSupplierIdOrAdd(db, purchase.SupplierName),
StoreId = StoreID
};
product.PurchaseItems = new List <PurchaseItem> ();
}
return(product);
}
public IActionResult Add(DriverVM model)
{
if (ModelState.IsValid)
{
Driver driver = new Driver();
driver.Name = model.Name;
driver.Surname = model.Surname;
driver.Experience = model.DriverLicense;
driver.Email = model.Email;
driver.Password = model.Password;
driver.Plate = model.CarPlate;
driver.Password = model.Password;
_context.Drivers.Add(driver);
_context.SaveChanges();
return(RedirectToAction("Index", "AdminDriver"));
}
return(View());
}
private int ImportSaleRegister(VoyagerContext db, string StoreCode, string fileName)
{
//string rootFolder = IHostingEnvironment.WebRootPath;
//string fileName = @"ImportCustomers.xlsx";
FileInfo file = new FileInfo(fileName);
using ExcelPackage package = new ExcelPackage(file);
ExcelWorksheet workSheet = package.Workbook.Worksheets ["Sheet1"];
int totalRows = workSheet.Dimension.Rows;
int StoreID = 1;//Default
StoreID = db.Stores.Where(c => c.StoreCode == StoreCode).Select(c => c.StoreId).FirstOrDefault();
if (StoreID < 1)
{
StoreID = 1;
}
List <ImportSaleRegister> saleList = new List <ImportSaleRegister> ();
//GRNNo GRNDate Invoice No Invoice Date Supplier Name Barcode Product Name Style Code Item Desc Quantity MRP MRP Value Cost Cost Value TaxAmt ExmillCost Excise1 Excise2 Excise3
int xo = 0;
for (int i = 2; i <= totalRows; i++)
{
//Invoice No 1 Invoice Date 2 Invoice Type 3
//Brand Name 4 Product Name 5 Item Desc 6 HSN Code 7 BAR CODE 8 //
//Style Code 9 Quantity 10 MRP 11 Discount Amt 12 Basic Amt 13 Tax Amt 14 SGST Amt 15
//CGST Amt 16 CESS Amt 17 Line Total 18 Round Off 19 Bill Amt 20 Payment Mode 21 SalesMan Name 22 //
//Coupon % Coupon Amt SUB TYPE Bill Discount LP Flag Inst Order CD TAILORING FLAG
ImportSaleRegister p = new ImportSaleRegister
{
InvoiceNo = workSheet.Cells [i, 1].Value.ToString(),
InvoiceDate = workSheet.Cells [i, 2].Value.ToString(),
InvoiceType = workSheet.Cells [i, 3].Value.ToString(),
Quantity = (double)workSheet.Cells [i, 4].Value,
MRP = (decimal)workSheet.Cells [i, 5].GetValue <decimal> (),
Discount = (decimal)workSheet.Cells [i, 6].GetValue <decimal> (),
BasicRate = (decimal)workSheet.Cells [i, 7].GetValue <decimal> (),
Tax = (decimal)workSheet.Cells [i, 8].GetValue <decimal> (),
RoundOff = (decimal)workSheet.Cells [i, 9].GetValue <decimal> (),
BillAmnt = (decimal)workSheet.Cells [i, 10].GetValue <decimal> (),
PaymentType = workSheet.Cells [i, 11].Value.ToString(),
StoreId = StoreID,
IsConsumed = false
};
saleList.Add(p);
xo++;
}
db.ImportSaleRegisters.AddRange(saleList);
return(db.SaveChanges());
//return purchaseList;
}
private int ImportPurchase(VoyagerContext db, string fileName, string StoreCode, bool IsVat, bool IsLocal)
{
//string rootFolder = IHostingEnvironment.WebRootPath;
//string fileName = @"ImportCustomers.xlsx";
FileInfo file = new FileInfo(fileName);
using ExcelPackage package = new ExcelPackage(file);
ExcelWorksheet workSheet = package.Workbook.Worksheets ["Sheet1"];
int totalRows = workSheet.Dimension.Rows;
int StoreID = 1;//Default
StoreID = db.Stores.Where(c => c.StoreCode == StoreCode).Select(c => c.StoreId).FirstOrDefault();
if (StoreID < 1)
{
StoreID = 1;
}
List <ImportPurchase> purchaseList = new List <ImportPurchase> ();
//GRNNo GRNDate Invoice No Invoice Date Supplier Name Barcode Product Name Style Code Item Desc Quantity MRP MRP Value Cost Cost Value TaxAmt ExmillCost Excise1 Excise2 Excise3
for (int i = 2; i <= totalRows; i++)
{
purchaseList.Add(new ImportPurchase
{
GRNNo = workSheet.Cells [i, 1].Value.ToString(),
GRNDate = (DateTime)workSheet.Cells [i, 2].GetValue <DateTime> (),
InvoiceNo = workSheet.Cells [i, 3].Value.ToString(),
InvoiceDate = (DateTime)workSheet.Cells [i, 4].GetValue <DateTime> (),
SupplierName = workSheet.Cells [i, 5].Value.ToString(),
Barcode = workSheet.Cells [i, 6].Value.ToString(),
ProductName = workSheet.Cells [i, 7].Value.ToString(),
StyleCode = workSheet.Cells [i, 8].Value.ToString(),
ItemDesc = workSheet.Cells [i, 9].Value.ToString(),
Quantity = (double)workSheet.Cells [i, 10].Value,
MRP = (decimal)workSheet.Cells [i, 11].GetValue <decimal> (),
MRPValue = (decimal)workSheet.Cells [i, 12].GetValue <decimal> (),
Cost = (decimal)workSheet.Cells [i, 13].GetValue <decimal> (),
CostValue = (decimal)workSheet.Cells [i, 14].GetValue <decimal> (),
TaxAmt = (decimal)workSheet.Cells [i, 15].GetValue <decimal> (),
IsDataConsumed = false,
// ImportTime = DateTime.Today,
IsLocal = IsLocal,
IsVatBill = IsVat,
StoreId = StoreID
});
}
db.ImportPurchases.AddRange(purchaseList);
return(db.SaveChanges());
//return purchaseList;
}
//Invoice No Invoice Date Invoice Type
//Brand Name Product Name Item Desc
//HSN Code BAR CODE Style Code Quantity
//MRP Discount Amt Basic Amt Tax Amt SGST Amt CGST Amt Line Total Round Off
//Bill Amt Payment Mode SalesMan Name
private int StockItem(VoyagerContext db, ImportSaleItemWise item, out Units unit)
{
ProductItem pItem = new ProductItem
{
Barcode = item.Barcode,
Cost = -999,
MRP = item.MRP,
StyleCode = item.StyleCode,
ProductName = item.ProductName,
ItemDesc = item.ItemDesc,
BrandId = GetBrand(db, item.StyleCode),
};
//spliting ProductName
string [] PN = item.ProductName.Split('/');
// Apparel / Work / Blazers
if (PN [0] == "Apparel")
{
pItem.Units = Units.Pcs;
pItem.Categorys = ProductCategorys.ReadyMade;
}
else if (PN [0] == "Suiting" || PN [0] == "Shirting")
{
pItem.Units = Units.Meters;
pItem.Categorys = ProductCategorys.Fabric;
}
else if (PN [0] == "Tailoring")
{
pItem.Units = Units.Nos;
pItem.Categorys = ProductCategorys.Tailoring;
}
else
{
pItem.Units = Units.Nos;
pItem.Categorys = ProductCategorys.Others; //TODO: For time being
}
List <Category> catIds = GetCategory(db, PN [0], PN [1], PN [2]);
pItem.MainCategory = catIds [0];
pItem.ProductCategory = catIds [1];
pItem.ProductType = catIds [2];
db.ProductItems.Add(pItem);
db.SaveChanges();
unit = pItem.Units;
return(pItem.ProductItemId);
}
private int GetSupplierIdOrAdd(VoyagerContext db, string sup)
{
try
{
int ids = (int?)db.Suppliers.Where(c => c.SuppilerName == sup).FirstOrDefault().SupplierID ?? -1;
if (ids > 0)
{
return(ids);
}
else if (ids == -1)
{
Supplier supplier = new Supplier
{
SuppilerName = sup,
Warehouse = sup
};
db.Suppliers.Add(supplier);
db.SaveChanges();
return(supplier.SupplierID);
}
else
{
return(1);// Suspense Supplier
}
}
catch (Exception)
{
Supplier supplier = new Supplier
{
SuppilerName = sup,
Warehouse = sup
};
db.Suppliers.Add(supplier);
db.SaveChanges();
return(supplier.SupplierID);
}
}
/// <summary>
/// For Creating Stock list for Sale . which can be later ajusted
/// </summary>
/// <param name="db">Database Context</param>
/// <param name="qty"> Sale Qty</param>
/// <param name="pItemId">Item Code</param>
/// <param name="unts">Units</param>
public void CreateStockItem(VoyagerContext db, double qty, int pItemId, Units unts)
{
Stock stock = new Stock
{
PurchaseQty = 0,
Quantity = 0 - qty,
ProductItemId = pItemId,
SaleQty = qty,
Units = unts
};
db.Stocks.Add(stock);
db.SaveChanges();
}