public List<tbCUSTOMERS> tbCUSTOMERS_GetById(string Id)
{
List<Data.tbCUSTOMERS> list = new List<Data.tbCUSTOMERS>();
using (SqlCommand dbCmd = new SqlCommand("sp_tbCUSTOMERS_GetById", GetConnection()))
{
Data.tbCUSTOMERS obj = new Data.tbCUSTOMERS();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@iusid", Id));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.tbCUSTOMERSIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
public List<Data.tbCUSTOMERS> Get_Customer_Order_By_lang()
{
List<Data.tbCUSTOMERS> list = new List<Data.tbCUSTOMERS>();
using (SqlCommand dbCmd = new SqlCommand("sp_tbCUSTOMERS_Paging", GetConnection()))
{
Data.tbCUSTOMERS obj = new Data.tbCUSTOMERS();
dbCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.tbCUSTOMERSIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
public tbCUSTOMERS tbCUSTOMERSIDataReader(IDataReader dr)
{
Data.tbCUSTOMERS obj = new Data.tbCUSTOMERS();
obj.iusid = (dr["iusid"] is DBNull) ? string.Empty : dr["iusid"].ToString();
protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Data.tbCUSTOMERS obj = new Data.tbCUSTOMERS();
obj.iusid = Id;
obj.vusername = "******" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString();
obj.vpassword = txtvpassword.Text;
obj.vcusname = txtvcusname.Text;
obj.dbirthday = txtdbirthday.Text;
obj.vprovince = txtvprovince.Text;
obj.vaddress = txtvaddress.Text;
obj.vphone = txtvmobile.Text;
obj.vmobile = txtvmobile.Text;
obj.vemail = txtvemail.Text;
obj.dcreatedate = DateTime.Now.ToShortDateString();
obj.istatus = "0";
if (Insert == true)
{
tbCUSTOMERSService.tbCUSTOMERS_Insert(obj);
}
else
{
tbCUSTOMERSService.tbCUSTOMERS_Update(obj);
}
BindGrid();
pnView.Visible = true;
pnUpdate.Visible = false;
Insert = false;
}
}
