public ActionResult SetBurdenForFinancial(long id) { if (id > 0) { T_ConsumerFinancialStatements tcfs = db.T_ConsumerFinancialStatements.Find(id); int ConsumerID = tcfs.ConsumerID; string FromDate = tcfs.FromDate.Substring(0, 10); string ToDate = tcfs.ToDate.Substring(0, 10); var burdeninformations = db.T_BurdenInformations.Where(m => m.T_TransportPrices.ConsumerID == ConsumerID && m.CFSID == null && m.UnLoadDateTime.Substring(0, 10).CompareTo(FromDate) >= 0 && m.UnLoadDateTime.Substring(0, 10).CompareTo(ToDate) <= 0).ToList(); foreach (var item in burdeninformations) { item.CFSID = id; } // db.T_BurdenInformations.(burdeninformations).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", new { id = id })); } return(View()); }
public ActionResult Delete(long id = 0) { T_ConsumerFinancialStatements t_consumerfinancialstatements = db.T_ConsumerFinancialStatements.Find(id); if (t_consumerfinancialstatements == null) { return(HttpNotFound()); } return(View(t_consumerfinancialstatements)); }
public ActionResult Edit(T_ConsumerFinancialStatements t_consumerfinancialstatements) { if (ModelState.IsValid) { db.Entry(t_consumerfinancialstatements).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ConsumerID = new SelectList(db.T_Consumers, "ConsumerID", "CompanyName", t_consumerfinancialstatements.ConsumerID); ViewBag.StateID = new SelectList(db.T_FinancialStates, "StateID", "StateName", t_consumerfinancialstatements.StateID); return(View(t_consumerfinancialstatements)); }
public ActionResult Edit(long id = 0) { T_ConsumerFinancialStatements t_consumerfinancialstatements = db.T_ConsumerFinancialStatements.Find(id); if (t_consumerfinancialstatements == null) { return(HttpNotFound()); } ViewBag.ConsumerID = new SelectList(db.T_Consumers, "ConsumerID", "CompanyName", t_consumerfinancialstatements.ConsumerID); ViewBag.StateID = new SelectList(db.T_FinancialStates, "StateID", "StateName", t_consumerfinancialstatements.StateID); return(View(t_consumerfinancialstatements)); }
public ActionResult Create(T_ConsumerFinancialStatements t_consumerfinancialstatements) { if (ModelState.IsValid) { db.T_ConsumerFinancialStatements.Add(t_consumerfinancialstatements); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ConsumerID = new SelectList(db.T_Consumers.Where(m => m.StateID == true), "ConsumerID", "CompanyName", t_consumerfinancialstatements.ConsumerID); ViewBag.StateID = new SelectList(db.T_FinancialStates, "StateID", "StateName", t_consumerfinancialstatements.StateID); return(View(t_consumerfinancialstatements)); }
public ActionResult Details(long id = 0) { T_ConsumerFinancialStatements t_consumerfinancialstatements = db.T_ConsumerFinancialStatements.Find(id); if (t_consumerfinancialstatements == null) { return(HttpNotFound()); } ViewBag.Burdens = db.T_BurdenInformations.Where(m => m.CFSID == id); ViewBag.Pays = db.T_ConsumersPays.Where(m => m.CFSID == id); return(View(t_consumerfinancialstatements)); }
public ActionResult DeleteConfirmed(long id) { ViewBag.err = ""; try { T_ConsumerFinancialStatements t_consumerfinancialstatements = db.T_ConsumerFinancialStatements.Find(id); db.T_ConsumerFinancialStatements.Remove(t_consumerfinancialstatements); db.SaveChanges(); } catch { ViewBag.err = "این صورت حساب حواله دارد ابتدا حواله ها را حذف کرده سپس تلاش کنید"; } return(RedirectToAction("Index")); }
public ActionResult ShowReportSearch(T_ConsumerFinancialStatements t_confinans, FormCollection frm) { if (frm["ConsumerID"].ToString() != "" || frm["FromDate"].ToString() != "" || frm["ToDate"].ToString() != "") { long consumerID = 0; string fromDate = "", toDate = ""; try { consumerID = long.Parse(frm["ConsumerID"].ToString()); } catch { } try { fromDate = frm["FromDate"].ToString(); } catch { } try { toDate = frm["ToDate"].ToString(); } catch { } return(RedirectToAction("ShowSearch", "ConsumerFinancialStatement", new { ConsumerID = consumerID, FromDate = fromDate, ToDate = toDate })); } else { ViewBag.ConsumerID = new SelectList(db.T_Consumers.ToList(), "ConsumerID", "CompanyName"); return(View()); } // return View(); }
public ActionResult GetReportSnapshotAccountant(long id = 0) { if (id != 0) { T_ConsumerFinancialStatements cfs = db.T_ConsumerFinancialStatements.Find(id); StiReport report = new StiReport(); string path = Server.MapPath("~/Reports/cfs-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["CFSID"] = " where ConsumerFinancialStatementID =" + id.ToString(); report["kol"] = decimal.Parse(cfs._BurdonsSumPrices.ToString()); report["albaghi"] = decimal.Parse(cfs._Creditor.ToString()); //report.Render(); report.Render(); return(StiMvcViewer.GetReportSnapshotResult(report)); } else { return(RedirectToAction("index")); } }