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