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