public void UpdateData(clsCarService objcarservice, string cscode)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "UPDATE CarService set Username=@Username,ServiceDate=@ServiceDate,Remark=@Remark where CSCode=" + cscode;
cmd.Parameters.AddWithValue("@Username", objcarservice.Username);
cmd.Parameters.AddWithValue("@ServiceDate", objcarservice.ServiceDate);
cmd.Parameters.AddWithValue("@Remark", objcarservice.Remark);
myDB.Execute(sSQL, cmd);
}
public void InsertData(clsCarService objcarservice)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "INSERT into CarService(Username,ServiceDate,Remark)values (@Username,@ServiceDate,@Remark)";
cmd.Parameters.AddWithValue("@Username", objcarservice.Username);
cmd.Parameters.AddWithValue("@ServiceDate", objcarservice.ServiceDate);
cmd.Parameters.AddWithValue("@Remark", objcarservice.Remark);
myDB.Execute(sSQL, cmd);
}
protected void Page_Load(object sender, EventArgs e)
{
objcarservice = new clsCarService();
sCOM = new Common();
if (!Page.IsPostBack)
{
sSQL = objcarservice.DispDataAll();
//To Fill Gridview
sCOM.setGridView(GridView1, sSQL);
}
}
public clsCarService GetData(string cscode)
{
clsCarService objcarservice;
myDB = new DBHelper();
objcarservice = new clsCarService();
sSQL = objcarservice.DispDataCode(cscode);
SqlDataReader sDr = myDB.GetFromReader(sSQL);
sDr.Read();
if (sDr.HasRows)
{
//objcarservice.CSCode = Convert.ToInt32(sDr["CSCode"].ToString());
objcarservice.Username = sDr["UserName"].ToString();
objcarservice.ServiceDate = Convert.ToDateTime(sDr["ServiceDate"].ToString());
objcarservice.Remark = sDr["Remark"].ToString();
}
return(objcarservice);
}
protected void Page_Load(object sender, EventArgs e)
{
objcarservice = new clsCarService();
sCOM = new Common();
uname = (String)Session["uname"];
if (uname != null)
{
txtuname.Text = uname;
}
else
{
txtuname.Text = "travelagent";
}
if (!Page.IsPostBack)
{
if (Request.QueryString["action"] == "add")
{
txtserdate.Text = DateTime.Now.Date.ToString();
txtcscode.Text = sCOM.setAutoID("CarService", "CSCode").ToString();
}
else if (Request.QueryString["action"] == "edit")
{
if (Request.QueryString["ec"] != null)
{
string ec = (Request.QueryString["ec"].ToString());
txtcscode.Text = ec;
objcarservice = objcarservice.GetData(ec);
txtuname.Text = objcarservice.Username;
txtserdate.Text = objcarservice.ServiceDate.ToString();
txtremark.Text = objcarservice.Remark;
}
}
else
{
//Error Page
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
objcarservice = new clsCarService();
try
{
objcarservice.Username = txtuname.Text;
objcarservice.ServiceDate = Convert.ToDateTime(txtserdate.Text);
objcarservice.Remark = txtremark.Text;
if (Request.QueryString["action"] == "add")
{
objcarservice.InsertData(objcarservice);
}
else if (Request.QueryString["action"] == "edit")
{
objcarservice.UpdateData(objcarservice, txtcscode.Text);
}
}
catch (Exception ex)
{
}
}
