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");
}
