internal int InsertUnit(Inv_Unit _unitObj)
{
try
{
_context.Inv_Unit.AddObject(_unitObj);
_context.SaveChanges();
return(_unitObj.UnitId);
}
catch (Exception ex)
{
throw ex;
}
}
internal int InsertUnit(Inv_Unit unitObj)
{
try
{
_context.Inv_Unit.AddObject(unitObj);
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal int UpdateUnit(int unitId, Inv_Unit unitObj)
{
try
{
Inv_Unit untObj = _context.Inv_Unit.First(x => x.UnitId == unitId);
untObj.UnitName = unitObj.UnitName;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Inv_ProductGroup groupObj = new Inv_ProductGroup();
Inv_Product productObj = new Inv_Product();
Inv_Unit _unitObj = new Inv_Unit();
Inv_ProductType _ProductType = new Inv_ProductType();
lblMessage.Text = "";
#region //temGroup
int grpID = 0;
if (chkItemGroup.Checked == true)
{
groupObj.GroupName = txtItemGroup.Text;
groupObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
int Count = (from gplq in _context.Inv_ProductGroup
join pn in _context.Inv_Product on gplq.GroupId equals pn.GroupId
where gplq.GroupName == txtItemGroup.Text
select gplq.GroupId).Count();
if (Count != 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Group Already Exists!')", true);
return;
}
else
{
int result = productBll.InsertGroup(groupObj);
grpID = result;
}
productObj.GroupId = Convert.ToInt32(grpID.ToString());
}
else
{
productObj.GroupId = Convert.ToInt32(ddlGroupName.SelectedValue);
}
#endregion
if (chkItemName.Checked == true)
{
productObj.ProductName = txtProductName.Text;
}
else
{
productObj.ProductName = ddlItemName.SelectedItem.Text;
}
if (chkColorBrand.Checked == true)
{
productObj.Brand = txtBrand.Text;
}
else
{
productObj.Brand = ddlColorBrand.SelectedItem.Text;
}
if (chkStyleSize.Checked == true)
{
productObj.StyleAndSize = txtStyleSize.Text;
}
else
{
productObj.StyleAndSize = ddlStyleSize.SelectedItem.Text;
}
#region Unit
int unID = 0;
if (chkUnit.Checked == true)
{
_unitObj.UnitName = txtUnit.Text;
_unitObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
int Count = (from un in _context.Inv_Unit
join pn in _context.Inv_Product on un.UnitId equals pn.UnitId
where un.UnitName == txtUnit.Text
select un.UnitId).Count();
if (Count != 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Unit Already Exists!')", true);
return;
}
else
{
int result = productBll.InsertUnit(_unitObj);
unID = result;
}
productObj.UnitId = Convert.ToInt32(unID.ToString());
}
else
{
productObj.UnitId = Convert.ToInt32(ddlUnit.SelectedValue);
}
#endregion
#region Product Type
int ptId = 0;
if (chktemType.Checked == true)
{
_ProductType.ProductType = txtItemType.Text;
_ProductType.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString();
_ProductType.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
_ProductType.EditDate = DateTime.Now;
int Count = (from un in _context.Inv_ProductType
join pn in _context.Inv_Product on un.ProductTypeId equals pn.ProductTypeId
where un.ProductType == txtItemType.Text
select un.ProductTypeId).Count();
if (Count != 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Type Already Exists!')", true);
return;
}
else
{
int result = productBll.InsertProductType(_ProductType);
ptId = result;
}
productObj.ProductTypeId = Convert.ToInt32(ptId.ToString());
}
else
{
productObj.ProductTypeId = Convert.ToInt32(ddlItemType.SelectedValue);
}
#endregion
productObj.ReOrderQty = Convert.ToDouble(txtReorder.Text);
//productObj.ProductType = ddlAssetType.SelectedItem.Text.Trim();
if (btnSubmit.Text == "Submit")
{
int Productcount = (from prod in _context.Inv_Product
where prod.ProductName == productObj.ProductName && prod.Brand == productObj.Brand && prod.StyleAndSize == productObj.StyleAndSize
select prod.ProductId).Count();
if (Productcount != 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Name Already Exists!')", true);
return;
}
if (Productcount == 0)
{
productObj.EditDate = DateTime.Now;
productObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
productObj.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString();
int result = productBll.InsertProduct(productObj);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saving Failure')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exist')", true);
txtProductName.Text = "";
txtProductName.Focus();
}
}
else
{
int productId = Convert.ToInt16(hdfProductID.Value);
int result = productBll.UpdateProduct(productObj, productId);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updating failure')", true);
}
}
GetProductInfo();
GetAllGroup();
ClearAllControl();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Inv_Unit unitObj = new Inv_Unit();
unitObj.UnitName = txtUnitName.Text;
int Unitcount = (from unt in _context.Inv_Unit
where unt.UnitName == unitObj.UnitName
select unt.UnitId).Count();
if (Unitcount == 0)
{
if (btnSubmit.Text == "Submit")
{
//unitObj.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
unitObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
int result = unitBll.InsertUnit(unitObj);
if (result == 1)
{
// lblMessage.Text = "Data Saved Successfully";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true);
}
else
{
//lblMessage.Text = "Data Saving Failure";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saving Failure')", true);
}
}
else
{
int unitId = Convert.ToInt32(hdfUnitID.Value);
int result = unitBll.UpdateUnit(unitObj, unitId);
if (result == 1)
{
// lblMessage.Text = "Data Updated Sucessfully";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Sucessfully')", true);
}
else
{
// lblMessage.Text = "Data Updating failure";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updating failure')", true);
}
}
GetAllUnit();
txtUnitName.Text = "";
txtUnitName.Focus();
btnSubmit.Text = "Submit";
}
else
{
//lblMessage.Text = "Data Already Exist";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exist')", true);
txtUnitName.Text = "";
txtUnitName.Focus();
btnSubmit.Text = "Submit";
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateUnit(Inv_Unit unitObj, int unitId)
{
return(unitDal.UpdateUnit(unitId, unitObj));
}
internal int InsertUnit(Inv_Unit unitObj)
{
return(unitDal.InsertUnit(unitObj));
}
internal int InsertUnit(Inv_Unit _unitObj)
{
return(productDal.InsertUnit(_unitObj));
}
