public ActionResult Save(FormCollection fc) { if (fc["id"] == null || fc["id"] == "") { Billtype_details t = new Billtype_details(); Boolean res = t.InsertBilltype_details(fc); if (res) { return(Content("Record Inserted Successfully")); } else { return(Content("Error Adding Record Try Again")); } } else { Billtype_details t = new Billtype_details(); Boolean res = t.UpdateBilltype_details(fc); if (res) { return(Content("Record Edited Successfully")); } else { return(Content("Error Editing Record Try Again")); } } //return PartialView("SaveRec"); }
public ActionResult Billtype_detailsdelete(int id) { Billtype_details t = new Billtype_details(); Boolean res = t.DeleteRecord(id); if (res) { return(Content("Record Deleted Successfully")); } else { return(Content("Error Deleting Record Try Again")); } }
public ActionResult GetBillDetails() { int billtypeid = Convert.ToInt16(Request["billid"]); DataSet ds = new DataSet(); String[] tblheader = { "Sl.no", "Type", "Acct.Head", "Db", "Cr", "Action" }; ViewBag.tblheader = tblheader; Billtype_details det = new Billtype_details(); DataTable dt = det.GetOrderedRecordsbilltype(billtypeid, "id"); ds.Tables.Add(dt); Session["datatable"] = dt; ViewBag.TotatDb = totaldbcr("DB", dt); ViewBag.TotalCr = totaldbcr("CR", dt); return(PartialView("GetBillDetails", dt)); }
public ActionResult GetBillDetails() { String[] tblheader = { "S.no", "trtype", "accountnumber", "dramount", "cramount", "Actions" }; ViewBag.tblheader = tblheader; Billtype_details btypdet = new Billtype_details(); DataTable dt = btypdet.GetOrderedRecords(1, 100, 1, "id"); //dt.Columns.Add("slno"); //for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["slno"] = i+1; } Session["billdetails"] = dt; DataTable newdt = (DataTable)Session["billdetails"]; //DataSet ds = new DataSet(); ds.Tables.Add(newdt); ViewBag.totcr = totvalues("CR", newdt); ViewBag.totdr = totvalues("DR", newdt); return(PartialView("GetBillDetails", newdt)); }
public ActionResult Billtype_detailslist(int id) { int pageno = Convert.ToInt16(Request["page"]); GenHelper.pager gen = new GenHelper.pager(); Billtype_details obj = new Billtype_details(); DataSet ds = new DataSet(); DataTable dt = obj.GetOrderedRecords(pageno, PerPageRec, id, "id desc"); Int32 cnt = obj.GetOrderedRecordsCount("id desc"); gen.PagedList(pageno, cnt, PerPageRec, "Billtype_details", "Billtype_detailslist"); ViewBag.pageLinks = gen.PageNos; ViewData["TableHeading"] = "List Of Billtype_details"; ViewData["addlink"] = "Billtype_detailsAdd"; dt.TableName = "Billtype_details"; ds.Tables.Add(dt); return(View("listBilltype_details", ds)); }