public ActionResult DeleteJornal(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
jornalEntries objJornal = db.jornalEntries.Find(id);
List <jornalEntries> jornalentries = db.jornalEntries.Where(m => m.jornalNo == objJornal.jornalNo && m.jornalType == objJornal.jornalType && m.fyId == objJornal.fyId && m.monthIndex == objJornal.monthIndex).ToList();
if (jornalentries == null)
{
return(HttpNotFound());
}
else
{
try
{
foreach (var item in jornalentries)
{
db.jornalEntries.Remove(item);
}
db.SaveChanges();
TempData["Message"] = "Record Deleted Successfully.";
return(RedirectToAction("IndexJornal", "Dharauti"));
}
catch
{
TempData["ErrorMessage"] = "No Record Deleted.";
return(RedirectToAction("IndexJornal", "Dharauti"));
}
}
}
public ActionResult EditJornal(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
jornalEntries jornalentries = db.jornalEntries.Find(id);
List <jornalEntries> objJornalEntries = db.jornalEntries.Where(m => (m.jornalNo == jornalentries.jornalNo) && (m.monthIndex == jornalentries.monthIndex) && (m.fyId == jornalentries.fyId) && (m.jornalType == jornalentries.jornalType)).ToList();
int i = 0;
var decre = new List <SelectListItem> {
new SelectListItem {
Text = "--डे/क्रे--", Value = ""
},
new SelectListItem {
Text = "डेबिट", Value = "debit"
},
new SelectListItem {
Text = "क्रेडिट", Value = "credit"
}
};
var jornalType = new List <SelectListItem> {
new SelectListItem {
Text = "--किसिम--", Value = ""
},
new SelectListItem {
Text = "धरौटी आम्दानी", Value = "धरौटी आम्दानी"
},
new SelectListItem {
Text = "धरौटी फिर्ता", Value = "धरौटी फिर्ता"
}
};
var selectedType = jornalType.Where(m => m.Value == objJornalEntries[0].jornalType).First();
selectedType.Selected = true;
ViewData.Add("jornalType", jornalType);
foreach (var item in objJornalEntries)
{
var selected = decre.Where(x => x.Value == item.deCre).First();
selected.Selected = true;
ViewData.Add("[" + i + "].deCre", decre);
i++;
}
if (objJornalEntries == null)
{
return(HttpNotFound());
}
ViewBag.fyId = new SelectList(db.fisYears, "fyId", "nepFy", objJornalEntries[0].fyId);
var objBaUSiNa = db.baUSiNas.FirstOrDefault(m => m.baUSirsak == "धरौटी");
ViewBag.baUSiNaId = new SelectList(db.baUSiNas, "baUSiNaId", "baUSiNo", objBaUSiNa.baUSiNaId);
ViewBag.BhuktnaiBibaran = null;
ViewBag.RowCount = 0;
if (jornalentries.jornalType == "धरौटी फिर्ता")
{
var objBhuktani = db.bhuktaniAdeshs.Where(m => (m.bhuktaniType == "भुक्तानी आदेश धरौटी") && (m.jornalKharchaNo == jornalentries.jornalNo) && (m.fyId == jornalentries.fyId) && (m.monthIndex == jornalentries.monthIndex)).ToList();
ViewBag.BhuktaniBibaran = objBhuktani;
ViewBag.RowCount = objBhuktani.Count;
ViewBag.bhuktaniAdeshNo = objBhuktani[0].bhuktaniAdeshNo;
}
else if (jornalentries.jornalType == "धरौटी आम्दानी")
{
var objDharautiAmdani = db.dharautiAmdanis.Where(m => m.fyId == jornalentries.fyId && m.monthIndex == jornalentries.monthIndex && m.jornalNo == jornalentries.jornalNo).ToList();
ViewBag.DharautiAmdani = objDharautiAmdani;
ViewBag.RowCount2 = objDharautiAmdani.Count;
}
return(View(objJornalEntries));
}
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));
}
}
