public void show_data(int ID)
{
A_Handler = new FineHandler();
A1 = new Fine();
A1 = A_Handler.GetFineDetails(ID);
txtFine_id.Text = A1.Fine_id.ToString();
ddlReg_id.Text = A1.Reg_id.ToString();
txtRec_no.Text = A1.Rec_no.ToString();
txtFine_date.Text = A1.Fine_date.ToString();
ddlMem_id.Text = A1.Mem_id.ToString();
txtFine_amt.Text = A1.Fine_amt.ToString();
txtRec_amt.Text = A1.Rec_amt.ToString();
txtDetail.Text = A1.Detail.ToString();
txtRec_by.Text = A1.Rec_by.ToString();
btnSubmit.Text = "Update";
btnReset.Text = "Cancel";
if (Request.QueryString["action"] == "del")
{
Label1.Text = "Are Sure U want to Delete Record?";
txtFine_id.ReadOnly = false;
ddlReg_id.Enabled = false;
txtRec_no.ReadOnly = false;
txtFine_date.ReadOnly = false;
ddlMem_id.Enabled = false;
txtFine_amt.ReadOnly = false;
txtRec_amt.ReadOnly = false;
txtDetail.ReadOnly = false;
txtRec_by.ReadOnly = false;
btnSubmit.Text = "Delete";
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
fld = cboSearch.SelectedValue.ToString();
txt = txtSearch.Text;
A_Handler = new FineHandler();
sql = "select * from " + Tbl_Name + " where " + fld + " like '" + txt + "%' ";
//Grid1.DataSource = A_Handler.GetFineList(sql);
//Grid1.DataBind();
SqlDataSource1.SelectCommand = sql;
SqlDataSource1.DataBind();
if (Grid1.Rows.Count > 0)
{
lblRec.Text = "Total Records : " + Grid1.Rows.Count.ToString();
}
else
{
lblRec.Text = "Record Not Found...";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
A_Handler = new FineHandler();
A1 = new Fine();
//A1.Fine_id = Convert.ToInt32(txtFine_id.Text);
A1.Reg_id = Convert.ToInt32(ddlReg_id.SelectedValue);
A1.Rec_no = Convert.ToInt32(txtRec_no.Text);
A1.Fine_date = Convert.ToDateTime(txtFine_date.Text);
A1.Mem_id = Convert.ToInt32(ddlMem_id.SelectedValue);
A1.Fine_amt = Convert.ToDecimal(txtFine_amt.Text);
A1.Rec_amt = Convert.ToDecimal(txtRec_amt.Text);
A1.Detail = txtDetail.Text;
A1.Rec_by = Convert.ToInt32(txtRec_by.Text);
if (btnSubmit.Text == "Submit")
{
bool B = A_Handler.AddNewFine(A1);
if (B == true)
{
Label1.Text = "Record Inserted";
MSG = "Record Inserted";
}
else
{
Label1.Text = "Record Not Inserted";
MSG = "Record Not Inserted";
}
}
else if (btnSubmit.Text == "Update")
{
A1.Fine_id = Convert.ToInt32(txtFine_id.Text);
bool B = A_Handler.UpdateFine(A1);
if (B == true)
{
Label1.Text = "Record Updated";
MSG = "Record Not Updated";
}
else
{
Label1.Text = "Record Not Updated";
MSG = "Record Not Updated";
}
}
else if (btnSubmit.Text == "Delete")
{
A1.Fine_id = Convert.ToInt32(txtFine_id.Text);
bool B = A_Handler.DeleteFine(A1);
if (B == true)
{
Label1.Text = "Record Deleted";
MSG = "Record Deleted";
}
else
{
Label1.Text = "Record Not Deleted";
MSG = "Record Not Deleted";
}
}
//Response.Redirect("~/ADMIN/Fine_list.aspx?msg="+MSG);
}
