internal int InsertGroup(Inv_ProductGroup groupObj)
{
try
{
_context.Inv_ProductGroup.AddObject(groupObj);
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal Inv_ProductGroup GetConstructionId(string constructionName)
{
try
{
Inv_ProductGroup construction = (from p in _Context.Inv_ProductGroup
where p.GroupName == constructionName
select p).FirstOrDefault();
return(construction);
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
internal int UpdateGroup(int groupId, Inv_ProductGroup groupObj)
{
try
{
Inv_ProductGroup grpObj = _context.Inv_ProductGroup.First(x => x.GroupId == groupId);
grpObj.GroupName = groupObj.GroupName;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
protected void constructionSearchTextBox_TextChanged(object sender, EventArgs e)
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
Guid createUser = ((SessionUser)Session["SessionUser"]).UserId;
string constructionName = constructionSearchTextBox.Text;
Inv_ProductGroup aInv_ProductGroup = new Inv_ProductGroup();
aInv_ProductGroup = aYarnCountDeterminationBLL.GetConstructionId(constructionName);
int constructionId = aInv_ProductGroup.GroupId;
List <YarnDeterminationShowRepo> aYarnDeterminationShowRepo = aYarnCountDeterminationBLL.GetAllInformationOfGridViewByConstruction(OCODE, constructionId, createUser);
YarnDeterminationGridView.DataSource = aYarnDeterminationShowRepo;
YarnDeterminationGridView.DataBind();
}
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);
}
}
internal int UpdateGroup(Inv_ProductGroup groupObj, int groupId)
{
return(groupDal.UpdateGroup(groupId, groupObj));
}
internal int InsertGroup(Inv_ProductGroup groupObj)
{
return(groupDal.InsertGroup(groupObj));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Inv_ProductGroup groupObj = new Inv_ProductGroup();
groupObj.GroupName = txtGroupName.Text;
//if (groupBll.GetGroupByName(groupObj.GroupName) != null)
//{
// lblMessage.Text = "Data Already in the List";
// lblMessage.ForeColor = System.Drawing.Color.Red;
// txtGroupName.Text = "";
// return;
//}
int Groupcount = (from grp in _context.Inv_ProductGroup
where grp.GroupName == groupObj.GroupName
select grp.GroupId).Count();
if (Groupcount == 0)
{
if (btnSubmit.Text == "Submit")
{
//groupObj.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
groupObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
int result = groupBll.InsertGroup(groupObj);
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 groupId = Convert.ToInt32(hdfProductGroupID.Value);
int result = groupBll.UpdateGroup(groupObj, groupId);
if (result == 1)
{
// lblMessage.Text = "Data Updated Successfully";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", 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);
}
}
GetAllProductGroup();
txtGroupName.Text = "";
txtGroupName.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);
txtGroupName.Text = "";
txtGroupName.Focus();
btnSubmit.Text = "Submit";
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
