public static Unit_Of_Measurement_DTO Convert_Table_To_DTO(tblUnit Unit)
{
Unit_Of_Measurement_DTO Unit_DTO = new Unit_Of_Measurement_DTO();
try
{
if (Unit != null)
{
Unit_DTO.ID = Unit.ID;
Unit_DTO.Unit_Name = Unit.UName;
Unit_DTO.Unit_Symbol = Unit.USymbol;
Unit_DTO.Is_Disabled = Unit.Is_Disabled;
}
else
{
Unit_DTO.Unit_Name = Resources.NoUnitDefined;
Unit_DTO.Unit_Symbol = Resources.NoUnitDefined;
}
}
catch (Exception ex)
{
Unit_DTO.Unit_Name = Resources.NoUnitDefined + " - " + ex.Message;
Unit_DTO.Unit_Symbol = Resources.NoUnitDefined;
}
return(Unit_DTO);
}
private void LoadUnit()
{
List <tblUnit> lst = _db.tblUnits.ToList();
tblUnit tbl = new tblUnit();
tbl.UnitName = "Choose Unit";
lst.Insert(0, tbl);
cboUnit.DataSource = lst;
cboUnit.DisplayMember = "UnitName";
cboUnit.ValueMember = "UnitId";
cboUnit.SelectedIndex = 0;
}
public JsonResult UpdateUnit(tblUnit model)
{
var service = new UpdateServices();
var res = service.SaveChangesUnit(model);
if (res)
{
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false }));
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
tblUnit tb = new tblUnit();
tb.UnitName = txtCategoryName.Text;
_db.tblUnits.Add(tb);
if (_db.SaveChanges() > 0)
{
txtCategoryName.Text = "";
txtCategoryName.Focus();
LoadGrid();
MessageBox.Show("Unit created");
}
}
// GET: Units/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblUnit tblUnit = db.tblUnits.Find(id);
if (tblUnit == null)
{
return(HttpNotFound());
}
ViewBag.Unit = tblUnit;
var tblUnits = db.tblUnits.Include(t => t.tblUser).Include(t => t.tblUser1).Where(a => a.IsActive == true);
return(View("Index", tblUnits.ToList()));
}
public bool SaveUnit(tblUnit model)
{
using (var dbContextTransaction = _db.Database.BeginTransaction())
{
try
{
_db.Units.Add(model);
_db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(false);
}
}
}
public ActionResult Edit([Bind(Include = "UnitID,Name,Description,IsActive,CreatedOn,UpdatedOn,CreatedBy,UpdatedBy")] tblUnit tblUnit)
{
if (ModelState.IsValid)
{
tblUser objSource = (tblUser)Session["UserDetails"];
tblUnit.UpdatedOn = DateTime.Now;
tblUnit.UpdatedBy = objSource.Id;
db.Entry(tblUnit).State = EntityState.Modified;
ViewBag.Unit = new tblUnit();
TempData["Success"] = "Unit updated successfully.";
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Unit = new tblUnit();
var tblUnits = db.tblUnits.Include(t => t.tblUser).Include(t => t.tblUser1).Where(a => a.IsActive == true);
return(View("Index", tblUnits.ToList()));
}
public static Unit_Of_Measurement_DTO Convert_Table_To_DTO(tblUnit Unit)
{
Unit_Of_Measurement_DTO Unit_DTO = new Unit_Of_Measurement_DTO();
if (Unit != null)
{
Unit_DTO.ID = Unit.ID;
Unit_DTO.Unit_Name = Unit.UName;
Unit_DTO.Unit_Symbol = Unit.USymbol;
Unit_DTO.Is_Disabled = Unit.Is_Disabled;
}
else
{
Unit_DTO.Unit_Name = "";
Unit_DTO.Unit_Symbol = "";
}
return(Unit_DTO);
}
public bool SaveChangesUnit(tblUnit model)
{
using (var dbContextTransaction = _db.Database.BeginTransaction())
{
try
{
tblUnit item = _db.Units.Where(x => x.id == model.id).FirstOrDefault();
item.name = model.name;
item.description = model.description;
_db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(false);
}
}
}
// GET: Units/Delete/5
public ActionResult Delete(int?id)
{
tblUnit tblUnit = db.tblUnits.Find(id);
tblUser objSource = (tblUser)Session["UserDetails"];
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (tblUnit == null)
{
return(HttpNotFound());
}
else
{
tblUnit.IsActive = false;
tblUnit.UpdatedBy = objSource.Id;
tblUnit.UpdatedOn = DateTime.Now;
db.Entry(tblUnit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Create(tblInvoice tblInvoice, List <tblInvoiceItem> invItem, string submit)
{
List <tblInvoiceItem> tblItem = new List <tblInvoiceItem>();
tblInvoiceItem objtblInvoiceItem = new tblInvoiceItem();
tblUser objSource = (tblUser)Session["UserDetails"];
if (submit == "Add Row")
{
tblProduct objpro = db.tblProducts.Where(p => p.ProductID == tblInvoice.ProductID).FirstOrDefault();
tblUnit objUnit = db.tblUnits.Where(t => t.UnitID == tblInvoice.UnitID).FirstOrDefault();
tblSize objSize = db.tblSizes.Where(t => t.SizeID == tblInvoice.SizeID).FirstOrDefault();
objtblInvoiceItem.ProductID = tblInvoice.ProductID;
objtblInvoiceItem.ProductName = objpro.ProductName;
objtblInvoiceItem.SizeID = tblInvoice.SizeID;
objtblInvoiceItem.UnitID = tblInvoice.UnitID;
objtblInvoiceItem.TaxID = tblInvoice.TaxID;
objtblInvoiceItem.Tax = tblInvoice.Tax;
objtblInvoiceItem.TaxAmount = tblInvoice.TaxAmount;
objtblInvoiceItem.Quantity = tblInvoice.Quantity;
objtblInvoiceItem.RatePerUnit = tblInvoice.RatePerUnit;
objtblInvoiceItem.IsDeleted = false;
objtblInvoiceItem.UnitName = objUnit.Name;
objtblInvoiceItem.SizeName = objSize.SizeName;
objtblInvoiceItem.HSN_SAC = tblInvoice.HSN_SAC;
objtblInvoiceItem.Discount = tblInvoice.Discount;
objtblInvoiceItem.DiscountAmount = tblInvoice.DiscountAmount;
objtblInvoiceItem.SGST = tblInvoice.SGST;
objtblInvoiceItem.Make = tblInvoice.Make;
if (invItem == null)
{
tblItem.Add(objtblInvoiceItem);
tblInvoice.tblInvoiceItems = tblItem;
}
else
{
invItem.Add(objtblInvoiceItem);
tblInvoice.tblInvoiceItems = invItem;
}
}
if (submit == "Delete Row")
{
ModelState.Clear();
invItem.RemoveAll(a => a.IsDeleted == true);
tblInvoice.tblInvoiceItems = invItem;
}
if (submit == "Save Invoice")
{
GetInvoiceDetails(tblInvoice, invItem, objSource.Id);
}
if (submit == "Print Preview")
{
}
if (submit == "Print")
{
}
//if (ModelState.IsValid)
//{
// db.tblInvoices.Add(tblInvoice);
// db.SaveChanges();
// return RedirectToAction("Index");
//}
ViewBag.PaymentModeID = new SelectList(db.tblPaymentModes, "PaymentModeID", "PaymentMode", tblInvoice.PaymentModeID);
ViewBag.ProductID = new SelectList(db.tblProducts, "ProductID", "ProductName");
ViewBag.SizeID = new SelectList(db.tblSizes.Where(a => a.UnitID == tblInvoice.UnitID), "SizeID", "SizeName", tblInvoice.SizeID);
ViewBag.UnitID = new SelectList(db.tblUnits, "UnitID", "Name", tblInvoice.UnitID);
// ViewBag.CreatedBy = new SelectList(db.tblUsers, "Id", "UserName", tblInvoice.CreatedBy);
// ViewBag.UpdatedBy = new SelectList(db.tblUsers, "Id", "UserName", tblInvoice.UpdatedBy);
return(View(tblInvoice));
}
