public ActionResult SetBurdenForFinancial(long id) { if (id > 0) { T_TruckFinancialStatements tcfs = db.T_TruckFinancialStatements.Find(id); int TruckID = tcfs.TruckID; string FromDate = tcfs.FromDate.Substring(0, 10); string ToDate = tcfs.ToDate.Substring(0, 10); //int ProducerID = db.T_ProducerFinancialStatements.Where(m => m.ProducerFinancialStatementID == id).ToList()[0].ProducerID; var burdeninformations = db.T_BurdenInformations.Where(m => m.TruckID == TruckID && m.TFSID == null && m.UnLoadDateTime.Substring(0, 10).CompareTo(FromDate) >= 0 && m.UnLoadDateTime.Substring(0, 10).CompareTo(ToDate) <= 0).ToList(); //int TruckID = db.T_TruckFinancialStatements.Where(m => m.TruckFinancialStatementID == id).ToList()[0].TruckID; //var burdeninformations = db.T_BurdenInformations.Where(m => m.TruckID == TruckID && m.TFSID == null).ToList(); foreach (var item in burdeninformations) { item.TFSID = id; } // db.T_BurdenInformations.(burdeninformations).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", new { id = id })); } return(View()); }
public ActionResult DeleteConfirmed(long id) { T_TruckFinancialStatements t_truckfinancialstatements = db.T_TruckFinancialStatements.Find(id); db.T_TruckFinancialStatements.Remove(t_truckfinancialstatements); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(long id = 0) { T_TruckFinancialStatements t_truckfinancialstatements = db.T_TruckFinancialStatements.Find(id); if (t_truckfinancialstatements == null) { return(HttpNotFound()); } return(View(t_truckfinancialstatements)); }
public ActionResult Edit(T_TruckFinancialStatements t_truckfinancialstatements) { if (ModelState.IsValid) { db.Entry(t_truckfinancialstatements).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StateID = new SelectList(db.T_FinancialStates, "StateID", "StateName", t_truckfinancialstatements.StateID); ViewBag.TruckID = new SelectList(db.T_Trucks, "TruckID", "_NumberName", t_truckfinancialstatements.TruckID); return(View(t_truckfinancialstatements)); }
public ActionResult Edit(long id = 0) { T_TruckFinancialStatements t_truckfinancialstatements = db.T_TruckFinancialStatements.Find(id); if (t_truckfinancialstatements == null) { return(HttpNotFound()); } ViewBag.StateID = new SelectList(db.T_FinancialStates, "StateID", "StateName", t_truckfinancialstatements.StateID); ViewBag.TruckID = new SelectList(db.T_Trucks, "TruckID", "_NumberName", t_truckfinancialstatements.TruckID); return(View(t_truckfinancialstatements)); }
public ActionResult Create(T_TruckFinancialStatements t_truckfinancialstatements) { if (ModelState.IsValid) { db.T_TruckFinancialStatements.Add(t_truckfinancialstatements); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StateID = new SelectList(db.T_FinancialStates, "StateID", "StateName", t_truckfinancialstatements.StateID); ViewBag.TruckID = new SelectList(db.T_Trucks.Where(m => m.StateID == true), "TruckID", "_NumberName", t_truckfinancialstatements.TruckID); return(View(t_truckfinancialstatements)); }
public ActionResult Details(long id = 0) { T_TruckFinancialStatements t_truckfinancialstatements = db.T_TruckFinancialStatements.Find(id); if (t_truckfinancialstatements == null) { return(HttpNotFound()); } ViewBag.Burdens = db.T_BurdenInformations.Where(m => m.TFSID == id); ViewBag.Pays = db.T_TrucksPays.Where(m => m.TFSID == id); return(View(t_truckfinancialstatements)); }
public ActionResult GetReportSnapshotAccountant(long id = 0) { if (id != 0) { T_TruckFinancialStatements tfs = db.T_TruckFinancialStatements.Find(id); StiReport report = new StiReport(); string path = Server.MapPath("~/Reports/tfs-pay.mrt"); report.Load(path); report.Dictionary.Databases.Clear(); string con = System.Configuration.ConfigurationManager.ConnectionStrings[Session["ReportConnection"].ToString()].ConnectionString; report.Dictionary.Databases.Add(new StiSqlDatabase("Maase", con)); //string con = System.Configuration.ConfigurationManager.ConnectionStrings["MaaseDBEntities"].ConnectionString; //report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Maase", con)); Image img = Image.FromFile(Server.MapPath(@"~/Images/logomaster.png")); report.Compile(); string p = Server.MapPath(@"~/TFont"); report["fontPath"] = p; report["logo"] = img; report["TFSID"] = " where TruckFinancialStatementID =" + id.ToString(); report["kol"] = decimal.Parse(tfs._BurdonsSumPrices.ToString()); report["albaghi"] = decimal.Parse(tfs._Creditor.ToString()); //report.Render(); report.Render(); return(StiMvcViewer.GetReportSnapshotResult(report)); } else { return(RedirectToAction("index")); } }