private bool Delete(int intPKID)
{
bool retval = false;
objSize = new tblSize();
if (objSize.LoadByPrimaryKey(intPKID))
{
if (!objSize.AppIsDefault)
{
tblSizeSubCategory objSizeSubCategory = new tblSizeSubCategory();
objSizeSubCategory.Where.AppSizeID.Value = intPKID;
objSizeSubCategory.Query.Load();
if (objSizeSubCategory.RowCount > 0)
{
objSizeSubCategory.DeleteAll();
objSizeSubCategory.Save();
}
objSizeSubCategory = null;
objSize.MarkAsDeleted();
objSize.Save();
retval = true;
}
}
objSize = null;
return(retval);
}
public ActionResult DeleteConfirmed(int id)
{
tblSize tblSize = db.tblSizes.Find(id);
db.tblSizes.Remove(tblSize);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private bool SaveData()
{
objCommon = new clsCommon();
if (objCommon.IsRecordExists("tblSize", tblSize.ColumnNames.AppSize, tblSize.ColumnNames.AppSizeID, txtSize.Text, hdnPKID.Value))
{
DInfo.ShowMessage("Size is already exists", Enums.MessageType.Warning);
return(false);
}
objSize = new tblSize();
if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "")
{
objSize.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value));
}
else
{
objSize.AddNew();
}
objSize.s_AppSize = txtSize.Text.Trim();
objSize.AppIsActive = chkIsActive.Checked;
if (chkIsDefault.Checked)
{
tblSize ObjTemp = new tblSize();
ObjTemp.SetDefaultSize();
ObjTemp = null;
objSize.AppIsActive = true;
objSize.AppIsDefault = true;
}
else
{
tblSize ObjTemp = new tblSize();
ObjTemp.LoadAll();
if (ObjTemp.RowCount <= 0)
{
objSize.AppIsActive = true;
objSize.AppIsDefault = true;
}
else
{
objSize.AppIsDefault = false;
}
ObjTemp = null;
}
objSize.Save();
iprojectID = objSize.AppSizeID;
objSize = null;
objClsCommon = null;
return(true);
}
// GET: Sizes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblSize tblSize = db.tblSizes.Find(id);
if (tblSize == null)
{
return(HttpNotFound());
}
return(View(tblSize));
}
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "")
{
objSize = new tblSize();
objDataTable = objSize.LoadGridData(ddlFields.SelectedValue.ToString(), txtSearch.Text.Trim().ToString());
//'Reset PageIndex of gridviews
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
//'Check for data into datatable
if (objDataTable.Rows.Count <= 0)
{
DInfo.ShowMessage("No data found", Enums.MessageType.Information);
return;
}
else
{
if (ddlPerPage.SelectedItem.Text.ToLower() == "all")
{
dgvGridView.AllowPaging = false;
}
else
{
dgvGridView.AllowPaging = true;
dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text);
}
lblCount.Text = objDataTable.Rows.Count.ToString();
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objSize = null;
}
// GET: Sizes/Edit/5
public ActionResult Edit(int?id)
{
ViewBag.UnitID = new SelectList(db.tblUnits, "UnitID", "Name");
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblSize tblSize = db.tblSizes.Find(id);
if (tblSize == null)
{
return(HttpNotFound());
}
ViewBag.Size = tblSize;
var tblSizes = db.tblSizes.Include(t => t.tblUser).Include(t => t.tblUser1).Where(a => a.IsActive == true);
return(View("Index", tblSizes.ToList()));
}
public ActionResult Create([Bind(Include = "SizeID,SizeName,SizeDescription,UnitID,IsActive,CreatedOn,UpdatedOn,CreatedBy,UpdatedBy")] tblSize tblSize)
{
if (ModelState.IsValid)
{
tblUser objSource = (tblUser)Session["UserDetails"];
tblSize.IsActive = true;
tblSize.CreatedOn = DateTime.Now;
tblSize.CreatedBy = objSource.Id;
db.tblSizes.Add(tblSize);
db.SaveChanges();
ViewBag.Size = new tblSize();
return(RedirectToAction("Index"));
}
ViewBag.Size = new tblSize();
var tblSizes = db.tblSizes.Include(t => t.tblUser).Include(t => t.tblUser1).Where(a => a.IsActive == true);
return(View("Index", tblSizes.ToList()));
}
public ActionResult Edit([Bind(Include = "SizeID,SizeName,SizeDescription,UnitID,IsActive,CreatedOn,UpdatedOn,CreatedBy,UpdatedBy")] tblSize tblSize)
{
if (ModelState.IsValid)
{
ViewBag.UnitID = new SelectList(db.tblUnits, "UnitID", "Name");
tblUser objSource = (tblUser)Session["UserDetails"];
tblSize.UpdatedOn = DateTime.Now;
tblSize.UpdatedBy = objSource.Id;
db.Entry(tblSize).State = EntityState.Modified;
ViewBag.Size = new tblSize();
TempData["Success"] = "Size updated successfully.";
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Size = new tblSize();
var tblSizes = db.tblSizes.Include(t => t.tblUser).Include(t => t.tblUser1).Where(a => a.IsActive == true);
return(View("Index", tblSizes.ToList()));
}
private void SetValuesToControls()
{
if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "")
{
objSize = new tblSize();
if (objSize.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)))
{
txtSize.Text = objSize.AppSize;
chkIsActive.Checked = objSize.AppIsActive;
chkIsDefault.Checked = objSize.AppIsDefault;
if (chkIsDefault.Checked)
{
chkIsDefault.Enabled = false;
}
}
objSize = null;
}
}
public string GetSizeId(string strSizeName)
{
string StrSize = "";
tblSize objSize = new tblSize();
objSize.Where.AppSize.Value = strSizeName;
objSize.Query.Load();
if (objSize.RowCount <= 0)
{
objSize.AddNew();
objSize.s_AppSize = strSizeName;
objSize.AppIsActive = true;
objSize.AppIsDefault = false;
objSize.Save();
}
StrSize = objSize.s_AppSizeID;
objSize = null;
return(StrSize);
}
protected void dgvGridView_RowCommand1(object sender, GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
objCommon = new clsCommon();
if (e.CommandName == "IsActive")
{
objSize = new tblSize();
if (objSize.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (!objSize.AppIsDefault)
{
if (objSize.AppIsActive == true)
{
objSize.AppIsActive = false;
}
else if (objSize.AppIsActive == false)
{
objSize.AppIsActive = true;
}
objSize.Save();
LoadDataGrid(false, false);
}
}
objSize = null;
objCommon = null;
}
else if (e.CommandName == "IsDefault")
{
objSize = new tblSize();
objSize.SetDefaultSize(e.CommandArgument.ToString());
objSize = null;
LoadDataGrid(false, false);
}
}
}
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));
}
