public ActionResult EditJornal(List <jornalEntries> jornalentries, FormCollection col) { int mn = Convert.ToInt32(col["month"]); int fyId = Convert.ToInt32(col["fyId"]); DateTime enDate = Convert.ToDateTime(col["enDate"]); string nepDateStr = col["nepDate"].Replace('-', '/'); string note = TrimText(col["note"]); string year = getYear(fyId, mn); decimal chequeRakam = Convert.ToDecimal(col["chequeRakam"]); int baUSiNaId; try { baUSiNaId = Convert.ToInt32(col["baUSiNaId"]); } catch { baUSiNaId = 1; } //string year =TrimText(StringToUnicode(date.Year.ToString())); if (ModelState.IsValid) { foreach (var item in jornalentries) { if (item.jornalEntriesId != 0) { jornalEntries objJornal = db.jornalEntries.Find(item.jornalEntriesId); objJornal.jornalNo = TrimText(objJornal.jornalNo); objJornal.baUSiNaId = baUSiNaId; objJornal.jornalType = col["jornalType"]; objJornal.month = ((month)mn).ToString(); objJornal.nepDate = DateTime.Now; objJornal.enDate = enDate; objJornal.nepDateStr = nepDateStr; objJornal.note = note; objJornal.deCre = item.deCre; objJornal.debit = Math.Round(item.debit, 2); objJornal.credit = Math.Round(item.credit, 2); objJornal.bibaran = TrimText(item.bibaran); objJornal.hisabNo = TrimText(item.hisabNo); objJornal.khaPaNo = TrimText(item.khaPaNo); objJornal.sanketNo = TrimText(item.sanketNo); objJornal.year = year; objJornal.monthIndex = MI.change(nepDateStr); objJornal.chequeRakam = chequeRakam; } else { jornalEntries objJornal = new jornalEntries(); objJornal.jornalNo = TrimText(jornalentries[0].jornalNo); objJornal.baUSiNaId = baUSiNaId; objJornal.jornalType = col["jornalType"]; objJornal.month = ((month)mn).ToString(); objJornal.nepDate = DateTime.Now; objJornal.nepDateStr = nepDateStr; objJornal.enDate = enDate; objJornal.note = note; objJornal.deCre = item.deCre; objJornal.debit = Math.Round(item.debit, 2); objJornal.credit = Math.Round(item.credit, 2); objJornal.bibaran = TrimText(item.bibaran); objJornal.hisabNo = TrimText(item.hisabNo); objJornal.khaPaNo = TrimText(item.khaPaNo); objJornal.sanketNo = TrimText(item.sanketNo); objJornal.year = year; objJornal.monthIndex = MI.change(nepDateStr); objJornal.fyId = fyId; objJornal.chequeRakam = chequeRakam; db.jornalEntries.Add(objJornal); } } db.SaveChanges(); if (jornalentries[0].jornalType == "धरौटी फिर्ता") { int rowNo = Convert.ToInt32(col["RowCount"]); for (int i = 0; i < rowNo; i++) { int bhuktaniAdeshId = Convert.ToInt32(col[i + "bhuktaniAdeshId"]); if (bhuktaniAdeshId != 0) { //Add Bhuktani Adesh bhuktaniAdesh objBhuktani = db.bhuktaniAdeshs.Find(bhuktaniAdeshId); objBhuktani.baUSiNaId = baUSiNaId; objBhuktani.bhuktaniAdeshNo = TrimText(col["bhuktaniAdeshNo"]); objBhuktani.jornalKharchaNo = jornalentries[0].jornalNo;//jornalKharchaNo as jornalBhuktaniAdeshNo objBhuktani.rakam = Math.Round(Convert.ToDecimal(col[i + "rakam"])); objBhuktani.pauneKoNaam = TrimText(col[i + "pauneKoNaam"]); objBhuktani.pauneKoCode = TrimText(col[i + "pauneKoCode"]);//paunekoCode as प्यान नं. objBhuktani.nepDate = DateTime.Now; objBhuktani.enDate = enDate; objBhuktani.nepDateStr = nepDateStr; objBhuktani.reamrks = TrimText(col[i + "remarks"]); objBhuktani.bibaran = TrimText(col[i + "khaSirsak"]); objBhuktani.khaSiNo = TrimText(col[i + "khaSiNo"]); objBhuktani.jornalNikasiNo = "०"; objBhuktani.year = year; objBhuktani.month = ((month)mn).ToString(); objBhuktani.bhuktaniType = "भुक्तानी आदेश धरौटी"; objBhuktani.monthIndex = MI.change(nepDateStr); objBhuktani.panNo = TrimText(col[i + "panNo"]); objBhuktani.fyId = fyId; } else { bhuktaniAdesh objBhuktani = new bhuktaniAdesh(); objBhuktani.baUSiNaId = baUSiNaId; objBhuktani.bhuktaniAdeshNo = TrimText(col["bhuktaniAdeshNo"]); objBhuktani.jornalKharchaNo = jornalentries[0].jornalNo;//jornalKharchaNo as jornalBhuktaniAdeshNo objBhuktani.rakam = Convert.ToDecimal(col[i + "rakam"]); objBhuktani.pauneKoNaam = TrimText(col[i + "pauneKoNaam"]); objBhuktani.pauneKoCode = TrimText(col[i + "pauneKoCode"]); objBhuktani.nepDate = DateTime.Now; objBhuktani.enDate = enDate; objBhuktani.nepDateStr = nepDateStr; objBhuktani.reamrks = TrimText(col[i + "remarks"]); objBhuktani.bibaran = TrimText(col[i + "khaSirsak"]); objBhuktani.khaSiNo = TrimText(col[i + "khaSiNo"]); objBhuktani.jornalNikasiNo = "०"; objBhuktani.year = year; objBhuktani.month = ((month)mn).ToString(); objBhuktani.bhuktaniType = "भुक्तानी आदेश धरौटी"; objBhuktani.monthIndex = MI.change(nepDateStr); objBhuktani.fyId = fyId; objBhuktani.panNo = TrimText(col[i + "panNo"]); db.bhuktaniAdeshs.Add(objBhuktani); } } db.SaveChanges(); } else if (jornalentries[0].jornalType == "धरौटी आम्दानी") { int rowNo = Convert.ToInt32(col["RowCount2"]); for (int i = 0; i < rowNo; i++) { int dharautiAmdaniId = Convert.ToInt32(col[i + "dharautiAmdaniId"]); //Add Bhuktani Adesh if (dharautiAmdaniId != 0) { dharautiAmdani objdharauti = db.dharautiAmdanis.Find(dharautiAmdaniId); objdharauti.nepDate = col[i + "nepDate"].Replace('-', '/'); objdharauti.dharautiRakhne = col[i + "dharautiRakhne"]; objdharauti.billNo = col[i + "billNo"]; objdharauti.fyId = fyId; objdharauti.billRakamNoVat = Convert.ToDecimal(col[i + "billRakamNoVat"]); objdharauti.VatRakam = Convert.ToDecimal(col[i + "vatRakam"]); objdharauti.dharautiRakam = Convert.ToDecimal(col[i + "dharautiRakam"]); objdharauti.bapat = col[i + "bapat"]; objdharauti.jornalNo = jornalentries[0].jornalNo; objdharauti.monthIndex = MI.change(nepDateStr); } else { dharautiAmdani objdharauti = new dharautiAmdani(); objdharauti.nepDate = col[i + "nepDate"].Replace('-', '/'); objdharauti.dharautiRakhne = col[i + "dharautiRakhne"]; objdharauti.billNo = col[i + "billNo"]; objdharauti.fyId = fyId; objdharauti.billRakamNoVat = Convert.ToDecimal(col[i + "billRakamNoVat"]); objdharauti.VatRakam = Convert.ToDecimal(col[i + "vatRakam"]); objdharauti.dharautiRakam = Convert.ToDecimal(col[i + "dharautiRakam"]); objdharauti.bapat = col[i + "bapat"]; objdharauti.jornalNo = jornalentries[0].jornalNo; objdharauti.monthIndex = MI.change(nepDateStr); db.dharautiAmdanis.Add(objdharauti); } } db.SaveChanges(); } return(RedirectToAction("IndexJornal")); } ViewBag.baUSiNaId = new SelectList(db.baUSiNas, "baUSiNaId", "baUSiNo", baUSiNaId); // var objFiscalYear = db.fisYears.FirstOrDefault(m => m.status == true); ViewBag.fyId = new SelectList(db.fisYears, "fyId", "nepFy", jornalentries[0].fyId); return(View(jornalentries)); }
public ActionResult CreateJornal(List <jornalEntries> jornalentries, FormCollection col) { int baUSiNaId; try { baUSiNaId = Convert.ToInt32(col["baUSiNaId"]); int mn = Convert.ToInt32(col["month"]); int fyId = Convert.ToInt32(col["fyId"]); string jornalNo = col["jornalNo"]; DateTime enDate = Convert.ToDateTime(col["enDate"]); string nepDateStr = col["nepDate"].Replace('-', '/'); string note = TrimText(col["note"]); string type = TrimText(col["Type"]); string year = getYear(fyId, mn); decimal chequeRakam = Convert.ToDecimal(col["chequeRakam"].ToString()); //string year = StringToUnicode(date.Year.ToString()); if (ModelState.IsValid) { foreach (var item in jornalentries) { //Add Jornal jornalEntries jornal = new jornalEntries(); jornal.jornalNo = TrimText(jornalNo); jornal.baUSiNaId = baUSiNaId; jornal.jornalType = type; jornal.month = ((month)mn).ToString(); jornal.nepDate = DateTime.Now; jornal.nepDateStr = nepDateStr; jornal.enDate = enDate; jornal.note = TrimText(note); jornal.deCre = item.deCre; jornal.debit = Math.Round(item.debit, 2); jornal.credit = Math.Round(item.credit, 2); jornal.bibaran = TrimText(item.bibaran); jornal.hisabNo = TrimText(item.hisabNo); jornal.khaPaNo = TrimText(item.khaPaNo); jornal.sanketNo = TrimText(item.sanketNo); jornal.year = year; jornal.monthIndex = MI.change(nepDateStr); jornal.fyId = fyId; jornal.chequeRakam = chequeRakam; db.jornalEntries.Add(jornal); } db.SaveChanges(); //update JornalEntries Number var setNum = db.setNumbers.FirstOrDefault(m => m.faramName == "Dharauti"); setNum.faramName = setNum.faramName; setNum.number = setNum.number + 1; db.SaveChanges(); if (type == "धरौटी फिर्ता") { int rowNo = Convert.ToInt32(col["RowCount"]); for (int i = 0; i <= rowNo; i++) { //Add Bhuktani Adesh bhuktaniAdesh objBhuktani = new bhuktaniAdesh(); objBhuktani.baUSiNaId = baUSiNaId; objBhuktani.bhuktaniAdeshNo = TrimText(col["bhuktaniAdeshNo"]); objBhuktani.jornalKharchaNo = TrimText(jornalNo);//jornalKharchaNo as jornalBhuktaniAdeshNo objBhuktani.rakam = Math.Round(Convert.ToDecimal(col[i + "rakam"]), 2); objBhuktani.pauneKoNaam = TrimText(col[i + "pauneKoNaam"]); objBhuktani.pauneKoCode = TrimText(col[i + "pauneKoCode"]); objBhuktani.nepDate = DateTime.Now; objBhuktani.nepDateStr = nepDateStr;// col[i + "nepDate"].Replace('-', '/'); objBhuktani.enDate = enDate; objBhuktani.reamrks = TrimText(col[i + "remarks"]); objBhuktani.bibaran = TrimText(col[i + "khaSirsak"]); objBhuktani.khaSiNo = TrimText(col[i + "khaSiNo"]); objBhuktani.jornalNikasiNo = "०"; objBhuktani.year = year; objBhuktani.month = ((month)mn).ToString(); objBhuktani.bhuktaniType = "भुक्तानी आदेश धरौटी"; objBhuktani.monthIndex = MI.change(nepDateStr); objBhuktani.fyId = fyId; objBhuktani.panNo = TrimText(col[i + "panNo"]); db.bhuktaniAdeshs.Add(objBhuktani); } db.SaveChanges(); //update JornalEntries Number var setNum1 = db.setNumbers.FirstOrDefault(m => m.faramName == "BhuktaniAdeshDharauti"); setNum1.faramName = setNum1.faramName; setNum1.number = setNum1.number + 1; db.SaveChanges(); } else if (type == "धरौटी आम्दानी") { int rowNo = Convert.ToInt32(col["RowCount2"]); for (int i = 0; i <= rowNo; i++) { //Add DharautiAmdani dharautiAmdani objAmdani = new dharautiAmdani(); objAmdani.nepDate = col[i + "nepDate"].Replace('-', '/'); objAmdani.dharautiRakhne = col[i + "dharautiRakhne"]; objAmdani.billNo = col[i + "billNo"]; objAmdani.fyId = fyId; objAmdani.billRakamNoVat = Convert.ToDecimal(col[i + "billRakamNoVat"]); objAmdani.VatRakam = Convert.ToDecimal(col[i + "vatRakam"]); objAmdani.dharautiRakam = Convert.ToDecimal(col[i + "dharautiRakam"]); objAmdani.bapat = col[i + "bapat"]; objAmdani.jornalNo = jornalNo; objAmdani.monthIndex = MI.change(nepDateStr); db.dharautiAmdanis.Add(objAmdani); } db.SaveChanges(); } return(RedirectToAction("IndexJornal")); } else { ViewBag.baUSiNaId = new SelectList(db.baUSiNas, "baUSiNaId", "baUSiNo", baUSiNaId); ViewBag.fyId = new SelectList(db.fisYears, "fyId", "nepFy", fyId); return(View(jornalentries)); } } catch (Exception ex) { ViewBag.ErrorMessage = ex; var objBaUSiNa = db.baUSiNas.FirstOrDefault(m => m.baUSirsak == "धरौटी"); ViewBag.baUSiNaId = new SelectList(db.baUSiNas, "baUSiNaId", "baUSiNo", objBaUSiNa.baUSiNaId); int fyId = Convert.ToInt32(col["fyId"]); ViewBag.fyId = new SelectList(db.fisYears, "fyId", "nepFy", fyId); return(View(jornalentries)); } }