public IHttpActionResult GetPurchaseDetailsList()
{
IList <PurchaseDetailsClass> purchdet = null;
using (var ctx = new EasyBillingEntities())
{
purchdet = ctx.Purchase_details.Select(l => new PurchaseDetailsClass()
{
Pieces = l.Pieces,
Product_Token = l.Product_Token,
Purcahse_number = l.Purcahse_number,
Date = l.Date,
Purchase_Token_number = l.Purchase_Token_number,
Quantity = l.Quantity,
Amount = l.Amount,
Discount = l.Discount,
Purchase_details_number = l.Purchase_details_number,
Discount_percent = l.Discount_percent,
Taxable_amount = l.Taxable_amount,
Sub_Total = l.Sub_Total,
Tax = l.Tax,
Tax_Token = l.Tax_Token
}).Distinct().ToList();
}
if (purchdet.Count == 0)
{
return(NotFound());
}
return(Ok(purchdet));
}
public async Task <IHttpActionResult> GetById([FromUri] string id)
{
using (EasyBillingEntities db = new EasyBillingEntities())
{
return(await Task.FromResult(Ok(db.Employees.Where(z => z.Token_number == id).Distinct().FirstOrDefault())));
}
}
public ActionResult Delete(string id)
{
using (EasyBillingEntities db = new EasyBillingEntities())
{
return(View(db.Tyre_sizes.Where(z => z.Token_number == id).Distinct().FirstOrDefault()));
}
}
public ActionResult ProductList()
{
using (EasyBillingEntities db = new EasyBillingEntities())
{
return(View(db.Other_Products.Distinct().ToList()));
}
}
public async Task <IHttpActionResult> GetAll()
{
using (EasyBillingEntities context = new EasyBillingEntities())
{
return(await Task.FromResult(Ok(context.Employees.ToList())));
}
}
public IHttpActionResult Postadding(JObject jsonData)
{
dynamic json = jsonData;
string token = json.Token_number;
int Pieces = json.Pieces;
using (var ctx = new EasyBillingEntities())
{
var data = ctx.Temp_placedorder.Where(z => z.Token_number == token).Distinct().FirstOrDefault();
var datamaxpieces = ctx.Stocks.Where(z => z.Product_Token == data.Item_token).Select(z => z.Pieces).Distinct().FirstOrDefault();
if (datamaxpieces >= Pieces)
{
data.Pieces = Pieces;
if (Pieces >= 0)
{
ctx.SaveChanges();
return(Ok());
}
else
{
return(BadRequest());
}
}
else
{
return(BadRequest());
}
}
}
public IHttpActionResult GetBillingMasterList()
{
IList <BillingMasterClass> BMC = null;
using (var ctx = new EasyBillingEntities())
{
BMC = ctx.Billing_Masters.Select(s => new BillingMasterClass()
{
Token_Number = s.Token_Number,
CGST = s.CGST,
Customer_Token_number = s.Customer_Token_number,
Date = s.Date,
Discount_percent = s.Discount_percent,
Billing_Number = s.Billing_Number,
Marchent_Token_number = s.Marchent_Token_number,
Narration = s.Narration,
Rate_including_tax = s.Rate_including_tax,
SGST = s.SGST,
Tax_token = s.Tax_token,
Total_amount = s.Total_amount,
Total_discount = s.Total_discount,
Total_tax = s.Total_tax,
}).ToList();
}
if (BMC.Count == 0)
{
return(NotFound());
}
return(Ok(BMC));
}
public IHttpActionResult GetAllTaxGroup(string id)
{
TaxGroupClass taxGroup = null;
using (var ctx = new EasyBillingEntities())
{
taxGroup = ctx.Tax_Groups.Where(x => x.Tax_Token == id).Select(s => new TaxGroupClass()
{
Tax_Token = s.Tax_Token,
Tax_Name = s.Tax_Name,
Tax_Rate = s.Tax_Rate,
GL_CODE = s.GL_CODE,
IsActive = s.IsActive,
}).FirstOrDefault();
}
if (taxGroup == null)
{
return(NotFound());
}
return(Ok(taxGroup));
}
public IHttpActionResult GetAllStatesforedit(string id = "19")
{
IList <StateData> state = null;
using (var ctx = new EasyBillingEntities())
{
var statecd = int.Parse(id);
state = ctx.States.Select(s => new StateData()
{
State_Code = s.State_Code,
Name = s.Name,
State_Identity = s.State_Identity,
CGST = s.CGST,
SGST = s.SGST,
IGST = s.IGST,
UTGST = s.UTGST,
}).OrderByDescending(x => x.State_Code == statecd).ToList();
}
if (state == null)
{
return(NotFound());
}
return(Ok(state));
}
public IHttpActionResult GetAllUserTaxGroups(bool includeAddress = false)
{
IList <TaxGroupClass> taxgroup = null;
using (var ctx = new EasyBillingEntities())
{
taxgroup = ctx.Tax_Groups.Where(s => s.IsActive == true).Select(s => new TaxGroupClass()
{
Tax_Token = s.Tax_Token,
Tax_Name = s.Tax_Name,
Tax_Rate = s.Tax_Rate,
GL_CODE = s.GL_CODE,
IsActive = s.IsActive,
}).ToList <TaxGroupClass>();
}
if (taxgroup.Count == 0)
{
return(NotFound());
}
return(Ok(taxgroup));
}
public IHttpActionResult PostNewTaxGroup([FromBody] Tax_Group taxgroup)
{
if (!ModelState.IsValid)
{
return(BadRequest("Sorry there is some problem. Please check and try again"));
}
using (var ctx = new EasyBillingEntities())
{
if (taxgroup.GL_CODE != null)
{
taxgroup.IsActive = true;
taxgroup.Tax_Token = (Guid.NewGuid()).ToString();
ctx.Tax_Groups.Add(taxgroup);
ctx.SaveChanges();
}
else
{
return(BadRequest("State does not exists"));
}
}
return(Ok());
}
public IHttpActionResult PutTaxGroup([FromBody] Tax_Group taxGroup)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid data"));
}
using (var ctx = new EasyBillingEntities())
{
var existingTaxGroup = ctx.Tax_Groups.Where(s => s.Tax_Token == taxGroup.Tax_Token).FirstOrDefault();
if (existingTaxGroup != null)
{
existingTaxGroup.Tax_Name = taxGroup.Tax_Name;
existingTaxGroup.Tax_Rate = taxGroup.Tax_Rate;
existingTaxGroup.IsActive = true;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult GetAllTaxGroupforedit(string id)
{
IList <TaxGroupClass> taxGroup = null;
using (var ctx = new EasyBillingEntities())
{
taxGroup = ctx.Tax_Groups.Where(s => s.IsActive == true).Select(s => new TaxGroupClass()
{
Tax_Token = s.Tax_Token,
Tax_Name = s.Tax_Name,
Tax_Rate = s.Tax_Rate,
GL_CODE = s.GL_CODE,
IsActive = s.IsActive,
}).OrderByDescending(x => x.GL_CODE == id).ToList();
}
if (taxGroup == null)
{
return(NotFound());
}
return(Ok(taxGroup));
}
public IHttpActionResult GetPurchaseStockList()
{
IList <StockClass> stc = null;
using (var ctx = new EasyBillingEntities())
{
stc = ctx.Stocks.Select(l => new StockClass()
{
Pieces = l.Pieces,
Product_Token = l.Product_Token,
Date = l.Date,
Stock_Id = l.Stock_Id,
CGST = l.CGST,
SGST = l.SGST
}).Distinct().ToList();
}
if (stc.Count == 0)
{
return(NotFound());
}
return(Ok(stc));
}
public ActionResult Update(string id)
{
using (EasyBillingEntities db = new EasyBillingEntities())
{
return(View(db.Proprietors.Where(z => z.Token_number == id).Distinct().FirstOrDefault()));
}
}
public IHttpActionResult GetAllStates(bool includeAddress = false)
{
IList <StateData> state = null;
using (var ctx = new EasyBillingEntities())
{
state = ctx.States.Select(s => new StateData()
{
State_Code = s.State_Code,
Name = s.Name,
State_Identity = s.State_Identity,
CGST = s.CGST,
SGST = s.SGST,
UTGST = s.UTGST,
IGST = s.IGST,
}).ToList <StateData>();
}
if (state.Count == 0)
{
return(NotFound());
}
return(Ok(state));
}
public IHttpActionResult PostMerchantLogin([FromBody] Marchent_Account marchent)
{
if (!ModelState.IsValid)
{
return(BadRequest("Sorry there is some problem. Please check and try again"));
}
using (var ctx = new EasyBillingEntities())
{
if (marchent.Email_Id != null && marchent.Verification_code != null)
{
bool chck = ctx.Marchent_Accounts.Where(a => a.Email_Id == marchent.Email_Id && a.Verification_code == marchent.Verification_code).Any();
var mrchnt = ctx.Marchent_Accounts.Where(a => a.Email_Id == marchent.Email_Id && a.Verification_code == marchent.Verification_code).FirstOrDefault();
if (chck == true && mrchnt.IsActive == true)
{
marchent.License = mrchnt.License;
return(Ok(marchent));
}
}
else
{
return(BadRequest("Require fields mandotory."));
}
}
return(Ok());
}
public IHttpActionResult GetAllStates(string id)
{
StateData state = null;
using (var ctx = new EasyBillingEntities())
{
var statecd = int.Parse(id);
state = ctx.States.Where(x => x.State_Code == statecd).Select(s => new StateData()
{
State_Code = s.State_Code,
Name = s.Name,
State_Identity = s.State_Identity,
CGST = s.CGST,
SGST = s.SGST,
IGST = s.IGST,
UTGST = s.UTGST,
}).FirstOrDefault();
}
if (state == null)
{
return(NotFound());
}
return(Ok(state));
}
public IHttpActionResult GetBillingData(string id)
{
BillingMasterClass BM = null;
using (var ctx = new EasyBillingEntities())
{
var pmexits = ctx.Billing_Masters.Select(s => new BillingMasterClass()
{
Billing_Number = s.Billing_Number
}).Where(a => a.Billing_Number == id).Any();
if (pmexits == true)
{
BM = ctx.Billing_Masters.Select(s => new BillingMasterClass()
{
Billing_Number = s.Billing_Number,
Barcode_Number = s.Barcode_Number
}).Where(a => a.Billing_Number == id).FirstOrDefault();
}
}
if (BM == null)
{
return(NotFound());
}
return(Ok(BM));
}
public IHttpActionResult PutProducts([FromBody] Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid data"));
}
using (var ctx = new EasyBillingEntities())
{
var existingProduct = ctx.Products.Where(s => s.Token_Number == product.Token_Number).FirstOrDefault();
if (existingProduct != null)
{
//existingProduct.GL_CODE = product.txgrp;
product.Tax_rate = Convert.ToDecimal((from a in ctx.Tax_Groups
select a.Tax_Rate).Distinct().FirstOrDefault());
existingProduct.Product_name = product.Product_name;
existingProduct.Product_Code = product.Product_Code;
existingProduct.Description = product.Description;
existingProduct.Tax_rate = product.Tax_rate;
existingProduct.HSN_SAC_Code = product.HSN_SAC_Code;
existingProduct.IsActive = true;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult GetBillingDetailsList()
{
IList <BillingDetailsClass> BillingDet = null;
using (var ctx = new EasyBillingEntities())
{
BillingDet = ctx.Billing_Details.Select(l => new BillingDetailsClass()
{
Pieces = l.Pieces,
Product_Token = l.Product_Token,
Billing_number = l.Billing_number,
Date = l.Date,
Billing_Token_number = l.Billing_Token_number,
Amount = l.Amount,
Discount = l.Discount,
Billing_details_number = l.Billing_details_number,
Discount_percent = l.Discount_percent,
Taxable_amount = l.Taxable_amount,
Sub_Total = l.Sub_Total,
Tax = l.Tax,
}).Distinct().ToList();
}
if (BillingDet.Count == 0)
{
return(NotFound());
}
return(Ok(BillingDet));
}
public IHttpActionResult GetAllProducts(bool includeAddress = false)
{
IList <ProductClass> product = null;
using (var ctx = new EasyBillingEntities())
{
product = ctx.Products.Select(s => new ProductClass()
{
Token_Number = s.Token_Number,
Product_Code = s.Product_Code,
Product_name = s.Product_name,
Description = s.Description,
Tax_rate = s.Tax_rate,
GL_CODE = s.GL_CODE,
txgrp = (from a in ctx.Tax_Groups
where a.GL_CODE == s.GL_CODE
select a.Tax_Name).Distinct().FirstOrDefault(),
HSN_SAC_Code = s.HSN_SAC_Code,
IsActive = s.IsActive,
}).ToList <ProductClass>();
}
if (product.Count == 0)
{
return(NotFound());
}
return(Ok(product));
}
public async Task <ActionResult> Update(Manager manager)
{
using (EasyBillingEntities db = new EasyBillingEntities())
{
Manager managerforupdate = db.Managers.Where(z => z.Token_number == manager.Token_number).Distinct().FirstOrDefault();
if (managerforupdate != null)
{
managerforupdate.Address = manager.Address;
managerforupdate.Email_Id = manager.Email_Id;
managerforupdate.IsActive = manager.IsActive;
managerforupdate.Manager_name = manager.Manager_name;
managerforupdate.Mobile = manager.Mobile;
managerforupdate.Pan_Number = manager.Pan_Number;
managerforupdate.State_Code = manager.State_Code;
managerforupdate.State_Name = manager.State_Name;
managerforupdate.Verification_code = manager.Verification_code;
await db.SaveChangesAsync();
ModelState.Clear();
return(RedirectToAction("Index"));
}
else
{
return(View(manager));
}
}
}
public IHttpActionResult PostRateUpdate(JObject jsonData)
{
dynamic json = jsonData;
string token = json.Token_number;
string Upselling = json.UpSellingp;
string Upcgst = json.Upcgst;
string Upsgst = json.Upsgst;
using (var ctx = new EasyBillingEntities())
{
var existingProduct = ctx.Products_For_Sales.Where(s => s.Token_Number == token).FirstOrDefault();
if (existingProduct != null)
{
existingProduct.Selling_Price = decimal.Parse(Upselling);
existingProduct.CGST = decimal.Parse(Upcgst);
existingProduct.SGST = decimal.Parse(Upsgst);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public async Task <IHttpActionResult> Save([FromBody] Employee employee)
{
using (EasyBillingEntities db = new EasyBillingEntities())
{
Employee Employeeforupdate = db.Employees.Where(z => z.Token_number == employee.Token_number)
.Distinct().FirstOrDefault();
if (Employeeforupdate != null)
{
Employeeforupdate.Contact_number = employee.Contact_number;
Employeeforupdate.Designation = employee.Designation;
Employeeforupdate.Email_id = employee.Email_id;
Employeeforupdate.Employee_Id = employee.Employee_Id;
Employeeforupdate.Employee_name = employee.Employee_name;
Employeeforupdate.Joining_date = employee.Joining_date;
Employeeforupdate.Leaving_date = employee.Leaving_date;
Employeeforupdate.login_required = employee.login_required;
Employeeforupdate.Salary = employee.Salary;
await db.SaveChangesAsync();
return(Ok());
}
employee.Token_number = Guid.NewGuid().ToString();
db.Employees.Add(employee);
await db.SaveChangesAsync();
return(Created("", employee));
}
}
public IHttpActionResult PostNewProduct([FromBody] Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest("Sorry there is some problem. Please check and try again"));
}
using (var ctx = new EasyBillingEntities())
{
if (product.HSN_SAC_Code == null)
{
product.Tax_rate = 0;
}
else if (product.HSN_SAC_Code != null)
{
// product.GL_CODE = product.txgrp;
product.Tax_rate = Convert.ToDecimal((from a in ctx.Tax_Groups
select a.Tax_Rate).Distinct().FirstOrDefault());
product.IsActive = true;
product.Token_Number = (Guid.NewGuid()).ToString();
ctx.Products.Add(product);
ctx.SaveChanges();
}
else
{
return(BadRequest("Taxgroup does not exists"));
}
}
return(Ok());
}
// GET: TyreSize
public ActionResult Index()
{
using (EasyBillingEntities db = new EasyBillingEntities())
{
return(View(db.Tyre_sizes.Distinct().ToList()));
}
}
public IHttpActionResult GetAllProducts(string id)
{
ProductClass product = null;
using (var ctx = new EasyBillingEntities())
{
product = ctx.Products.Where(x => x.Token_Number == id).Select(s => new ProductClass()
{
Token_Number = s.Token_Number,
Product_Code = s.Product_Code,
Product_name = s.Product_name,
Description = s.Description,
Tax_rate = s.Tax_rate,
txgrp = (from a in ctx.Tax_Groups
where a.GL_CODE == s.GL_CODE
select a.Tax_Name).Distinct().FirstOrDefault(),
HSN_SAC_Code = s.HSN_SAC_Code,
GL_CODE = s.GL_CODE,
IsActive = s.IsActive,
}).FirstOrDefault();
}
if (product == null)
{
return(NotFound());
}
return(Ok(product));
}
public ActionResult PlaceOrder(string tkn, string rd, string error)
{
ViewBag.tkn = tkn;
if (rd.ToUpper() == "PAYPAL")
{
ViewBag.payment = "Pay with paypal";
}
else
{
ViewBag.payment = "Pay on delivery";
ViewBag.pod = "1";
}
Customer_shipping_address customer_Shipping_Address = new Customer_shipping_address();
using (EasyBillingEntities db = new EasyBillingEntities())
{
if (tkn == null && tkn == "")
{
ViewBag.item = db.Products_For_Sales.Where(z => z.Token_Number == tkn).Distinct().FirstOrDefault();
}
var customerToken = db.Customers.Where(z => z.Email == User.Identity.Name).Select(z => z.Token_number).Distinct().FirstOrDefault();
var isuser = "******";
if (customerToken == null)
{
customerToken = db.Users.Where(z => z.Email == User.Identity.Name).Select(z => z.Token_number).Distinct().FirstOrDefault();
isuser = "******";
}
ViewBag.isuser = isuser;
bool chktkn = db.Customer_shipping_addresses.Where(z => z.Customer_token_number == customerToken).Any();
if (chktkn != false)
{
customer_Shipping_Address = db.Customer_shipping_addresses.Where(z => z.Customer_token_number == customerToken).Distinct().FirstOrDefault();
}
if (tkn == null || tkn == "")
{
ViewBag.tkn = null;
List <cartlist> cartlists = new List <cartlist>();
var itmcrt = db.Temp_placedorder.Where(z => z.Customer_token == customerToken).Distinct().ToList();
foreach (var eachitm in itmcrt)
{
cartlist cartlist = new cartlist();
var lst = db.Products_For_Sales.Where(z => z.Token_Number == eachitm.Item_token).Select(z => z.Total).Distinct().FirstOrDefault();
cartlist.Price = lst;
cartlists.Add(cartlist);
}
var total = decimal.Parse("0.00");
foreach (var crtlsts in cartlists)
{
total = total + crtlsts.Price;
}
ViewBag.itemcart = total;
}
ViewBag.error = error;
return(View(customer_Shipping_Address));
}
}
public IHttpActionResult GetAllStockData()
{
IList <StockClass> stock = null;
using (var ctx = new EasyBillingEntities())
{
var dcml = decimal.Parse("0.000");
stock = ctx.Stocks.Select(s => new StockClass()
{
Date = s.Date,
Pieces = s.Pieces,
Product_name = (from a in ctx.Products
where a.Token_Number == s.Product_Token
select a.Product_name).Distinct().FirstOrDefault(),
Product_Token = s.Product_Token,
Purcahse_number = s.Purcahse_number,
Purchase_Token_number = s.Purchase_Token_number,
Stock_Id = s.Stock_Id,
CGST = s.CGST,
SGST = s.SGST
}).Where(x => x.Pieces != 0).ToList();
}
if (stock.Count == 0)
{
return(NotFound());
}
return(Ok(stock));
}
