01.protected void bttsell_Click(object sender, EventArgs e)
02. {
03.
04. using (SqlConnection con = new SqlConnection(sportsecondhandConnectionString))
05. {
06. con.Open();
07.
08.
09.
10. int imagelen = FileUpload1.PostedFile.ContentLength;
11. byte[] picbyte = new byte[imagelen];
12. FileUpload1.PostedFile.InputStream.Read(picbyte, 0, (imagelen));
13.
14. using (SqlTransaction transaction = con.BeginTransaction())
15. {
16.
17. if (Page.IsValid)
18. {
19.
20. try
21. {
22.
23. string sql = "INSERT INTO CustomerUser(Username,Userphone,UserIdentification) VALUES(@Username,@Userphone,@UserIdentification)";
24. SqlParameter[] prms = new SqlParameter[3];
25. prms[0] = new SqlParameter("@Username", SqlDbType.VarChar, 50);
26. prms[0].Value = txtnamesell.Text.Trim();
27. prms[1] = new SqlParameter("@Userphone", SqlDbType.VarChar, 50);
28. prms[1].Value = txtphonenumber.Text.Trim();
29. prms[2] = new SqlParameter("@UserIdentification", SqlDbType.VarChar, 50);
30. prms[2].Value = txtidcard.Text.Trim();
31.
32.
33. using (SqlCommand cmd = new SqlCommand(sql, con))
34. {
35. cmd.Transaction = transaction;
36. cmd.Parameters.AddRange(prms);
37. cmd.ExecuteNonQuery();
38.
39. }
40.
41.
42.
43. sql = "INSERT INTO ProductSecondHand(Productname,Productprice,Productdetail,Productpic,Useremail,Productdate,Producteditdate,Ipaddress,browserversion,Producttype,UserIdentification) VALUES(@Productname,@Productprice,@Productdetail,@Productpic,@Useremail,@Productdate,@Producteditdate,@Ipaddress,@browserversion,@Producttype,@UserIdentification)";
44. SqlParameter[] prms1 = new SqlParameter[11];
45. prms1[0] = new SqlParameter("@Productname", SqlDbType.VarChar, 50);
46. prms1[0].Value = txtnameproduct.Text.Trim();
47. prms1[1] = new SqlParameter("@Productprice", SqlDbType.Money);
48. prms1[1].Value = txtpriceproduct.Text.Trim();
49. prms1[2] = new SqlParameter("@Productdetail", SqlDbType.VarChar, 255);
50. prms1[2].Value = txtdetail.Text.Trim();
51. prms1[3] = new SqlParameter("@Productpic", SqlDbType.Image);
52. prms1[3].Value = picbyte;
53. prms1[4] = new SqlParameter("@Productdate", SqlDbType.DateTime);
54. prms1[4].Value = txtdatetime.Text.Trim();
55. prms1[5] = new SqlParameter("@Producteditdate", SqlDbType.DateTime);
56. prms1[5].Value = txtupdatedate.Text.Trim();
57. prms1[6] = new SqlParameter("@Ipaddress", SqlDbType.VarChar, 50);
58. prms1[6].Value = txtipaddress.Text.Trim();
59. prms1[7] = new SqlParameter("@browserversion", SqlDbType.VarChar, 50);
60. prms1[7].Value = txtbrowser.Text.Trim();
61. prms1[8] = new SqlParameter("@Producttype", SqlDbType.VarChar, 50);
62. prms1[8].Value = ddltypeproduct.Text.Trim();
63. prms1[9] = new SqlParameter("@Useremail", SqlDbType.VarChar, 50);
64. prms1[9].Value = txtemail.Text.Trim();
65. prms1[10] = new SqlParameter("@UserIdentification", SqlDbType.VarChar, 50);
66. prms1[10].Value = txtidcard.Text.Trim();
67.
68. using (SqlCommand cmd1 = new SqlCommand(sql, con))
69. {
70. cmd1.Transaction = transaction;
71. cmd1.Parameters.AddRange(prms1);
72. cmd1.ExecuteNonQuery();
73.
74. }
75.
76. transaction.Commit();
77. con.Close();
78.
79. Result1.Text = "Save Successfully";
80.
81.
82. }
83.
84.
85.
86. catch (Exception ee)
87. {
88. transaction.Rollback();
89. Result1.Text = "Save error" + ee.ToString();
90.
91. }
Load balance : Server 04
