public void updcatg()
{
SqlParameter[] array = new SqlParameter[2];
array[0] = new SqlParameter("@intcategoryid", p_intcatgid);
array[1] = new SqlParameter("@strcategoryname", p_strcategoryname);
AppLib.ExecuteNonQueryBySP("Proc_updcat", array);
}
public void addcatl()
{
SqlParameter[] array = new SqlParameter[2];
array[0] = new SqlParameter("@intcatalogid", p_intcatlid);
array[1] = new SqlParameter("@strcatalogname", p_strcatalogname);
AppLib.ExecuteNonQueryBySP("Proc_inscatl", array);
}
public void updadv()
{
SqlParameter[] array = new SqlParameter[2];
array[0] = new SqlParameter("@strproductname", p_strproductname);
array[1] = new SqlParameter("@strlocation", p_strlocation);
AppLib.ExecuteNonQueryBySP("Proc_updadv", array);
}
public Int32 fgtpwd()
{
SqlParameter[] array = new SqlParameter[1];
array[0] = new SqlParameter("@usname", p_strusername);
AppLib.ExecuteNonQueryBySP("Proc_forgotpwd", array);
SqlParameter p1 = new SqlParameter("@ret", SqlDbType.Int);
p1.Direction = ParameterDirection.ReturnValue;
return(Convert.ToInt32(p1.Value));
}
public void addadv()
{
SqlParameter[] array = new SqlParameter[5];
array[0] = new SqlParameter("@intadvid", p_intadvid);
array[1] = new SqlParameter("@strcategoryname", p_strcategoryname);
array[2] = new SqlParameter("@strproductname", p_strproductname);
array[3] = new SqlParameter("@strimage", p_strimage);
array[4] = new SqlParameter("@strlocation", p_strlocation);
AppLib.ExecuteNonQueryBySP("Proc_insadv", array);
}
public void funcomment()
{
SqlParameter[] array = new SqlParameter[8];
array[0] = new SqlParameter("@strcommentdesc", p_strcommentdesc);
array[1] = new SqlParameter("@posteddate", p_posteddate);
array[2] = new SqlParameter("@intprodid", p_intprodid);
array[3] = new SqlParameter("@strname", p_strfirstname);
array[4] = new SqlParameter("@strprodimage", p_strprodimg);
array[5] = new SqlParameter("@strprodname", p_strprodname);
array[6] = new SqlParameter("@intuserid", p_intuserid);
array[7] = new SqlParameter("@strusername", p_strusername);
AppLib.ExecuteNonQueryBySP("Proc_instbcomment", array);
}
public void funtbproduct()
{
SqlParameter[] array = new SqlParameter[8];
array[0] = new SqlParameter("@intprodid", p_intprodid);
array[1] = new SqlParameter("@strprodname", p_strprodname);
array[2] = new SqlParameter("@strproddesc", p_strproddesc);
array[3] = new SqlParameter("@intprodprice", p_intprodprc);
array[4] = new SqlParameter("@intuserid", p_intuserid);
array[5] = new SqlParameter("@intcategoryid", p_intcategoryid);
array[6] = new SqlParameter("@intcatalogid", p_intcatalogid);
array[7] = new SqlParameter("@strprodimage", p_strprodimg);
AppLib.ExecuteNonQueryBySP("Proc_insprod", array);
}
public void upduser()
{
SqlParameter[] arr = new SqlParameter[13];
// arr[0] = new SqlParameter("@intuserid", p_intuserid);
arr[0] = new SqlParameter("@strfirstname", p_strfirstname);
arr[1] = new SqlParameter("@strlastname", p_strlastname);
/// arr[] = new SqlParameter("@introleid", p_introleid);
/// arr[4] = new SqlParameter("@dtdob", p_dtdob);
arr[2] = new SqlParameter("@strcontactemail", p_strcontactemail);
arr[3] = new SqlParameter("@strpermaddr", p_strpermaddr);
arr[4] = new SqlParameter("@strcorresaddr", p_strcorresaddr);
arr[5] = new SqlParameter("@strcity", p_strcity);
arr[6] = new SqlParameter("@strstate", p_strstate);
arr[7] = new SqlParameter("@strcountry", p_strcountry);
arr[8] = new SqlParameter("@intpincode", p_intpincode);
arr[9] = new SqlParameter("@strcontactnumber", p_strcontactnumber);
arr[10] = new SqlParameter("@strfaxnumber", p_strfaxnumber);
// arr[15] = new SqlParameter("@strpassword", p_strpassword);
arr[11] = new SqlParameter("@strcompanyname", p_strcompanyname);
arr[12] = new SqlParameter("@strusername", p_strusername);
AppLib.ExecuteNonQueryBySP("Proc_updateuser", arr);
}
public void deleteproduct(int prodid)
{
SqlParameter[] array = new SqlParameter[1];
array[0] = new SqlParameter("@prodid", prodid);
AppLib.ExecuteNonQueryBySP("Proc_delproduct", array);
}
