private void updatecode() { try { if (hdprodname.Value != "true") { if (hdprodcode.Value != "true") { lblmsgprodname.Text = string.Empty; lblcheckDoubleError.Text = String.Empty; // GridViewRow row = GridView1.SelectedRow; int product_id = Convert.ToInt32(hdproductid.Value); decimal sales_price = decimal.Parse(txtSalesPrice.Text); decimal purchase_price = decimal.Parse(txtPurchasePrice.Text); int cat_id = Int32.Parse(ddlCategory.SelectedValue); int unit_id = Int32.Parse(ddlUnit.SelectedValue); int godown_id = Int32.Parse(ddlGodown.SelectedValue); int rack_id = Int32.Parse(ddlRack.SelectedValue); //int tax_id = Int32.Parse(ddlTax.SelectedValue); //context.sp_UpdateProduct(companyId, branchId, product_id, cat_id, rack_id, godown_id, tax_id, unit_id, orderlevel, purchase_price, sales_price, txtProductCode.Text, txtHSNCode.Text, txtProductName.Text, User_id, DateTime.Today); var product = context.tbl_product.Where(w => w.product_id == product_id).FirstOrDefault(); product.product_name = txtProductName.Text; product.product_code = txtProductCode.Text; product.hsn_code = txtHSNCode.Text; product.purchas_price = decimal.Parse(txtPurchasePrice.Text); product.reorder_level = Convert.ToInt32(txtReorderqty.Text); product.sales_price = decimal.Parse(txtSalesPrice.Text); product.rack_id = rack_id; product.category_id = cat_id; product.godown_id = godown_id; //Delete Existing Mapping and add new mapping for product and tax group //var tbl_productTaxGroup = new tbl_productTaxGroup { product_id = product_id}; //context.tbl_productTaxGroup.Attach(tbl_productTaxGroup); //context.tbl_productTaxGroup.Remove(tbl_productTaxGroup); //context.SaveChanges(); foreach (var grpType in context.tbl_productTaxGroup.Where(w => w.product_id == product_id).ToList()) { product.tbl_productTaxGroup.Remove(grpType); } for (int i = 0; i < ddlTaxgroup.Items.Count; i++) { if (ddlTaxgroup.Items[i].Selected) { tbl_productTaxGroup productTaxGroup = new tbl_productTaxGroup(); ListItem item = ddlTaxgroup.Items[i]; int groupId = int.Parse(ddlTaxgroup.Items[i].Value); productTaxGroup.product_id = product_id; productTaxGroup.group_id = groupId; product.tbl_productTaxGroup.Add(productTaxGroup); } } product.unit_id = unit_id; product.modified_by = User_id; product.modified_date = DateTime.Now; context.SaveChanges(); btnprdUpdate.Visible = false; btnprdSave.Visible = true; divalert.Visible = true; clr(); lblAlert.Text = "Product Updated Successfully "; ((Product)this.Page).loadDataTable(); } else { divalert.Visible = false; lblcheckDoubleError.ForeColor = System.Drawing.Color.Red; lblcheckDoubleError.Text = "This Product Code name already Exists"; } } else { divalert.Visible = false; lblmsgprodname.ForeColor = System.Drawing.Color.Red; lblmsgprodname.Text = "This Product Name already Exists"; } } catch (Exception ex) { ErrorLog.saveerror(ex); //Do Logging } }
private void savedcode() { try { if (hdprodname.Value == "false") { if (hdprodname.Value == "false") { lblmsgprodname.Text = String.Empty; lblcheckDoubleError.Text = String.Empty; tbl_product product = new tbl_product(); product.company_id = companyId; product.branch_id = branchId; product.category_id = Int32.Parse(ddlCategory.SelectedValue); product.unit_id = Int32.Parse(ddlUnit.SelectedValue); product.godown_id = Int32.Parse(ddlGodown.SelectedValue); product.rack_id = Int32.Parse(ddlRack.SelectedValue); //product.tax_id = Int32.Parse(ddlTax.SelectedValue); product.product_name = txtProductName.Text; product.product_code = txtProductCode.Text; product.hsn_code = txtHSNCode.Text; product.reorder_level = Int32.Parse(txtReorderqty.Text); product.purchas_price = decimal.Parse(txtPurchasePrice.Text); product.sales_price = decimal.Parse(txtSalesPrice.Text); product.created_by = User_id; product.created_date = DateTime.Today; product.status = true; product.modified_by = ""; product.modified_date = null; ////Shakeeb ////pd.Insert(pd); //Entity Framework Saving Awais foreach (ListItem item in ddlTaxgroup.Items) { if (item.Selected) { tbl_productTaxGroup productTax = new tbl_productTaxGroup(); productTax.group_id = Convert.ToInt32(item.Value); productTax.isSelected = true; product.tbl_productTaxGroup.Add(productTax); } } context.tbl_product.Add(product); context.SaveChanges(); clr(); divalert.Visible = true; lblAlert.Text = "Product Saved Successfully "; ((Product)this.Page).loadDataTable(); //context.tbl_product.Add(pd); //context.SaveChanges(); } else { divalert.Visible = false; lblcheckDoubleError.ForeColor = System.Drawing.Color.Red; lblcheckDoubleError.Text = "This Product Code name already Exists"; } } else { divalert.Visible = false; lblmsgprodname.ForeColor = System.Drawing.Color.Red; lblmsgprodname.Text = "This Product name already Exists"; } } catch (Exception ex) { ErrorLog.saveerror(ex); //Do Logging } }