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