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); } }
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); } }