public DistributorUser Login(string unm, string pass)
{
DistributorUser duser = null;
duser = db.DistributorUsers.Where(x => x.Username.Equals(unm) && x.Password.Equals(pass)).FirstOrDefault();
return(duser);
}
public string AddRegulatorTx(int qty)
{
DistributorUser du = db.DistributorUsers.FirstOrDefault();
TxRegulator tr = new TxRegulator();
tr.CustomerId = du.DistributorCode;
tr.CustomerName = du.DistributorName;
tr.TxDate = DateTime.Now;
tr.Details = "Regulator";
tr.Quentity = qty;
tr.Price = db.Stoves.Where(x => x.type == "Regulator").FirstOrDefault().Price;
tr.Amount = Math.Round(qty * tr.Price, 2);
tr.CGST = 0;
tr.SGST = 0;
tr.Total = tr.Amount;
tr.CashMemoNo = 0;
db.txRegulators.Add(tr);
db.SaveChanges();
return("OK");
}
public string AddStoveTx(string details, int qty)
{
DistributorUser du = db.DistributorUsers.FirstOrDefault();
TxStoveRegulator ts = new TxStoveRegulator();
ts.CustomerId = du.DistributorCode;
ts.CustomerName = du.DistributorName;
ts.TxDate = DateTime.Now;
ts.Details = details;
ts.Quentity = qty;
ts.Price = db.Stoves.Where(x => x.type == details).FirstOrDefault().Price;
ts.Amount = Math.Round(qty * ts.Price, 2);
ts.CGST = 0;
ts.SGST = 0;
ts.Total = ts.Amount;
ts.CashMemoNo = 0;
db.txStoves.Add(ts);
db.SaveChanges();
return("OK");
}
public string AddCylenderTx(string details, int qty)
{
DistributorUser du = db.DistributorUsers.FirstOrDefault();
TxCylinder tc = new TxCylinder();
tc.CustomerId = du.DistributorCode;
tc.CustomerName = du.DistributorName;
tc.TxDate = DateTime.Now;
tc.CylinderDetails = details;
tc.Quentity = qty;
tc.Price = db.Cylinders.Where(x => x.type == details).FirstOrDefault().Price;
tc.Amount = Math.Round(qty * tc.Price, 2);
tc.CGST = 0;
tc.SGST = 0;
tc.Total = tc.Amount;
tc.CashMemoNo = 0;
db.txCylinders.Add(tc);
db.SaveChanges();
Synchronization.Synchronization syn = new Synchronization.Synchronization();
syn.AddRecord("TxCylinders", "Add", db.txCylinders.Last().TxId);
return("OK");
}
public TxCylinder BookingCylinderTx(int cid, int qty)
{
Customer c = db.Customers.Where(x => x.CustomerId == cid).FirstOrDefault();
DistributorUser du = db.DistributorUsers.FirstOrDefault();
TxCylinder tc = new TxCylinder();
tc.CustomerId = c.CustomerId;
tc.CustomerName = c.CustomerName;
tc.TxDate = DateTime.Now;
string details = null;
int q = 0;
if (c.CustomerType.Equals("Industrial"))
{
q = qty;
details = db.CylCustMappings.Where(x => x.CustomerType.Equals("Industrial")).Select(s => s.CylenderType).FirstOrDefault();
tc.CylinderDetails = details;
tc.Quentity = qty;
tc.Price = db.Cylinders.Where(x => x.type == details).FirstOrDefault().Price;
tc.Amount = Math.Round(qty * tc.Price, 2);
var gst = db.GSTRates.Where(x => x.Comodity.Equals("Industrial Cylender")).FirstOrDefault();
tc.CGST = Math.Round((tc.Amount * gst.CGST) / 100, 2);
tc.SGST = Math.Round((tc.Amount * gst.SGST) / 100, 2);
}
else
{
CylCustMapping ccm = null;
if (c.BankAccountNo == "")
{
ccm = db.CylCustMappings.Where(x => x.CustomerType.Equals(c.CustomerType) && x.CylenderType.Equals("14.2 KG Without Subsidy (F)")).FirstOrDefault();
details = ccm.CylenderType;
q = ccm.NoCylender;
}
else
{
ccm = db.CylCustMappings.Where(x => x.CustomerType.Equals(c.CustomerType) && x.CylenderType.Equals("14.2 KG With Subsidy (F)")).FirstOrDefault();
details = ccm.CylenderType;
q = ccm.NoCylender;
}
tc.CylinderDetails = details;
tc.Quentity = q;
tc.Price = db.Cylinders.Where(x => x.type == details).FirstOrDefault().Price;
tc.Amount = Math.Round(q * tc.Price, 2);
var gst = db.GSTRates.Where(x => x.Comodity.Equals("Domestic Cylender")).FirstOrDefault();
tc.CGST = Math.Round((tc.Amount * gst.CGST) / 100, 2);
tc.SGST = Math.Round((tc.Amount * gst.SGST) / 100, 2);
}
int cmn = db.txCylinders.Select(x => x.CashMemoNo).Max(m => m) + 1;
tc.CashMemoNo = cmn;
tc.Total = tc.Amount + tc.CGST + tc.SGST;
var rec = db.txCylinders.Add(tc);
db.SaveChanges();
Synchronization.Synchronization syn = new Synchronization.Synchronization();
syn.AddRecord("TxCylinders", "Add", rec.TxId);
using (LPGContext dbo = new LPGContext())
{
var result = dbo.Cylinders.Where(x => x.type.Equals(details)).FirstOrDefault();
result.Quentity = result.Quentity - q;
dbo.SaveChanges();
}
using (LPGContext dbo1 = new LPGContext())
{
details = details.Substring(0, details.Length - 2);
details = details + "E)";
var result = dbo1.Cylinders.Where(x => x.type.Equals(details)).FirstOrDefault();
result.Quentity = result.Quentity + q;
dbo1.SaveChanges();
}
return(rec);
}
