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