public ActionResult UploadPhoto(string name, string refno, DateTime tran_date, int id, HttpPostedFileBase file) { if (file != null) { if (file.FileName.Contains(".jpg") == false) { Session["err"] = "Please Upload .JPG file Only"; return(RedirectToAction("Print", "Documents", new { id = id })); } else { string path = Server.MapPath("~/photo/Documents"); file.SaveAs(path + "/" + id + ".jpg"); ViewData["path"] = id + ".jpg"; using (var db = new SameSoftWeb.Models.SameSoftwareWebEntities()) { var x = db.TblDocuments.Add(new Models.TblDocument { Documents = "/Photo/Documents/" + id + ".jpg", Cust_Name = name, RefNo = refno, Tran_Date = tran_date }); db.SaveChanges(); } } } else { Session["err"] = "No File Selected"; return(RedirectToAction("Print", "Documents", new { id = id })); } return(RedirectToAction("Print", "Documents", new { id = id })); }
public static void addlog(string title, string details, int userid) { SameSoftWeb.Models.SameSoftwareWebEntities db = new SameSoftWeb.Models.SameSoftwareWebEntities(); DateTime dt = DateTime.UtcNow.AddHours(3); db.TblLogs.Add(new Models.TblLog { LogDate = dt, Title = title, Details = details, UserID = userid }); db.SaveChanges(); }
public ActionResult add_purchase_request(int[] item_id, float[] qty, float[] unit_cost, int vendor_id, string note, DateTime?trandate) { int userid = (int)Session["UserID"]; int business_division = 1; DateTime vdate = SameSoftWeb.helper.sitemethods.getdate(); if (trandate != null) { DateTime dt = (DateTime)trandate; if (dt.Date == vdate.Date) { vdate = SameSoftWeb.helper.sitemethods.getdate(); } else { vdate = dt; } } // Validate db.Database.BeginTransaction(); db.tblPurchase_Order.Add(new Models.tblPurchase_Order { Business_Division_Id = business_division, Total = 0, Tran_Date = vdate, Status = "Open", UserID = userid, Note = note, Vendor_Id = vendor_id }); db.SaveChanges(); int pur_id = 0; pur_id = db.tblPurchase_Order.Select(a => a.Purchase_ID).Max(); for (int x = 0; x <= item_id.Length - 1; x++) { db.tblPurchase_Order_Details.Add(new Models.tblPurchase_Order_Details { Purchase_ID = pur_id, Item_id = item_id[x], Qty = qty[x], Unit_Cost = unit_cost[x] }); // db.tblPurchase_Order_Details.Add(new Models.tblPurchase_Order_Details { Purchase_ID = pur_id, Item_id = item_id[x], Qty = qty[x] }); //// Update Item Price / Cost //int id = item_id[x]; //float costx = unit_cost[x]; //var temp = db.Items.Where(a => a.Item_Id == id).FirstOrDefault(); //if (temp!=null) //{ // temp.Sale_Price = (decimal)costx; // db.SaveChanges(); //} } db.SaveChanges(); float total = 0; total = (float)db.tblPurchase_Order_Details.Where(a => a.Purchase_ID == pur_id).Select(a => a.Qty * a.Unit_Cost).Sum(); var p = db.tblPurchase_Order.Where(f => f.Purchase_ID == pur_id).FirstOrDefault(); p.Total = total; db.SaveChanges(); db.Database.CurrentTransaction.Commit(); //str = str + " All data Insetred"; return(RedirectToAction("ReceivePurchase", "Purchasing")); // return RedirectToAction("success", "message", new { msg = "Purchase Request Completed Successfully !" }); }
public ActionResult PostRateNow(int[] Cust_ID, float[] amount, DateTime trandate) { int i = 0; int serialno = 0; int?sr = db.tblInvoices.Where(a => a.Invoice_id == 1).Select(a => a.Invoice_No).FirstOrDefault(); if (sr == null || sr == 0) { serialno = int.Parse(db.tblSettings.Where(a => a.ID == 1).Select(a => a.Value).FirstOrDefault()); } else { serialno = (int)sr + 1; } int UserID = (int)Session["UserID"]; for (int x = 0; x <= Cust_ID.Length - 1; x++) { int ID = Cust_ID[x]; float Mantainance = amount[x]; double balance = 0; var Cust_balance = db.sp_Get_Customer_with_Balance2(ID).FirstOrDefault(); if (Cust_balance != null) { balance = Cust_balance.Total; } string inwords = helper.mnc.ToWords(Mantainance.ToString()); string strTran_Nbr = ID + DateTime.UtcNow.AddHours(3).ToString().GetHashCode().ToString("x"); string tranNbr = ID + DateTime.UtcNow.AddHours(3).ToString().GetHashCode().ToString("x"); int? Cust_Tran_ID = db.tblCustomer_Transaction.Where(a => a.CustomerID == ID && a.Status == "Open").Select(a => a.Cust_Tran_ID).FirstOrDefault(); if (Cust_Tran_ID == null || Cust_Tran_ID == 0) { db.tblCustomer_Transaction.Add(new Models.tblCustomer_Transaction { Amount = Mantainance, CustomerID = ID, Tran_Date = trandate, Status = "Open", UserID = UserID, }); db.SaveChanges(); Cust_Tran_ID = db.tblCustomer_Transaction.Select(a => a.Cust_Tran_ID).Max(); } else { try { var tran = db.tblCustomer_Transaction.Where(a => a.CustomerID == ID && a.Status == "Open").FirstOrDefault(); float?balance2 = tran.Amount; tran.Amount = (float)(balance + Mantainance); db.SaveChanges(); } catch (Exception ex) { } } int Cust_Tran_Type = 0; Cust_Tran_Type = db.tblCustomer_Tran_Type.Where(a => a.Tran_Type == "Customer Invoice").Select(a => a.Cust_Tran_Type_ID).FirstOrDefault(); db.tblCustomer_Transaction_Detail.Add(new Models.tblCustomer_Transaction_Detail { Credit = 0, Debit = Mantainance, Cust_Tran_ID = (int)Cust_Tran_ID, Description = "Mantainance", Trans_Date = trandate, Cust_Tran_Type_ID = Cust_Tran_Type, Tran_Nbr = strTran_Nbr, UserID = UserID, Unit_price = Mantainance, Qty = 1, Invoice_No = serialno, Route = inwords, Status = "Open", Balance = (float)balance }); db.SaveChanges(); float intTotal_Vendor_Balance = (float)db.Get_Total_Customer_Transaction_Detail_by_TranID(Cust_Tran_ID).FirstOrDefault(); db.Update_Customer_Tranaction_Amount_By_Cust_tran_id(intTotal_Vendor_Balance, Cust_Tran_ID); var customername = db.tblCustomers.Where(a => a.CustomerID == ID).Select(a => a.Customer_Name).FirstOrDefault(); // Add Journal db.tblJournals.Add(new Models.tblJournal { Journal_Date = trandate, Tran_Nbr = strTran_Nbr, TYear = trandate.Year, Period = trandate.Month, UserID = UserID, Status = "Open", Tran_Type = "Customers", Description = "Customer Post", }); db.SaveChanges(); int Journal_id = db.tblJournals.Where(a => a.UserID == UserID).Select(a => a.Journal_id).Max(); // AR db.tblJournal_Details.Add(new Models.tblJournal_Details { Journal_id = Journal_id, Debit = Mantainance, Credit = 0, Account_Number = 1150 }); db.SaveChanges(); // Income db.tblJournal_Details.Add(new Models.tblJournal_Details { Journal_id = Journal_id, Debit = 0, Credit = Mantainance, Account_Number = 3130 }); db.SaveChanges(); int Journal_Detail_id = db.tblJournal_Details.Where(a => a.Journal_id == Journal_id).Select(a => a.Journal_Detail_id).Max(); var y = db.tblInvoices.FirstOrDefault(); if (y != null) { y.Invoice_No = serialno; db.SaveChanges(); } i += 1; serialno += 1; } return(RedirectToAction("CustomerPost", "Customers", new { msg = "Customer Posted Successfully for " + i + " Customer(s)" })); }