public HttpResponseMessage queryCustomer([FromBody] CUSTOMER c) { Result <CUSTOMER> ru = new Result <CUSTOMER>(); List <CUSTOMER> lcustomer = new List <CUSTOMER>(); try { lcustomer = DB_Customer.getCustomer(c.uid); if (lcustomer.Count > 0) { ru.code = "4030"; ru.success = "true"; ru.message = "获取成功!"; } else { ru.code = "4031"; ru.success = "false"; ru.message = "无数据"; } } catch (Exception e) { ru.code = "4032"; ru.success = "false"; ru.message = e.Message; } ru.systemTime = Conn.GetTimeStamp(); ru.data = lcustomer; return(Conn.toJson(ru)); }
public HttpResponseMessage deleteCustomer([FromBody] CUSTOMER c) { Result <CUSTOMER> ru = new Result <CUSTOMER>(); int result = 0; try { result = DB_Customer.deleteCustomer(c); if (result == 1) { ru.code = "4020"; ru.success = "true"; ru.message = "删除成功!"; } else { ru.code = "4021"; ru.success = "false"; ru.message = "删除失败"; } } catch (Exception e) { ru.code = "4022"; ru.success = "false"; ru.message = e.Message; } ru.systemTime = Conn.GetTimeStamp(); ru.data = null; return(Conn.toJson(ru)); }
//Customer Personal Details public JsonResult Customer_Personal_Details(int c1) { DB_Customer Customer = new DB_Customer(); Customer = (from a in database.DB_Customer where a.Customer_Id == c1 select a).FirstOrDefault(); return Json(Customer, JsonRequestBehavior.AllowGet); }
public ActionResult Collection_Submit() { var CustomerID = Request.Form["Customer"]; var Amount = Request.Form["Amount"]; var SalesmanID = Request.Form["Salesman"]; var Latitude = Request.Form["Latitude"]; var Longitude = Request.Form["Longitude"]; DateTime indianTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, "India Standard Time"); //To Store the details in DB_Collection. DB_Collection Collection_New = new DB_Collection(); Collection_New.Customer_Id = Convert.ToInt32(CustomerID); Collection_New.Salesman_Id = Convert.ToInt32(SalesmanID); Collection_New.Amount = Convert.ToInt32(Amount); Collection_New.DateTime = indianTime; Collection_New.Latitude = Convert.ToDouble(Latitude); Collection_New.Longitude = Convert.ToDouble(Longitude); database.DB_Collection.Add(Collection_New); //database.SaveChanges(); save changes when all the changes are done. //TODO : Update the Customer Log i.e Update the customer table. -- Done in Sales Controller var Customer_ID = Convert.ToInt32(CustomerID); DB_Customer Customer = new DB_Customer(); Customer = (from a in database.DB_Customer where a.Customer_Id == Customer_ID select a).FirstOrDefault(); //Cash_log += Deposit - Total_Amount; if (Customer.Cash_Log == null) Customer.Cash_Log = 0; //For 1st entry corner case Customer.Cash_Log = Customer.Cash_Log + Convert.ToDouble(Amount); //TODO : Update the salesman record. Rethink the design try { database.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } TempData["DataUrl"] = "data-url=" + Url.Content("~") + "Collection/Collection"; return RedirectToAction("Collection", "Collection"); }
//Sales Bill Submit public ActionResult Sales_Submit() { //Get data from Sales-ADD BILL table directly via form submit. //Customer + End Details. string[] Customer_Id = Request.Form["txtCustomer_Name"].Split(','); string[] DateOfSale = Request.Form["txtDateOfSale"].Split(','); string[] Salesman = Request.Form["txtSalesman"].Split(','); string[] Dues = Request.Form["txtDues"].Split(','); string[] Advance = Request.Form["txtAdvance"].Split(','); string[] Cash_Payment = Request.Form["txtCash_Payment"].Split(','); string[] Total_Amount = Request.Form["txtTotal_Amount"].Split(','); //Product Details string[] Prod_Name = Request.Form["txtProd_Name"].Split(','); string[] Qty = Request.Form["txtQty"].Split(','); string[] Free = Request.Form["txtFree"].Split(','); string[] Discount = Request.Form["txtDiscount"].Split(','); string[] Rate = Request.Form["txtRate"].Split(','); string[] VAT = Request.Form["txtVAT"].Split(','); string[] Amount = Request.Form["txtAmount"].Split(','); string[] cid = Request.Form["txtcid"].Split(','); //Update the corresponding rows appending quatity in Product_Log. //DB_Product_Log for(int i = 0; i < Prod_Name.Length; i++){ int ID = Convert.ToInt32(Prod_Name[i]); var query = (from a in database.DB_Product_Log where a.Prod_Id == ID select a).First(); //If MRP of product changes then the required changes to change product. query.Stock_Total_Outgoing += Convert.ToInt32(Qty[i]); query.Stock_Live = query.Stock_Total_Incoming - query.Stock_Total_Outgoing; try{ database.SaveChanges(); } catch(Exception e) { Console.WriteLine(e); } } //Create a random No for Sales Bill ID. DateTime indianTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, "India Standard Time"); string date = Convert.ToString(indianTime); var rows = (from a in database.DB_Sales_Bill select a.Bill_No).Count() + 1; string crn_final = "BILL_" + "Company_" + Convert.ToString(rows); //DB_Sales_Bill. DB_Sales_Bill Sales_Bill = new DB_Sales_Bill(); Sales_Bill.Bill_No = crn_final; Sales_Bill.cid = Convert.ToInt32(cid[0]); Sales_Bill.DateTime = DateTime.Now; Sales_Bill.Total_Amount = Convert.ToDouble(Total_Amount[Total_Amount.Length - 1]); Sales_Bill.Deposit = Convert.ToDouble(Cash_Payment[0]); Sales_Bill.Dues = Convert.ToDouble(Dues[0]); Sales_Bill.Advance = Convert.ToDouble(Advance[0]); Sales_Bill.Customer_Id = Convert.ToInt32(Customer_Id[0]); Sales_Bill.Sales_Man_Id = Convert.ToInt32(Salesman[0]); database.DB_Sales_Bill.Add(Sales_Bill); var CustomerID = Convert.ToInt32(Customer_Id[0]); DB_Customer Customer = new DB_Customer(); Customer = (from a in database.DB_Customer where a.Customer_Id == CustomerID select a).FirstOrDefault(); //Cash_log += Deposit - Total_Amount; if(Customer.Cash_Log == null) Customer.Cash_Log = 0; //For 1st entry corner case Customer.Cash_Log = Customer.Cash_Log + (Convert.ToDouble(Cash_Payment[0]) - Convert.ToDouble(Total_Amount[Total_Amount.Length - 1])); //DB_Sales_Bill_Product Insertion for (int i = 0; i < Prod_Name.Length; i++) { DB_Sales_Bill_Product Sales_Bill_Product = new DB_Sales_Bill_Product(); Sales_Bill_Product.Bill_No = crn_final; Sales_Bill_Product.Prod_Id = Convert.ToInt32(Prod_Name[i]); Sales_Bill_Product.Qty = Convert.ToInt32(Qty[i]); Sales_Bill_Product.Rate = Convert.ToDouble(Rate[i]); Sales_Bill_Product.Amount = Convert.ToDouble(Amount[i]); Sales_Bill_Product.Scheme = Convert.ToDouble(Free[i]); Sales_Bill_Product.Discount = Convert.ToDouble(Discount[i]); database.DB_Sales_Bill_Product.Add(Sales_Bill_Product); try { database.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } //TODO : Save changes when all transactions satisfy } return RedirectToAction("Add_Bill", "Sales"); }