//table details
private void AddTableDetails(advance adv)
{
Table advancetable = new Table(3);
advancetable.WidthPercentage = 100;
advancetable.Spacing = 1;
advancetable.Padding = 1;
Cell empno = new Cell(new Phrase(adv.employeeno.ToString().Trim().ToUpper(), bfont1));
empno.HorizontalAlignment = Cell.ALIGN_LEFT;
advancetable.AddCell(empno);
Cell empname = new Cell(new Phrase(adv.employeename.ToString().ToUpper().Trim(), bfont1));
empname.HorizontalAlignment = Cell.ALIGN_LEFT;
advancetable.AddCell(empname);
Cell adamount = new Cell(new Phrase(string.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:N0}", adv.advanceamount), bfont1));
adamount.HorizontalAlignment = Cell.ALIGN_RIGHT;
advancetable.AddCell(adamount);
document.Add(advancetable);
}
private void materialButton1_Click(object sender, EventArgs e)
{
using (HamroSuperMarketEntities db = new HamroSuperMarketEntities())
{
advance advance = db.advances.Where(o => o.id == this.id).First();
db.Entry(advance).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
advance advance = await db.advances.FindAsync(id);
db.advances.Remove(advance);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "Advance_Id,Employee_Id,Amount,Advance_Date")] advance advance)
{
if (ModelState.IsValid)
{
db.Entry(advance).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.employees, "Employee_Id", "Employee_Name", advance.Employee_Id);
return(View(advance));
}
// GET: advances/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
advance advance = await db.advances.FindAsync(id);
if (advance == null)
{
return(HttpNotFound());
}
return(View(advance));
}
// GET: advances/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
advance advance = await db.advances.FindAsync(id);
if (advance == null)
{
return(HttpNotFound());
}
ViewBag.Employee_Id = new SelectList(db.employees, "Employee_Id", "Employee_Name", advance.Employee_Id);
return(View(advance));
}
//table details
private void AddBodyTableDetail(advance adv, ref int row, ref int col)
{
row++; col = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, adv.employeeno.ToString().Trim(), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, adv.employeename.ToString().Trim().ToUpper(), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, adv.advanceamount.ToString("#,##0"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
//col++;
//cellrangeaddr1 = document.IntAlpha(col) + row;
//document.createHeaders(row, col, adv.dateposted.ToString("dd-MMM-yyyy"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
}
