private void BindGrid()
{
AutotDAL objAutoDAL = new AutotDAL();
grdViewAuto.DataSource = objAutoDAL.GetAll();
grdViewAuto.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!Page.IsValid) return;
BLAutot auto = new BLAutot();
auto.rekkari = txtrekkari.Text;
auto.merkki = txtmerkki.Text;
auto.malli = txtmalli.Text;
auto.vm = Convert.ToInt32(txtvm.Text);
auto.myyntiHinta = Convert.ToInt64(txtmyyntiHinta.Text);
auto.sisaanOstoHinta = Convert.ToInt64(txtsisaanOstoHinta.Text);
auto.aid = Convert.ToInt64(hndId.Value);
AutotDAL objAutoDAL = new AutotDAL();
if ((hndId.Value.Trim().Length > 0) &&
(Convert.ToInt64(hndId.Value) > 0))
objAutoDAL.Update(auto);
else
objAutoDAL.Create(auto);
ClearScreen();
BindGrid();
lblMessage.Text = "Record saved successfully";
}
catch (Exception ex)
{
lblMessage.Text = "There is an error occured while processing the request. Please verify the code!";
}
}
protected void grdViewAuto_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
hndId.Value = grdViewAuto.Rows[e.NewSelectedIndex].Cells[2].Text.Trim();
if (hndId.Value.Length > 0)
{
AutotDAL objAutoDAL = new AutotDAL();
BLAutot auto = objAutoDAL.Get(hndId.Value);
txtaid.Text = Convert.ToString(auto.aid);
txtrekkari.Text = auto.rekkari;
txtmerkki.Text = auto.merkki;
txtmalli.Text = auto.malli;
txtvm.Text = Convert.ToString(auto.vm);
txtmyyntiHinta.Text = Convert.ToString(auto.myyntiHinta);
txtsisaanOstoHinta.Text = Convert.ToString(auto.sisaanOstoHinta);
lblMessage.Text = "";
}
}
protected void grdViewAuto_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
string strId = grdViewAuto.Rows[e.RowIndex].Cells[2].Text.Trim();
if (strId.Length > 0)
{
AutotDAL objAutoDAL = new AutotDAL();
objAutoDAL.Delete(strId);
ClearScreen();
BindGrid();
lblMessage.Text = "Record deleted successfully";
}
}
catch (Exception ex)
{
lblMessage.Text = "There is an error occured while processing the request. Please verify the code!";
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!Page.IsValid)
{
return;
}
BLAutot auto = new BLAutot();
auto.rekkari = txtrekkari.Text;
auto.merkki = txtmerkki.Text;
auto.malli = txtmalli.Text;
auto.vm = Convert.ToInt32(txtvm.Text);
auto.myyntiHinta = Convert.ToInt64(txtmyyntiHinta.Text);
auto.sisaanOstoHinta = Convert.ToInt64(txtsisaanOstoHinta.Text);
auto.aid = Convert.ToInt64(hndId.Value);
AutotDAL objAutoDAL = new AutotDAL();
if ((hndId.Value.Trim().Length > 0) &&
(Convert.ToInt64(hndId.Value) > 0))
{
objAutoDAL.Update(auto);
}
else
{
objAutoDAL.Create(auto);
}
ClearScreen();
BindGrid();
lblMessage.Text = "Record saved successfully";
}
catch (Exception ex)
{
lblMessage.Text = "There is an error occured while processing the request. Please verify the code!";
}
}
private void BindGrid()
{
AutotDAL objAutoDAL = new AutotDAL();
grdViewAuto.DataSource = objAutoDAL.GetAll();
grdViewAuto.DataBind();
}
protected void grdViewAuto_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
string strId = grdViewAuto.Rows[e.RowIndex].Cells[2].Text.Trim();
if (strId.Length > 0)
{
AutotDAL objAutoDAL = new AutotDAL();
objAutoDAL.Delete(strId);
ClearScreen();
BindGrid();
lblMessage.Text = "Record deleted successfully";
}
}
catch (Exception ex)
{
lblMessage.Text = "There is an error occured while processing the request. Please verify the code!";
}
}
protected void grdViewAuto_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
hndId.Value = grdViewAuto.Rows[e.NewSelectedIndex].Cells[2].Text.Trim();
if (hndId.Value.Length > 0)
{
AutotDAL objAutoDAL = new AutotDAL();
BLAutot auto = objAutoDAL.Get(hndId.Value);
txtaid.Text = Convert.ToString(auto.aid);
txtrekkari.Text = auto.rekkari;
txtmerkki.Text = auto.merkki;
txtmalli.Text = auto.malli;
txtvm.Text = Convert.ToString(auto.vm);
txtmyyntiHinta.Text = Convert.ToString(auto.myyntiHinta);
txtsisaanOstoHinta.Text = Convert.ToString(auto.sisaanOstoHinta);
lblMessage.Text = "";
}
}