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); }