protected void Add_Cat_in_Asso(int catId, int currentVendorId)
{
String SQL_Insert = "INSERT INTO VendorCatAssociation(VendorId,CategoryId) Values('" + currentVendorId + "','" + catId + "')";
successAdded(access.AddAndDelInDatabase(SQL_Insert));
ClearFields();
}
private void DeleteRepeaterData(string id)
{
string str = "delete from Product where ProductCode=" + id;
if (access.AddAndDelInDatabase(str))
{
string str2 = "delete from PDetails where ProductCode=" + id;
if (access.AddAndDelInDatabase(str2))
{
lblDel.Text = "Record Deleted Successfully";
lblDel.ForeColor = System.Drawing.Color.Green;
Response.Redirect(Request.RawUrl);
BindMyProductsRptr();
}
}
else
{
lblDel.Text = "Unable to delete";
lblDel.ForeColor = System.Drawing.Color.Red;
}
}
private void UpdateProduct()
{
if (Session["vendor"] != null)
{
checkImage();
if (contenttype != String.Empty && currentVendorId != 0 && validateCheckbox())
{
Stream fs = ProductImageFileUpload.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
SqlCommand cmd = new SqlCommand("procUpdateProducts", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VendorId", currentVendorId);
cmd.Parameters.AddWithValue("@ProductPrice", productPrice.Text);
cmd.Parameters.AddWithValue("@ProductName", productName.Text);
cmd.Parameters.AddWithValue("@ProductDetails", productDetails.Text);
cmd.Parameters.AddWithValue("@CategoryId", Convert.ToInt32(productCategory.SelectedItem.Value));
cmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Text);
cmd.Parameters.Add("@ImageContentType", SqlDbType.VarChar).Value = contenttype;
cmd.Parameters.Add("@ImageData", SqlDbType.Binary).Value = bytes;
cmd.Parameters.AddWithValue("@ProductCode", Convert.ToInt64(Request.QueryString["ProductCode"]));
cmd.ExecuteNonQuery();
if (chkSmall.Checked)
{
if (checkingForPUpdate(0))
{
updateDetail(size[0]);
}
else
{
addDetail(Convert.ToInt64(Request.QueryString["ProductCode"]), size[0], 's');
}
}
else
if (checkingForPUpdate(0))
{
access.AddAndDelInDatabase("delete from Product where ProductCode=" + Request.QueryString["ProductCode"].ToString() + " and ProductSize='" + size[0] + "'");
}
if (chkMedium.Checked)
{
if (checkingForPUpdate(1))
{
updateDetail(size[1]);
}
else
{
addDetail(Convert.ToInt64(Request.QueryString["ProductCode"]), size[1], 'm');
}
}
else
if (checkingForPUpdate(1))
{
access.AddAndDelInDatabase("delete from Product where ProductCode=" + Request.QueryString["ProductCode"].ToString() + " and ProductSize='" + size[1] + "'");
}
if (chkLarge.Checked)
{
if (checkingForPUpdate(2))
{
updateDetail(size[2]);
}
else
{
addDetail(Convert.ToInt64(Request.QueryString["ProductCode"]), size[2], 'l');
}
}
else
if (checkingForPUpdate(2))
{
access.AddAndDelInDatabase("delete from Product where ProductCode = " + Request.QueryString["ProductCode"].ToString() + " AND ProductSize = '" + size[2] + "'");
}
// Session["pid"] = null;
Response.Redirect("~/MyProducts.aspx");
}
}
}
}
