protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_Product inv_Product = new Inv_Product();
inv_Product = Inv_ProductManager.GetInv_ProductByID(Int32.Parse(Request.QueryString["inv_ProductID"]));
Inv_Product tempInv_Product = new Inv_Product();
tempInv_Product.Inv_ProductID = inv_Product.Inv_ProductID;
tempInv_Product.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_Product.ProductCode = Int32.Parse(txtProductCode.Text);
tempInv_Product.AvgCosting = Decimal.Parse(txtAvgCosting.Text);
tempInv_Product.SalePrice = Decimal.Parse(txtSalePrice.Text);
tempInv_Product.ExtraField2 = txtExtraField2.Text;
tempInv_Product.ExtraField3 = txtExtraField3.Text;
tempInv_Product.ExtraField4 = txtExtraField4.Text;
tempInv_Product.ExtraField5 = txtExtraField5.Text;
tempInv_Product.AddedBy = getLogin().LoginID;
tempInv_Product.AddedDate = DateTime.Now;
tempInv_Product.UpdatedBy = getLogin().LoginID;
tempInv_Product.UpdatedDate = DateTime.Now;
tempInv_Product.RowStatusID = 1;
bool result = Inv_ProductManager.UpdateInv_Product(tempInv_Product);
Response.Redirect("AdminInv_ProductDisplay.aspx");
}
internal Inv_Product GetProductByProductID(int ProductID)
{
Inv_Product _invProduct = _Context.Inv_Product
.Where(po => po.ProductId == ProductID).FirstOrDefault();
return(_invProduct);
}
public bool UpdateInv_Product(Inv_Product inv_Product)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Product", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_ProductID", SqlDbType.Int).Value = inv_Product.Inv_ProductID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = inv_Product.ProductID;
cmd.Parameters.Add("@ProductCode", SqlDbType.Int).Value = inv_Product.ProductCode;
cmd.Parameters.Add("@AvgCosting", SqlDbType.Decimal).Value = inv_Product.AvgCosting;
cmd.Parameters.Add("@SalePrice", SqlDbType.Decimal).Value = inv_Product.SalePrice;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Product.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Product.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Product.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Product.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Product.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Product.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Product.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Product.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Product.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Inv_Product GetInv_ProductFromReader(IDataReader reader)
{
try
{
Inv_Product inv_Product = new Inv_Product
(
(int)reader["Inv_ProductID"],
(int)reader["ProductID"],
(int)reader["ProductCode"],
(decimal)reader["AvgCosting"],
(decimal)reader["SalePrice"],
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
return(inv_Product);
}
catch (Exception ex)
{
return(null);
}
}
// GET: /Product/search/5
public ActionResult Search(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Inv_Product inv_product = db.Inv_Product.Find(id);
if (inv_product == null)
{
return(HttpNotFound());
}
var list = JsonConvert.SerializeObject(inv_product,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(Content(list, "application/json"));
return(Json(inv_product, JsonRequestBehavior.AllowGet));
string json = JsonConvert.SerializeObject(inv_product);
return(Json(json));
return(Json(new { foo = "bar", baz = "Blech" }));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Inv_Product invProduct = new Inv_Product();
int ProductId = Convert.ToInt16(ddlProductName.SelectedValue);
int GroupId = Convert.ToInt16(ddlGroupName.SelectedValue);
invProduct.Price = Convert.ToDecimal(txtPrice.Text);
int result = groupBll.UpdatePrice(invProduct, ProductId, GroupId);
if (result == 1)
{
// lblMessage.Text = "Data Update successfully";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Sucessfully')", true);
reset();
LoadGrid();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
public static Inv_Product GetInv_ProductByID(int id)
{
Inv_Product inv_Product = new Inv_Product();
SqlInv_ProductProvider sqlInv_ProductProvider = new SqlInv_ProductProvider();
inv_Product = sqlInv_ProductProvider.GetInv_ProductByID(id);
return(inv_Product);
}
public ActionResult DeleteConfirmed(int id)
{
Inv_Product inv_product = db.Inv_Product.Find(id);
db.Inv_Product.Remove(inv_product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Inv_ProductId,Inv_ProductTypeId,ProductName,ProductCode,ProductDetails,BuyPrice,SellPrice,Tax,Note,CreatedDate,UpdateDate,IsActive,IsDeleted,CompanyId,UserId")] Inv_Product inv_product)
{
if (ModelState.IsValid)
{
db.Entry(inv_product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Inv_ProductTypeId = new SelectList(db.Inv_ProductType, "Inv_ProductTypeId", "ProductTypeName", inv_product.Inv_ProductTypeId);
return(View(inv_product));
}
public Inv_Product GetAllItem(int pdoductId, string description)
{
try
{
Inv_Product buyCentrl = _context.Inv_Product.Where(bc => bc.ProductId == pdoductId && bc.StyleAndSize == description).FirstOrDefault <Inv_Product>();
return(buyCentrl);
}
catch (Exception ex)
{
throw ex;
}
}
internal int InsertProduct(Inv_Product productObj)
{
try
{
_context.Inv_Product.AddObject(productObj);
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal int UpdatePrice(Inv_Product invProduct, int ProductId, int GroupId)
{
try
{
Inv_Product attObj = _context.Inv_Product.First(x => x.ProductId == ProductId && x.GroupId == GroupId);
attObj.Price = invProduct.Price;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
// GET: /Product/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Inv_Product inv_product = db.Inv_Product.Find(id);
if (inv_product == null)
{
return(HttpNotFound());
}
return(View(inv_product));
}
// GET: /Product/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Inv_Product inv_product = db.Inv_Product.Find(id);
if (inv_product == null)
{
return(HttpNotFound());
}
ViewBag.Inv_ProductTypeId = new SelectList(db.Inv_ProductType, "Inv_ProductTypeId", "ProductTypeName", inv_product.Inv_ProductTypeId);
return(View(inv_product));
}
private void showInv_ProductData()
{
Inv_Product inv_Product = new Inv_Product();
inv_Product = Inv_ProductManager.GetInv_ProductByID(Int32.Parse(Request.QueryString["inv_ProductID"]));
ddlProduct.SelectedValue = inv_Product.ProductID.ToString();
txtProductCode.Text = inv_Product.ProductCode.ToString();
txtAvgCosting.Text = inv_Product.AvgCosting.ToString();
txtSalePrice.Text = inv_Product.SalePrice.ToString();
txtExtraField2.Text = inv_Product.ExtraField2;
txtExtraField3.Text = inv_Product.ExtraField3;
txtExtraField4.Text = inv_Product.ExtraField4;
txtExtraField5.Text = inv_Product.ExtraField5;
txtAddedBy.Text = inv_Product.AddedBy.ToString();
txtUpdatedBy.Text = inv_Product.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_Product.UpdatedDate;
ddlRowStatus.SelectedValue = inv_Product.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_Product inv_Product = new Inv_Product();
inv_Product.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_Product.ProductCode = Int32.Parse(txtProductCode.Text);
inv_Product.AvgCosting = Decimal.Parse(txtAvgCosting.Text);
inv_Product.SalePrice = Decimal.Parse(txtSalePrice.Text);
inv_Product.ExtraField2 = txtExtraField2.Text;
inv_Product.ExtraField3 = txtExtraField3.Text;
inv_Product.ExtraField4 = txtExtraField4.Text;
inv_Product.ExtraField5 = txtExtraField5.Text;
inv_Product.AddedBy =getLogin().LoginID;
inv_Product.AddedDate = DateTime.Now;
inv_Product.UpdatedBy = getLogin().LoginID;
inv_Product.UpdatedDate = DateTime.Now;
inv_Product.RowStatusID = 1;
int resutl = Inv_ProductManager.InsertInv_Product(inv_Product);
Response.Redirect("AdminInv_ProductDisplay.aspx");
}
internal int UpdateProduct(int productId, Inv_Product productObj)
{
try
{
Inv_Product prodObj = _context.Inv_Product.First(x => x.ProductId == productId);
prodObj.ProductName = productObj.ProductName;
prodObj.Brand = productObj.Brand;
prodObj.StyleAndSize = productObj.StyleAndSize;
prodObj.GroupId = productObj.GroupId;
prodObj.UnitId = productObj.UnitId;
prodObj.ProductType = productObj.ProductType;
prodObj.ReOrderQty = productObj.ReOrderQty;
prodObj.UnitName = productObj.UnitName;
prodObj.ProjectCode = productObj.ProjectCode;
prodObj.StoreID = productObj.StoreID;
prodObj.StoreUnitID = productObj.StoreUnitID;
prodObj.ProductTypeId = productObj.ProductTypeId;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
//using (ERPSSL_INVEntities ctx = new ERPSSL_INVEntities())
//{
// try
// {
// ctx.Set<T>().Attach(obj);
// ctx.Entry(obj).State = System.Data.Entity.EntityState.Modified;
// ctx.SaveChanges();
// return 1;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_Product inv_Product = new Inv_Product();
inv_Product.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_Product.ProductCode = Int32.Parse(txtProductCode.Text);
inv_Product.AvgCosting = Decimal.Parse(txtAvgCosting.Text);
inv_Product.SalePrice = Decimal.Parse(txtSalePrice.Text);
inv_Product.ExtraField2 = txtExtraField2.Text;
inv_Product.ExtraField3 = txtExtraField3.Text;
inv_Product.ExtraField4 = txtExtraField4.Text;
inv_Product.ExtraField5 = txtExtraField5.Text;
inv_Product.AddedBy = getLogin().LoginID;
inv_Product.AddedDate = DateTime.Now;
inv_Product.UpdatedBy = getLogin().LoginID;
inv_Product.UpdatedDate = DateTime.Now;
inv_Product.RowStatusID = 1;
int resutl = Inv_ProductManager.InsertInv_Product(inv_Product);
Response.Redirect("AdminInv_ProductDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_Product inv_Product = new Inv_Product();
inv_Product = Inv_ProductManager.GetInv_ProductByID(Int32.Parse(Request.QueryString["inv_ProductID"]));
Inv_Product tempInv_Product = new Inv_Product();
tempInv_Product.Inv_ProductID = inv_Product.Inv_ProductID;
tempInv_Product.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_Product.ProductCode = Int32.Parse(txtProductCode.Text);
tempInv_Product.AvgCosting = Decimal.Parse(txtAvgCosting.Text);
tempInv_Product.SalePrice = Decimal.Parse(txtSalePrice.Text);
tempInv_Product.ExtraField2 = txtExtraField2.Text;
tempInv_Product.ExtraField3 = txtExtraField3.Text;
tempInv_Product.ExtraField4 = txtExtraField4.Text;
tempInv_Product.ExtraField5 = txtExtraField5.Text;
tempInv_Product.AddedBy =getLogin().LoginID;
tempInv_Product.AddedDate = DateTime.Now;
tempInv_Product.UpdatedBy = getLogin().LoginID;
tempInv_Product.UpdatedDate = DateTime.Now;
tempInv_Product.RowStatusID = 1;
bool result = Inv_ProductManager.UpdateInv_Product(tempInv_Product);
Response.Redirect("AdminInv_ProductDisplay.aspx");
}
internal int InsertProduct(Inv_Product productObj)
{
return(productDal.InsertProduct(productObj));
}
internal int UpdateProduct(Inv_Product productObj, int productId)
{
return(productDal.UpdateProduct(productId, productObj));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
lblMessage.Text = "";
Inv_Product productObj = new Inv_Product();
productObj.ProductName = txtProductName.Text;
productObj.StyleAndSize = txtStyleSize.Text;
productObj.ReOrderQty = Convert.ToInt32(txtReorder.Text);
productObj.Brand = "HB";
productObj.GroupId = Convert.ToInt32(ddlGroupName.SelectedValue);
productObj.UnitId = Convert.ToInt32(ddlUnit.SelectedValue);
productObj.UnitName = ddlUnit.SelectedItem.Text;
//productObj.ProductType = ddlAssetType.SelectedItem.Text.Trim();
productObj.ProductType = "Consumable Product";
//productObj.ProjectCode = ddlProject.SelectedValue;
//productObj.StoreID = Convert.ToInt32(ddlStoreName.SelectedValue);
//productObj.StoreUnitID = Convert.ToInt32(ddlStoreUnit.SelectedValue);
int Productcount = (from prod in _context.Inv_Product
where prod.ProductName == productObj.ProductName && prod.GroupId == productObj.GroupId && prod.Brand == productObj.Brand
select prod.ProductId).Count();
if (btnSubmit.Text == "Submit")
{
if (Productcount == 0)
{
productObj.EditDate = DateTime.Now;
//productObj.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
productObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
productObj.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString();
//productObj.OCode = "8989";
int result = productBll.InsertProduct(productObj);
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
{
//lblMessage.Text = "Data Already Exist";
//lblMessage.ForeColor = System.Drawing.Color.Red;
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)
{
// 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);
}
}
GetProductInfo();
ClearAllControl();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
private void showInv_ProductData()
{
Inv_Product inv_Product = new Inv_Product();
inv_Product = Inv_ProductManager.GetInv_ProductByID(Int32.Parse(Request.QueryString["inv_ProductID"]));
ddlProduct.SelectedValue = inv_Product.ProductID.ToString();
txtProductCode.Text = inv_Product.ProductCode.ToString();
txtAvgCosting.Text = inv_Product.AvgCosting.ToString();
txtSalePrice.Text = inv_Product.SalePrice.ToString();
txtExtraField2.Text = inv_Product.ExtraField2;
txtExtraField3.Text = inv_Product.ExtraField3;
txtExtraField4.Text = inv_Product.ExtraField4;
txtExtraField5.Text = inv_Product.ExtraField5;
txtAddedBy.Text = inv_Product.AddedBy.ToString();
txtUpdatedBy.Text = inv_Product.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_Product.UpdatedDate;
ddlRowStatus.SelectedValue = inv_Product.RowStatusID.ToString();
}
public bool UpdateInv_Product(Inv_Product inv_Product)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_Product", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_ProductID", SqlDbType.Int).Value = inv_Product.Inv_ProductID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = inv_Product.ProductID;
cmd.Parameters.Add("@ProductCode", SqlDbType.Int).Value = inv_Product.ProductCode;
cmd.Parameters.Add("@AvgCosting", SqlDbType.Decimal).Value = inv_Product.AvgCosting;
cmd.Parameters.Add("@SalePrice", SqlDbType.Decimal).Value = inv_Product.SalePrice;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Product.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Product.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Product.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Product.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Product.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Product.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Product.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Product.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Product.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public Inv_Product GetInv_ProductFromReader(IDataReader reader)
{
try
{
Inv_Product inv_Product = new Inv_Product
(
(int)reader["Inv_ProductID"],
(int)reader["ProductID"],
(int)reader["ProductCode"],
(decimal)reader["AvgCosting"],
(decimal)reader["SalePrice"],
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
return inv_Product;
}
catch(Exception ex)
{
return null;
}
}
internal int UpdatePrice(Inv_Product invProduct, int ProductId, int GroupId)
{
return(groupDal.UpdatePrice(invProduct, ProductId, GroupId));
}
public static bool UpdateInv_Product(Inv_Product inv_Product)
{
SqlInv_ProductProvider sqlInv_ProductProvider = new SqlInv_ProductProvider();
return(sqlInv_ProductProvider.UpdateInv_Product(inv_Product));
}
public static int InsertInv_Product(Inv_Product inv_Product)
{
SqlInv_ProductProvider sqlInv_ProductProvider = new SqlInv_ProductProvider();
return(sqlInv_ProductProvider.InsertInv_Product(inv_Product));
}
public Inv_Product GetAllItem(int pdoductId, string description)
{
Inv_Product product = productDal.GetAllItem(pdoductId, description);
return(product);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
BindRequisitionNo();
string BarCode = ddlProduct.SelectedValue;
string Quantity = txtQuantity.Text;
string ReqDate = txtDate.Text;
if (BarCode == "" || Quantity == "" || ReqDate == "" || ddlDepartment.SelectedValue == "0" || ddlEmployee.SelectedValue == "0" || txtRequisitionNo.Text == "")
{
return;
}
if (int.Parse(txtQuantity.Text) <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition quantity cannot be zero or negative!')", true);
//lblMessage.Text = "<font color='red'>Sorry! Invalid data. Requisition quantity cannot be zero or negative. Please enter correct data</font>";
return;
}
Inv_Product product = productBll.GetAllItem(int.Parse(ddlProduct.SelectedValue), txtDescription.Text);
if (BtnSave.Text == "Add")
{
if (product == null)
{
Inv_Product productObj = new Inv_Product();
string pronductNameandBrand = ddlProduct.SelectedItem.ToString();
string[] values = pronductNameandBrand.Split('-');
productObj.ProductName = values[0].ToString();
productObj.StyleAndSize = txtDescription.Text;
productObj.ReOrderQty = 0;
productObj.Brand = "HB";
productObj.GroupId = Convert.ToInt32(ddlProductGroup.SelectedValue);
productObj.GroupName = ddlProductGroup.SelectedItem.Text;
productObj.UnitId = int.Parse(ddlUnit.SelectedValue);
productObj.UnitName = ddlUnit.SelectedItem.Text;
productObj.ProductType = "Consumable Product";
productObj.EditDate = DateTime.Now;
//productObj.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce");
productObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
productObj.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString();
//productObj.OCode = "8989";
productBll.InsertProduct(productObj);
//PRQ_Requisitions requisition = new PRQ_Requisitions();
//requisition.ReqNo = txtRequisitionNo.Text;
//requisition.ReqType = "Purchase";
////requisition.CompanyCode = "";
//requisition.DPT_CODE = ddlDepartment.SelectedValue;
//requisition.EID = ddlEmployee.SelectedValue;
//requisition.Qty = int.Parse(txtQuantity.Text);
//requisition.ReqDate = DateTime.Parse(txtDate.Text);
//requisition.DesiredRcvDate = DateTime.Parse(txtExpectedDate.Text);
//requisition.OCode = ((SessionUser)Session["SessionUser"]).OCode;
//requisition.RecomendBy = txtRecommendedBy.Text;
//requisition.Reason_Justification = txtJustification.Text;
//requisition.Remarks = txtRemarks.Text;
//aRequisionBll.AddPurchaseRequisition_ForNewItem(values[0].ToString(), txtDescription.Text);
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
//ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("Remarks", txtRemarks.Text);
if (RequisionBll.AddPurchaseRequisition_ForNewItem(ht, values[0].ToString(), txtDescription.Text))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item added successfully')", true);
//lblMessage.Text = "<font color='green'>Requisition for this item added successfully!</font>";
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
else
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("BarCode", ddlProduct.SelectedValue);
ht.Add("Qty", txtQuantity.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("Remarks", txtRemarks.Text);
if (RequisionBll.AddPurchaseRequisition(ht))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item added successfully')", true);
//lblMessage.Text = "<font color='green'>Requisition for this item added successfully!</font>";
LoadRequisitions(txtRequisitionNo.Text);
ClearForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
}
else if (BtnSave.Text == "Update")
{
DataTable dt = new DataTable();
string ReqNo = txtRequisitionNo.Text;
string Barocde = ddlProduct.SelectedValue;
dt = RequisionBll.GetBarCode(ReqNo, Barocde);
if (dt.Rows.Count > 0)
{
Hashtable ht = new Hashtable();
ht.Add("ReqNo", txtRequisitionNo.Text);
ht.Add("ReqType", "Purchase");
ht.Add("CompanyCode", "");
ht.Add("DPT_CODE", ddlDepartment.SelectedValue);
ht.Add("EID", ddlEmployee.SelectedValue);
ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode);
ht.Add("RecomendBy", "n/a");
ht.Add("Reason_Justification", txtJustification.Text);
ht.Add("ReqDate", txtDate.Text);
ht.Add("DesiredRcvDate", txtExpectedDate.Text);
ht.Add("Remarks", txtRemarks.Text);
ht.Add("Qty", txtQuantity.Text);
ht.Add("BarCode", ddlProduct.SelectedValue);
if (RequisionBll.updatePurchaseRequisitions(ht) == false)
{
ClearForm();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Requisition for this item updated successfully')", true);
LoadRequisitions(txtRequisitionNo.Text);
BtnSave.Text = "Add";
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Error in adding requisition!')", true);
//lblMessage.Text = "<font color='red'>Error in adding requisition! Please try again</font>";
}
}
}
}
catch { }
}
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);
}
}
