//Below as the Class methods for some DB operations.
//We will revisit these section in our next practical
public Email_orderDP getOrder(int dvr_id)
{
Email_orderDP orderDetail = null;
string email, dvr_name, contact_no, password;
string queryStr = "Select * FROM driver_info WHERE dvr_id = @dvr_id";
SqlConnection conn = new SqlConnection(_connstr);
SqlCommand cmd = new SqlCommand(queryStr, conn);
cmd.Parameters.AddWithValue("@dvr_id", dvr_id);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
//sheck if there are any resultsets
if (dr.Read())
{
email = dr["email"].ToString();
dvr_name = dr["dvr_name"].ToString();
contact_no = dr["contact_no"].ToString();
password = dr["password"].ToString();
orderDetail = new Email_orderDP(dvr_id, email, dvr_name, contact_no, password);
}
else
{
orderDetail = null;
}
conn.Close();
dr.Close();
dr.Dispose();
return(orderDetail);
}
public List <Email_orderDP> getOrderAll()
{
List <Email_orderDP> orderList = new List <Email_orderDP>();
int dvr_id;
string email, dvr_name, contact_no, password;
string queryStr = "SELECT * FROM driver_info Order By dvr_id";
SqlConnection conn = new SqlConnection(_connstr);
SqlCommand cmd = new SqlCommand(queryStr, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
//Continue to read the resultsets row by row if not the end
while (dr.Read())
{
dvr_id = Convert.ToInt32(dr["dvr_id"].ToString());
email = dr["email"].ToString();
dvr_name = dr["dvr_name"].ToString();
contact_no = dr["contact_no"].ToString();
password = dr["password"].ToString();
Email_orderDP a = new Email_orderDP(dvr_id, email, dvr_name, contact_no, password);
orderList.Add(a);
}
conn.Close();
dr.Close();
dr.Dispose();
return(orderList);
}
protected void btn_update_Click(object sender, EventArgs e)
{
int result = 0;
Email_orderDP dvr = new Email_orderDP();
result = dvr.DriverUpdate(Convert.ToInt32(lbl_dvr_id.Text), tb_dvr_name.Text, tb_email.Text, tb_password.Text);
if (result > 0)
{
Response.Write("<script>alert('Driver updated successfully');</script>");
}
else
{
Response.Write("<script>alert('Driver NOT updated');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["cust_id"] == null && Session["emp_id"] == null && Session["dvr_id"] == null && Session["admin_id"] == null)
{
Response.Redirect("Login.aspx");
}
if (!Page.IsPostBack)
{
int dvr_id = Convert.ToInt32(Session["dvr_id"].ToString());//Request.QueryString["dvr_id"];
Email_orderDP dvr = new Email_orderDP();
Email_orderDP data = dvr.getOrder(dvr_id);
lbl_dvr_id.Text = data.dvr_id.ToString();
tb_dvr_name.Text = data.dvr_name.ToString();
tb_email.Text = data.email.ToString();
tb_password.Text = data.password.ToString();
tb_contact_no.Text = data.contact_no.ToString();
}
}
