public ActionResult Create_Tally_Sheet(Tally_SheetModel tally_sheetModel) { Tally_Sheet_Details tally_sheet_details = new Tally_Sheet_Details(); var tally_sheet_id = Convert.ToInt32(Session["tally_sheet_id"]); if (ModelState.IsValid) { tally_sheet_details.tally_sheet_id = tally_sheet_id; tally_sheet_details.way_bill_code = tally_sheetModel.way_bill_code; tally_sheet_details.goods_name = tally_sheetModel.goods; tally_sheet_details.units = tally_sheetModel.units; tally_sheet_details.quantity = tally_sheetModel.quantity; tally_sheet_details.unit_of_measure = tally_sheetModel.unit_of_measure; tally_sheet_details.total_quantity = tally_sheetModel.total_quantity; db.Tally_Sheet_Details.Add(tally_sheet_details); db.SaveChanges(); return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_id }); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_id }); }
public void SaveExcel(string path, string hd_tally_sheet_id) { XlsFile myFile = new XlsFile(path); myFile.ActiveSheet = 1; int rowCount = myFile.RowCount; int colCount = myFile.ColCount; for (int i = 2; i <= rowCount; i++) { if (myFile.GetCellValue(i, 1) == null) { break; } Puntland_Port_Taxation.Tally_Sheet_Details tsheet = new Tally_Sheet_Details(); tsheet.tally_sheet_id = int.Parse(hd_tally_sheet_id); tsheet.way_bill_code = myFile.GetCellValue(i, 1).ToString(); tsheet.goods_name = myFile.GetCellValue(i, 2).ToString(); tsheet.units = (myFile.GetCellValue(i, 3).ToString()); tsheet.quantity = myFile.GetCellValue(i, 4).ToString(); tsheet.unit_of_measure = (myFile.GetCellValue(i, 5).ToString()); tsheet.total_quantity = (myFile.GetCellValue(i, 6).ToString()); db.Tally_Sheet_Details.Add(tsheet); db.SaveChanges(); } }
public ActionResult Edit(Tally_SheetModel tally_sheetModel) { int id = Convert.ToInt32(TempData["id"]); Tally_Sheet_Details tally_sheet_details = new Tally_Sheet_Details(); if (ModelState.IsValid) { tally_sheet_details.tally_sheet_details_id = id; tally_sheet_details.tally_sheet_id = Convert.ToInt32(TempData["tally_sheet_id"]); tally_sheet_details.way_bill_code = tally_sheetModel.way_bill_code; tally_sheet_details.goods_name = tally_sheetModel.goods; tally_sheet_details.units = tally_sheetModel.units; tally_sheet_details.quantity = tally_sheetModel.quantity; tally_sheet_details.unit_of_measure = tally_sheetModel.unit_of_measure; tally_sheet_details.total_quantity = tally_sheetModel.total_quantity; db.Entry(tally_sheet_details).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); }
public ActionResult DbSearchresult_new(Tally_Sheet_Details tally_sheet) { var tally_sheet_id = Convert.ToInt32(Session["tally_sheet_id"]); if (tally_sheet.goods_name != null && tally_sheet.way_bill_code != null) { var result = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id where td.goods_name == tally_sheet.goods_name && td.way_bill_code == tally_sheet.way_bill_code && td.tally_sheet_id == tally_sheet_id select new Tally_SheetModel { tally_sheet_id = t.tally_sheet_id, way_bill_code = td.way_bill_code, goods = td.goods_name, units = td.units, quantity = td.quantity, unit_of_measure = td.unit_of_measure, total_quantity = td.total_quantity, tally_sheet_code = t.tally_sheet_code, tally_sheet_details_id = td.tally_sheet_details_id }; return View("Details", result.ToList()); } else if (tally_sheet.goods_name != null && tally_sheet.way_bill_code == null) { var result = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id where td.goods_name == tally_sheet.goods_name && td.tally_sheet_id == tally_sheet_id select new Tally_SheetModel { tally_sheet_id = t.tally_sheet_id, way_bill_code = td.way_bill_code, goods = td.goods_name, units = td.units, quantity = td.quantity, unit_of_measure = td.unit_of_measure, total_quantity = td.total_quantity, tally_sheet_code = t.tally_sheet_code, tally_sheet_details_id = td.tally_sheet_details_id }; return View("Details", result.ToList()); } else if (tally_sheet.goods_name == null && tally_sheet.way_bill_code != null) { var result = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id where td.way_bill_code == tally_sheet.way_bill_code && td.tally_sheet_id == tally_sheet_id select new Tally_SheetModel { tally_sheet_id = t.tally_sheet_id, way_bill_code = td.way_bill_code, goods = td.goods_name, units = td.units, quantity = td.quantity, unit_of_measure = td.unit_of_measure, total_quantity = td.total_quantity, tally_sheet_code = t.tally_sheet_code, tally_sheet_details_id = td.tally_sheet_details_id }; return View("Details", result.ToList()); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_id }); }
public void SaveExcel(string path, string hd_tally_sheet_id) { XlsFile myFile = new XlsFile(path); myFile.ActiveSheet = 1; int rowCount = myFile.RowCount; int colCount = myFile.ColCount; for (int i = 2; i <= rowCount; i++) { if (myFile.GetCellValue(i, 1) == null || myFile.GetCellValue(i, 2) == null || myFile.GetCellValue(i, 3) == null || myFile.GetCellValue(i, 4) == null) { continue; } Puntland_Port_Taxation.Tally_Sheet_Details tsheet = new Tally_Sheet_Details(); tsheet.tally_sheet_id = int.Parse(hd_tally_sheet_id); tsheet.way_bill_code = myFile.GetCellValue(i, 1).ToString().Trim(); tsheet.importer_name = myFile.GetCellValue(i, 2).ToString().Trim(); tsheet.goods_name = myFile.GetCellValue(i, 3).ToString(); tsheet.total_quantity = Convert.ToInt32((myFile.GetCellValue(i, 4).ToString())); tsheet.unit_of_measure = (myFile.GetCellValue(i, 5).ToString()); var damaged = (myFile.GetCellValue(i, 6).ToString()); damaged = damaged.ToLower(); if (damaged == "yes") { tsheet.is_damaged = true; } else { tsheet.is_damaged = false; } db.Tally_Sheet_Details.Add(tsheet); db.SaveChanges(); } }
public ActionResult Edit(Tally_SheetModel tally_sheetModel) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(12)) { int id = Convert.ToInt32(TempData["id"]); Tally_Sheet_Details tally_sheet_details = new Tally_Sheet_Details(); if (ModelState.IsValid) { tally_sheet_details.tally_sheet_details_id = id; tally_sheet_details.tally_sheet_id = Convert.ToInt32(TempData["tally_sheet_id"]); tally_sheet_details.way_bill_code = tally_sheetModel.way_bill_code; tally_sheet_details.importer_name = tally_sheetModel.importer_name; tally_sheet_details.goods_name = tally_sheetModel.goods; tally_sheet_details.unit_of_measure = tally_sheetModel.unit_of_measure; tally_sheet_details.total_quantity = tally_sheetModel.total_quantity; tally_sheet_details.is_damaged = tally_sheetModel.is_damaged; db.Entry(tally_sheet_details).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_details.tally_sheet_id }); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult DbSearchresult_new(Tally_Sheet_Details tally_sheet) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(12)) { var tally_sheet_id = Convert.ToInt32(Session["tally_sheet_id"]); if (tally_sheet.goods_name != null && tally_sheet.way_bill_code != null) { var result = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id where td.goods_name == tally_sheet.goods_name && td.way_bill_code == tally_sheet.way_bill_code && td.tally_sheet_id == tally_sheet_id select new Tally_SheetModel { tally_sheet_id = t.tally_sheet_id, way_bill_code = td.way_bill_code, goods = td.goods_name, unit_of_measure = td.unit_of_measure, total_quantity = td.total_quantity, tally_sheet_code = t.tally_sheet_code, tally_sheet_details_id = td.tally_sheet_details_id, importer_name = td.importer_name, is_damaged = td.is_damaged }; return View("Details", result.ToList()); } else if (tally_sheet.goods_name != null && tally_sheet.way_bill_code == null) { var result = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id where td.goods_name == tally_sheet.goods_name && td.tally_sheet_id == tally_sheet_id select new Tally_SheetModel { tally_sheet_id = t.tally_sheet_id, way_bill_code = td.way_bill_code, goods = td.goods_name, unit_of_measure = td.unit_of_measure, total_quantity = td.total_quantity, tally_sheet_code = t.tally_sheet_code, tally_sheet_details_id = td.tally_sheet_details_id, importer_name = td.importer_name, is_damaged = td.is_damaged }; return View("Details", result.ToList()); } else if (tally_sheet.goods_name == null && tally_sheet.way_bill_code != null) { var result = from t in db.Tally_Sheet join td in db.Tally_Sheet_Details on t.tally_sheet_id equals td.tally_sheet_id where td.way_bill_code == tally_sheet.way_bill_code && td.tally_sheet_id == tally_sheet_id select new Tally_SheetModel { tally_sheet_id = t.tally_sheet_id, way_bill_code = td.way_bill_code, goods = td.goods_name, unit_of_measure = td.unit_of_measure, total_quantity = td.total_quantity, tally_sheet_code = t.tally_sheet_code, tally_sheet_details_id = td.tally_sheet_details_id, importer_name = td.importer_name, is_damaged = td.is_damaged }; return View("Details", result.ToList()); } return RedirectToAction("Details", new { tally_sheet_id = tally_sheet_id }); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }