public static void getUplate(DS_Uplate.view_UplateDataTable dt_Uplate)
{
dt_Uplate.Clear();
using (SqlConnection cn = Connection.GetOpenConnection())
{
DS_UplateTableAdapters.view_UplateTableAdapter adapter = new DS_UplateTableAdapters.view_UplateTableAdapter();
adapter.Fill(dt_Uplate);
}
}
public static void getUplate_by_NameAndDate(DS_Uplate.view_UplateDataTable dt_Uplate, string fName, string lName, DateTime from, DateTime to)
{
dt_Uplate.Clear();
using (SqlConnection cn = Connection.GetOpenConnection())
{
SqlCommand com = new SqlCommand("usp_Uplate_by_NameAndDate", cn);
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = fName;
com.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = lName;
com.Parameters.Add("@DateFrom", SqlDbType.DateTime).Value = from;
com.Parameters.Add("@DateTo", SqlDbType.DateTime).Value = to;
SqlDataAdapter adapter = new SqlDataAdapter(com);
adapter.Fill(dt_Uplate);
}
}
private void btn_removeCustomList_Click(object sender, EventArgs e)
{
customList.Clear();
lbl_items.Text = "0";
gB_customList.Visible = false;
}