public void InsertData(clsTyreChange objtchange)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "INSERT into TyreChange(TyreChangeDate,Kilometers,TyreBrand,TyreSide,Remould)values (@TyreChangeDate,@Kilometers,@TyreBrand,@TyreSide,@Remould)";
cmd.Parameters.AddWithValue("@TyreChangeDate", objtchange.TyreChangeDate);
cmd.Parameters.AddWithValue("@Kilometers", objtchange.Kilometers);
cmd.Parameters.AddWithValue("@TyreBrand", objtchange.TyreBrand);
cmd.Parameters.AddWithValue("@TyreSide", objtchange.TyreSide);
cmd.Parameters.AddWithValue("@Remould", objtchange.Remould);
myDB.Execute(sSQL, cmd);
}
public void UpdateData(clsTyreChange objtchange, string tyrechcode)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "UPDATE TyreChange set TyreChangeDate=@TyreChangeDate,Kilometers=@Kilometers,TyreBrand=@TyreBrand,TyreSide=@TyreSide,Remould=@Remould where TCCode=" + tyrechcode;
cmd.Parameters.AddWithValue("@TyreChangeDate", objtchange.TyreChangeDate);
cmd.Parameters.AddWithValue("@Kilometers", objtchange.Kilometers);
cmd.Parameters.AddWithValue("@TyreBrand", objtchange.TyreBrand);
cmd.Parameters.AddWithValue("@TyreSide", objtchange.TyreSide);
cmd.Parameters.AddWithValue("@Remould", objtchange.Remould);
myDB.Execute(sSQL, cmd);
}
protected void Page_Load(object sender, EventArgs e)
{
objtcchange = new clsTyreChange();
sCOM = new Common();
if (!Page.IsPostBack)
{
sSQL = objtcchange.DispDataAll();
//To Fill Gridview
sCOM.setGridView(GridView1, sSQL);
}
}
protected void Page_Load(object sender, EventArgs e)
{
objtcchange = new clsTyreChange();
sCOM = new Common();
/* uname = (String)Session["uname"];
* if (uname != null)
* {
* txtdname.Text = uname;
* }
* else
* {
* txtdname.Text = "travelagent";
* }*/
if (!Page.IsPostBack)
{
if (Request.QueryString["action"] == "add")
{
txttcdate.Text = DateTime.Now.Date.ToString();
txttccode.Text = sCOM.setAutoID("TyreChange", "TCCode").ToString();
}
else if (Request.QueryString["action"] == "edit")
{
if (Request.QueryString["ec"] != null)
{
string ec = (Request.QueryString["ec"].ToString());
txttccode.Text = ec;
objtcchange = objtcchange.GetData(ec);
/*if (chkStatus.Checked == true)
* {
* objtcchange.Status = "Active";
* }
* else
* {
* objtcchange.Status = "Inactive";
* }*/
txttcdate.Text = objtcchange.TyreChangeDate.ToString();
txtkms.Text = objtcchange.Kilometers.ToString();
txttyrebrand.Text = objtcchange.TyreBrand;
tyside.Text = objtcchange.TyreSide;
}
}
else
{
//Error Page
}
}
}
public clsTyreChange GetData(string tyrechcode)
{
clsTyreChange objtchange;
myDB = new DBHelper();
objtchange = new clsTyreChange();
sSQL = objtchange.DispDataCode(tyrechcode);
SqlDataReader sDr = myDB.GetFromReader(sSQL);
sDr.Read();
if (sDr.HasRows)
{
objtchange.TyreChangeDate = Convert.ToDateTime(sDr["TyreChangeDate"].ToString());
objtchange.Kilometers = Convert.ToDecimal(sDr["Kilometers"].ToString());
objtchange.TyreBrand = sDr["TyreBrand"].ToString();
objtchange.TyreSide = sDr["TyreSide"].ToString();
objtchange.Remould = sDr["Remould"].ToString();
}
return(objtchange);
}
