public void Add_Punch_Fine(Punch_Fine_Info info)
{
con.Open();
SqlCommand cmd = new SqlCommand("Add_Punch_Fine", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@punch_fine_date", SqlDbType.DateTime);
p.Value = info.Punch_Fine_Date;
p = cmd.Parameters.Add("@punched_time", SqlDbType.DateTime);
p.Value = info.Punched_Time;
p = cmd.Parameters.Add("@brt_id", SqlDbType.Int);
p.Value = info.Brt_Id;
p = cmd.Parameters.Add("@punch_name", SqlDbType.VarChar);
p.Value = info.Punch_name;
p = cmd.Parameters.Add("@bus_no", SqlDbType.VarChar);
p.Value = info.Bus_no;
p = cmd.Parameters.Add("@fine_amount", SqlDbType.Float);
p.Value = info.Fine_Amount;
p = cmd.Parameters.Add("@late_by", SqlDbType.VarChar);
p.Value = info.Late_By;
cmd.ExecuteNonQuery();
con.Close();
}
public object View_Punch_Fine(int punch_fine_id)
{
con.Open();
SqlCommand cmd = new SqlCommand("View_Punch_Fine", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@punch_fine_tab_id", SqlDbType.Int);
p.Value = punch_fine_id;
SqlDataReader read = cmd.ExecuteReader();
Punch_Fine_Info p_info = new Punch_Fine_Info();
if (read.Read())
{
p_info.Late_By = read["late_by"].ToString();
p_info.Punch_Fine_Date = DateTime.Parse(read["punch_fine_date"].ToString());
p_info.Punch_Fine_Tab_Id = int.Parse(read["punch_fine_tab_id"].ToString());
p_info.Punch_name = read["punch_name"].ToString();
p_info.Punched_Time = DateTime.Parse(read["punched_time"].ToString());
p_info.Fine_Amount = int.Parse(read["fine_amount"].ToString());
p_info.Brt_Id = int.Parse(read["brt_id"].ToString());
p_info.Bus_no = read["bus_no"].ToString();
}
read.Close();
con.Close();
return(p_info);
}
protected void btnyes_Click(object sender, EventArgs e)
{
Punch_Fine_Info inf = new Punch_Fine_Info();
Punch_Fine_Sp sp = new Punch_Fine_Sp();
sp.Delete_Punch_Fine();
//Label4.Visible = true;
MultiView1.SetActiveView(View1);
}
protected void Button1_Click(object sender, EventArgs e)
{
Punch_Fine_Info info = new Punch_Fine_Info();
Punch_Fine_Sp sp = new Punch_Fine_Sp();
info.Punch_Fine_Date = DateTime.Parse(lbdate.Text);
info.Brt_Id = int.Parse(GridView1.SelectedValue.ToString());
info.Punch_name = Session["username"].ToString();
info.Punched_Time = DateTime.Parse(lbarrtime.Text);
info.Late_By = Label1.Text;
info.Fine_Amount = float.Parse(txtfine.Text);
info.Bus_no = lbbus_no.Text;
info.Late_By = Label1.Text;
sp.Add_Punch_Fine(info);
//for (int j = 0; j <= arr.Count; j++)
//{
//if(arr[j][2]==info.Brt_Id)
//{
// int index = arr.IndexOf(arr[j][2]);
// arr.RemoveAt(index);
//}
//}
int index = 0;
foreach (add_trip_info inf in arr)
{
if (inf.Brt_id == info.Brt_Id)
{
break;
}
index++;
}
arr.RemoveAt(index);
GridView1.DataSource = arr;
GridView1.DataBind();
MultiView1.SetActiveView(View1);
}
