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