protected void btnsave_Click(object sender, EventArgs e)
{
objcarpuc = new clsCarPUC();
try
{
//objcarpuc.PUCCode = Convert.ToInt32(txtpuccode.Text);
//objcarpuc.CarCode = Convert.ToInt32(txtcarcode.Text);
objcarpuc.CarCode = Convert.ToInt32(DropDownList1.SelectedValue);
objcarpuc.PUCDate = Convert.ToDateTime(txtpucdate.Text);
objcarpuc.PUCNo = txtpucno.Text;
objcarpuc.Validity = Convert.ToInt32(txtvalidity.Text);
objcarpuc.ExpDate = Convert.ToDateTime(txtexpdate.Text);
objcarpuc.AgencyName = txtagencyname.Text;
objcarpuc.UserName = txtuname.Text;
// objcustomer.InsertData(objcustomer);
if (Request.QueryString["action"] == "add")
{
objcarpuc.InsertData(objcarpuc);
}
else if (Request.QueryString["action"] == "edit")
{
objcarpuc.UpdateData(objcarpuc, txtpuccode.Text);
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
objcarpuc = new clsCarPUC();
sCOM = new Common();
if (!Page.IsPostBack)
{
sSQL = objcarpuc.DispDataAll();
//To Fill Gridview
sCOM.setGridView(GridView1, sSQL);
}
}
public void UpdateData(clsCarPUC objcarpuc, string puccode)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "UPDATE CarPUC set CarCode=@CarCode,PUCDate=@PUCDate,PUCNo=@PUCNo,Validity=@Validity,ExpDate=@ExpDate,AgencyName=@AgencyName,UserName=@UserName where PUCCode=" + puccode;
cmd.Parameters.AddWithValue("@CarCode", objcarpuc.CarCode);
cmd.Parameters.AddWithValue("@PUCDate", objcarpuc.PUCDate);
cmd.Parameters.AddWithValue("@PUCNo", objcarpuc.PUCNo);
cmd.Parameters.AddWithValue("@Validity", objcarpuc.Validity);
cmd.Parameters.AddWithValue("@ExpDate", objcarpuc.ExpDate);
cmd.Parameters.AddWithValue("@AgencyName", objcarpuc.AgencyName);
cmd.Parameters.AddWithValue("@UserName", objcarpuc.UserName);
myDB.Execute(sSQL, cmd);
}
public void InsertData(clsCarPUC objcarpuc)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "INSERT into CarPUC(CarCode,PUCDate,PUCNo,Validity,ExpDate,AgencyName,UserName)values (@CarCode,@PUCDate,@PUCNo,@Validity,@ExpDate,@AgencyName,@UserName)";
cmd.Parameters.AddWithValue("@CarCode", objcarpuc.CarCode);
cmd.Parameters.AddWithValue("@PUCDate", objcarpuc.PUCDate);
cmd.Parameters.AddWithValue("@PUCNo", objcarpuc.PUCNo);
cmd.Parameters.AddWithValue("@Validity", objcarpuc.Validity);
cmd.Parameters.AddWithValue("@ExpDate", objcarpuc.ExpDate);
cmd.Parameters.AddWithValue("@AgencyName", objcarpuc.AgencyName);
cmd.Parameters.AddWithValue("@UserName", objcarpuc.UserName);
myDB.Execute(sSQL, cmd);
}
protected void Page_Load(object sender, EventArgs e)
{
objusercar = new clsUserCar();
objcarpuc = new clsCarPUC();
sCOM = new Common();
uname = (String)Session["uname"];
if (uname != null)
{
txtuname.Text = uname;
}
else
{
txtuname.Text = "travelagent";
}
if (!Page.IsPostBack)
{
sSQL = objusercar.DispDataUsername("Apeksha");
//To fill Dropdownlist
sCOM.setDropDownList(DropDownList1, sSQL, "RegNo", "UCcode");
if (Request.QueryString["action"] == "add")
{
txtpuccode.Text = sCOM.setAutoID("CarPUC", "PUCCode").ToString();
}
else if (Request.QueryString["action"] == "edit")
{
if (Request.QueryString["ec"] != null)
{
string ec = (Request.QueryString["ec"].ToString());
objcarpuc = objcarpuc.GetData(ec);
txtpuccode.Text = ec;// objcarpuc.PUCCode.ToString();
// txtcarcode.Text = objcarpuc.CarCode.ToString();
txtuname.Text = objcarpuc.UserName;
txtpucdate.Text = objcarpuc.PUCDate.ToString();
txtpucno.Text = objcarpuc.PUCNo;
txtvalidity.Text = objcarpuc.Validity.ToString();
txtexpdate.Text = objcarpuc.ExpDate.ToString();
txtagencyname.Text = objcarpuc.AgencyName;
}
}
else
{
//Error Page
}
}
}
public clsCarPUC GetData(string puccode)
{
clsCarPUC objcarpuc;
myDB = new DBHelper();
objcarpuc = new clsCarPUC();
sSQL = objcarpuc.DispDataCode(puccode);
SqlDataReader sDr = myDB.GetFromReader(sSQL);
sDr.Read();
if (sDr.HasRows)
{
// objcarpuc.PUCCode = Convert.ToInt32(sDr["PUCCode"].ToString());
objcarpuc.CarCode = Convert.ToInt32(sDr["CarCode"].ToString());
objcarpuc.PUCDate = Convert.ToDateTime(sDr["PUCDate"].ToString());
objcarpuc.PUCNo = sDr["PUCNo"].ToString();
objcarpuc.Validity = Convert.ToInt32(sDr["Validity"].ToString());
objcarpuc.ExpDate = Convert.ToDateTime(sDr["ExpDate"].ToString());
objcarpuc.AgencyName = sDr["AgencyName"].ToString();
objcarpuc.UserName = sDr["UserName"].ToString();
}
return(objcarpuc);
}