protected void btnSave_Click(object sender, EventArgs e) { busProducts busProd = new busProducts(); FrameWork.Products frmProd = new FrameWork.Products(); frmProd.ProductName = this.txtProdName.Text; frmProd.ProductCode = this.txtCode.Text; frmProd.Description = this.txtProdDescription.Text; frmProd.CategoryID = int.Parse(this.drpCategory.SelectedValue); frmProd.ProductSizeID = int.Parse(this.drpSize.SelectedValue); frmProd.UnitOfMeasureID = int.Parse(this.drpUOM.SelectedValue); isExisting = isUserExisting(); if (isExisting.Equals(true)) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Product already Exists')", true); } else { busProd.insertProducts(frmProd); } DataTable dt = new DataTable("User"); dt = busProd.allProducts(); GridView1.DataSource = dt; GridView1.DataBind(); }
protected void BtnOk_Click(object sender, EventArgs e) { busProducts busProd = new busProducts(); FrameWork.Products frmProd = new FrameWork.Products(); frmProd.ProductName = this.txtProdName.Text; frmProd.ProductCode = this.txtCode.Text; frmProd.Description = this.txtProdDescription.Text; frmProd.CategoryID = int.Parse(this.drpCategory.SelectedValue); frmProd.ProductSizeID = int.Parse(this.drpSize.SelectedValue); frmProd.UnitOfMeasureID = int.Parse(this.drpUOM.SelectedValue); isExisting = isUserExisting(); if (isExisting.Equals(true)) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Product already Exists')", true); } else { string x = busProd.insertProducts(frmProd); if (x.Trim() == string.Empty) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully added new Product')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Failed to added new Product')", true); } } DataTable dt = new DataTable("User"); dt = busProd.allProducts(); GridView1.DataSource = dt; GridView1.DataBind(); }
public FrameWork.Products isUserExisting(string ProdName) { DataTable dt = new DataTable("Category"); dt.Clear(); string query = "SELECT * FROM Products where ProductName='" + ProdName + "'"; dt = DataAccess.DBAdapter.GetRecordSet(query); Products log = null; if (dt.Rows.Count > 0) { log = new Products(dt.Rows[0]); } return log; }
private bool isUserExisting() { string userid = this.txtProdName.Text; busProducts busprod = new busProducts(); FrameWork.Products frmprod = new FrameWork.Products(); frmprod = busprod.isUserExisting(userid); //FrameWork.Employees log = busemp.isUserExisting(userid); if (frmprod == null) { return(false); } else if (userid.Equals(frmprod.ProductName)) { return(true); } else { return(false); } }
public string insertProducts(FrameWork.Products prods) { string Message = string.Empty; int result = 0; con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [Products]([ProductName],[ProductCode],[Description] ,[UnitOfMeasureID] ,[CategoryID] ,[ProductSizeID],[Discontinued]) VALUES (@ProductName,@ProductCode,@Description ,@UnitOfMeasureID ,@CategoryID ,@ProductSizeID,@Discontinued)", con); cmd.Parameters.AddWithValue("@ProductName", prods.ProductName); cmd.Parameters.AddWithValue("@ProductCode", prods.ProductCode); cmd.Parameters.AddWithValue("@Description", prods.Description); cmd.Parameters.AddWithValue("@UnitOfMeasureID", prods.UnitOfMeasureID); cmd.Parameters.AddWithValue("@CategoryID", prods.CategoryID); cmd.Parameters.AddWithValue("@ProductSizeID", prods.ProductSizeID); cmd.Parameters.AddWithValue("@Discontinued", 1); result = cmd.ExecuteNonQuery(); con.Close(); return(Message); }
private bool isUserExisting() { string userid = this.txtProdName.Text; busProducts busprod = new busProducts(); FrameWork.Products frmprod = new FrameWork.Products(); frmprod = busprod.isUserExisting(userid); //FrameWork.Employees log = busemp.isUserExisting(userid); if (frmprod == null) { return false; } else if (userid.Equals(frmprod.ProductName)) { return true; } else { return false; } }