internal Message AddSupplierDB(SupplierMain data)
{
msg = new Message();
try
{
using (entity = new SpeedDatabaseEntities())
{
SupplierMain sm = new SupplierMain();
sm.SupplierAddress = data.SupplierAddress;
sm.SupplierName = data.SupplierName;
sm.TotalPurchaseCost = 0;
sm.TotalSupplierCredit = 0;
entity.SupplierMains.Add(sm);
entity.SaveChanges();
msg.success = true;
return(msg);
}
}
catch (DataException ex)
{
msg.success = false;
msg.message = ex.Message;
return(msg);
}
}
internal Message DeleteSupplierByID(int supplierId)
{
msg = new Message();
try
{
using (entity = new SpeedDatabaseEntities())
{
if (entity.PurchaseMains.Any(s => s.SupplierID == supplierId))
{
int purchaseid = entity.PurchaseMains.Where(s => s.SupplierID == supplierId).FirstOrDefault().PurchaseID;
msg.message = "Purchase has entries with selected Supplier. Please delete purchase with ID: " + purchaseid;
msg.success = false;
return(msg);
}
else
{
entity.SupplierDetails.RemoveRange(entity.SupplierDetails.Where(s => s.SupplierID == supplierId));
entity.SupplierMains.Remove(entity.SupplierMains.Where(s => s.SupplierID == supplierId).FirstOrDefault());
entity.SaveChanges();
msg.success = true;
return(msg);
}
}
}
catch (DataException ex)
{
msg.message = ex.Message;
msg.success = true;
return(msg);
}
}
internal Message UpdateProduct(Product data)
{
msg = new Message();
try
{
using (entity = new SpeedDatabaseEntities())
{
Product obj = entity.Products.Where(s => s.ProductID == data.ProductID).FirstOrDefault();
obj.CGST = data.CGST;
obj.HSN = data.HSN;
obj.IGST = data.IGST;
obj.ProductName = data.ProductName;
obj.SGST = data.SGST;
entity.SaveChanges();
msg.success = true;
return(msg);
}
}
catch (DataException ex)
{
msg.message = ex.Message;
msg.success = false;
return(msg);
}
}
internal Message AddProductDB(ProductModel data)
{
msg = new Message();
try
{
using (entity = new SpeedDatabaseEntities())
{
Product pr = new Product();
pr.CGST = data.cgst;
pr.HSN = data.hsn;
pr.IGST = data.igst;
pr.ProductName = data.productName;
pr.SGST = data.sgst;
entity.Products.Add(pr);
entity.SaveChanges();
msg.success = true;
return(msg);
}
}
catch (DataException ex)
{
msg.message = ex.Message;
msg.success = false;
return(msg);
}
}
internal List <PurchaseMainModel> GetAllPurchase()
{
using (entity = new SpeedDatabaseEntities())
{
var result = (from pm in entity.PurchaseMains
join sm in entity.SupplierMains on pm.SupplierID equals sm.SupplierID
select new PurchaseMainModel
{
pucrhaseDate = pm.PurchaseDate,
supplierId = (int)pm.SupplierID,
supplierName = sm.SupplierName,
totalAmountPaid = pm.TotalAmountPaid,
totalPurchaseCost = pm.TotalPurchaseAmount,
totalPurchaseCredit = pm.TotalPurchaseCredit,
purchaseId = pm.PurchaseID
}).ToList();
int i = 1;
foreach (var item in result)
{
item.slNo = i++;
item.date = item.pucrhaseDate.ToString("dd-MMM-yy");
}
return(result);
}
}
internal SupplierMain GetSupplierByID(int supplierId)
{
using (entity = new SpeedDatabaseEntities())
{
SupplierMain data = entity.SupplierMains.Where(s => s.SupplierID == supplierId).FirstOrDefault();
return(data);
}
}
internal Product GetProductById(int productId)
{
using (entity = new SpeedDatabaseEntities())
{
Product data = entity.Products.Where(s => s.ProductID == productId).FirstOrDefault();
return(data);
}
}
internal Message deleteProductById(int productId)
{
msg = new Message();
using (entity = new SpeedDatabaseEntities())
{
if (entity.PurchaseDetails.Any(s => s.ProductID == productId))
{
msg.message = "Product Exists in Purchase Entry. Please Delete Purchase";
msg.success = false;
return(msg);
}
else
{
Product obj = entity.Products.Where(s => s.ProductID == productId).FirstOrDefault();
entity.Products.Remove(obj);
entity.SaveChanges();
msg.success = true;
return(msg);
}
}
}
internal List <SupplierModel> GetAllSuppliers()
{
using (entity = new SpeedDatabaseEntities())
{
var result = (from supp in entity.SupplierMains
orderby supp.SupplierName
select new SupplierModel
{
supplierId = supp.SupplierID,
supplierName = supp.SupplierName,
TotalPurchaseCost = (Int32)supp.TotalPurchaseCost,
TotalPurchaseCredit = supp.TotalSupplierCredit
}).ToList();
int i = 1;
foreach (var item in result)
{
item.slNo = i++;
}
return(result);
}
}
internal Message UpdateSupplier(SupplierMain data)
{
msg = new Message();
using (entity = new SpeedDatabaseEntities())
{
try
{
SupplierMain sm = entity.SupplierMains.Where(s => s.SupplierID == data.SupplierID).FirstOrDefault();
sm.SupplierAddress = data.SupplierAddress;
sm.SupplierName = data.SupplierName;
entity.SaveChanges();
msg.success = true;
return(msg);
}
catch (DataException ex)
{
msg.success = false;
msg.message = ex.Message;
return(msg);
}
}
}
/// <summary>
//Return All Product List
/// </summary>
/// <returns></returns>
internal List <ProductModel> GetAllProducts()
{
using (entity = new SpeedDatabaseEntities())
{
var result = (from product in entity.Products
orderby product.ProductName
select new ProductModel
{
cgst = product.CGST,
hsn = product.HSN,
igst = product.IGST,
productId = product.ProductID,
productName = product.ProductName,
sgst = product.SGST
}).ToList();
int i = 0;
foreach (var item in result)
{
item.slNo = ++i;
}
return(result);
}
}