-
Notifications
You must be signed in to change notification settings - Fork 0
/
AddBrand.aspx.cs
102 lines (93 loc) · 3.74 KB
/
AddBrand.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class AddBrand : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
BindBrandRepeater();
}
}
private void BindBrandRepeater()
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EasyBuy123"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("select * from tblBrands", con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
rptrBrands.DataSource = dt;
rptrBrands.DataBind();
}
}
}
}
protected void btnAddBrand_Click(object sender, EventArgs e)
{
if(txtBrand.Text!=null && txtBrand.Text!="" && txtBrand.Text!=string.Empty)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EasyBuy123"].ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("Insert into tblBrands(Name) Values('" + txtBrand.Text + "')", con);
cmd.ExecuteNonQuery();
Response.Write("<script> alert('Brand Added Successfully '); </script>");
txtBrand.Text = string.Empty;
con.Close();
//lblMsg.Text = "Registration Successfully done";
//lblMsg.ForeColor = System.Drawing.Color.Green;
txtBrand.Focus();
}
}
}
protected void txtID_TextChanged(object sender, EventArgs e)
{
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EasyBuy123"].ConnectionString);
//if (con.State == ConnectionState.Closed) { con.Open(); }
//SqlCommand cmd = new SqlCommand("select Name from tblBrands where BrandID=@ID",con);
//cmd.Parameters.AddWithValue("@ID",Convert.ToInt32(txtID.Text));
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataSet ds = new DataSet();
//DataTable dt = new DataTable();
//da.Fill(ds, "dt");
//con.Close();
//if (ds.Tables[0].Rows.Count > 0)
//{
// btnUpdateBrand.Enabled = true;
// txtUpdateBrandName.Text = ds.Tables[0].Rows[0]["Name"].ToString();
//}
//else
//{
// btnUpdateBrand.Enabled = false;
// txtUpdateBrandName.Text = string.Empty;
//}
//con.Close();
}
protected void btnUpdateBrand_Click(object sender, EventArgs e)
{
//txtBrand.Text = "0";
//txtBrand.Visible = false;
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EasyBuy123"].ConnectionString);
//if (con.State == ConnectionState.Closed) { con.Open(); }
//SqlCommand cmd = new SqlCommand("insert into tblBrands (BrandID,Name) values(@ID,@Name)", con);
//cmd.Parameters.AddWithValue("@ID", Convert.ToInt32(txtID.Text));
//cmd.Parameters.AddWithValue("@Name", txtUpdateBrandName.Text);
//cmd.ExecuteNonQuery();
//Response.Write("<script>alert('Update successfully')</script>");
//txtID.Text = string.Empty;
//txtUpdateBrandName.Text = string.Empty;
//txtBrand.Text = string.Empty;
//txtBrand.Visible = true;
//txtBrand.Focus();
}
}