public ActionResult DeleteConfirmed(int id)
{
tblVoucherMaster tblVoucherMaster = db.tblVoucherMaster.Find(id);
db.tblVoucherMaster.Remove(tblVoucherMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: AddVoucher/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblVoucherMaster tblVoucherMaster = db.tblVoucherMaster.Find(id);
if (tblVoucherMaster == null)
{
return(HttpNotFound());
}
return(View(tblVoucherMaster));
}
public ActionResult Create([Bind(Include = "Voucher_Id,Voucher_No,Voucher_Date,Supplier_Id")] tblVoucherMaster tblVoucherMaster, string[] DynamicTextBox)
{
if (ModelState.IsValid)
{
db.tblVoucherMaster.Add(tblVoucherMaster);
//List<tblVoucherDetail> voucherDetailsList = new List<tblVoucherDetail>();
var rowCount = 0;
var itemCount = DynamicTextBox.Count();
if (itemCount > 0)
{
rowCount = itemCount / 3;
int j = 0;
for (int i = 1; i <= rowCount; i++)
{
tblVoucherDetail voucherDetails = new tblVoucherDetail();
string account_name = DynamicTextBox[j];
int account_id = db.tblAccountsHead.Where(a => a.Accounts_Name == account_name).Select(a => a.Accounts_Id).FirstOrDefault();
voucherDetails.Accounts_Id = account_id;
voucherDetails.Dr_Amount = Convert.ToDouble(DynamicTextBox[j + 1]);
voucherDetails.Cr_Amount = Convert.ToDouble(DynamicTextBox[j + 2]);
//voucherDetailsList.Add(voucherDetails);
db.tblVoucherDetail.Add(voucherDetails);
j = j + 3;
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Supplier_Id = new SelectList(db.tblSupplier, "Supplier_Id", "Supplier_Name", tblVoucherMaster.Supplier_Id);
return(View(tblVoucherMaster));
}
// GET: AddVoucher/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblVoucherMaster tblVoucherMaster = db.tblVoucherMaster.Find(id);
//db.tblVoucherDetail.Where(a => a.Voucher_Id == tblVoucherMaster.Voucher_Id).SelectMany(a=>a.Accounts_Id,a=>a.);
var voucherDetailList = db.tblVoucherDetail.Where(a => a.Voucher_Id == tblVoucherMaster.Voucher_Id).Select(i => new { i.Detail_Id, i.Accounts_Id, i.Dr_Amount, i.Cr_Amount }).Distinct().ToArray();
int voucherNumber = voucherDetailList.Count();
string[] textBoxValues = new string[voucherNumber * 4];
int x = 0;
foreach (var item in voucherDetailList)
{
int account_id = item.Accounts_Id;
string account_name = db.tblAccountsHead.Where(a => a.Accounts_Id == account_id).Select(a => a.Accounts_Name).FirstOrDefault();
textBoxValues[x] = item.Detail_Id.ToString();
textBoxValues[x + 1] = account_name;
textBoxValues[x + 2] = item.Dr_Amount.ToString();
textBoxValues[x + 3] = item.Cr_Amount.ToString();
x = x + 4;
}
;
ViewBag.VoucherItemNo = voucherNumber;
ViewBag.TextBoxData = JsonConvert.SerializeObject(textBoxValues);
if (tblVoucherMaster == null)
{
return(HttpNotFound());
}
ViewBag.Supplier_Id = new SelectList(db.tblSupplier, "Supplier_Id", "Supplier_Name", tblVoucherMaster.Supplier_Id);
return(View(tblVoucherMaster));
}
public ActionResult Edit([Bind(Include = "Voucher_Id,Voucher_No,Voucher_Date,Supplier_Id")] tblVoucherMaster tblVoucherMaster, string[] DynamicTextBox)
{
if (ModelState.IsValid)
{
db.Entry(tblVoucherMaster).State = EntityState.Modified;
#region voucher detail table update
var rowCount = 0;
var itemCount = DynamicTextBox.Count();
if (itemCount > 0)
{
rowCount = itemCount / 4;
int j = 0;
List <int> totalItemFromUI = new List <int>();
for (int i = 0; i < itemCount; i = i + 4)
{
if (DynamicTextBox[i] != "0")
{
totalItemFromUI.Add(Convert.ToInt16(DynamicTextBox[i]));
}
}
var totalItemInDetailForAVoucherId = db.tblVoucherDetail.Where(a => a.Voucher_Id == tblVoucherMaster.Voucher_Id).Select(a => a.Detail_Id).ToList();
var deletedIDs = totalItemInDetailForAVoucherId.Except(totalItemFromUI);
if (deletedIDs != null)
{
foreach (var item in deletedIDs)
{
var details = db.tblVoucherDetail.Where(a => a.Detail_Id == item).SingleOrDefault();
db.tblVoucherDetail.Remove(details);
}
db.SaveChanges();
}
for (int i = 1; i <= rowCount; i++)
{
tblVoucherDetail voucherDetails = new tblVoucherDetail();
int detailID = Convert.ToInt16(DynamicTextBox[j]);
string account_name = DynamicTextBox[j + 1];
int account_id = db.tblAccountsHead.Where(a => a.Accounts_Name == account_name).Select(a => a.Accounts_Id).FirstOrDefault();
double dr_amount = Convert.ToDouble(DynamicTextBox[j + 2]);
double cr_amount = Convert.ToDouble(DynamicTextBox[j + 3]);
if (detailID != 0)
{
var details = db.tblVoucherDetail.Where(a => a.Detail_Id == detailID).SingleOrDefault();
details.Accounts_Id = account_id;
details.Dr_Amount = dr_amount;
details.Cr_Amount = cr_amount;
}
else
{
voucherDetails.Accounts_Id = account_id;
voucherDetails.Dr_Amount = dr_amount;
voucherDetails.Cr_Amount = cr_amount;
voucherDetails.Voucher_Id = tblVoucherMaster.Voucher_Id;
db.tblVoucherDetail.Add(voucherDetails);
}
j = j + 4;
}
}
#endregion
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Supplier_Id = new SelectList(db.tblSupplier, "Supplier_Id", "Supplier_Name", tblVoucherMaster.Supplier_Id);
return(View(tblVoucherMaster));
}
