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 frm_reportUplate(DS_Uplate.view_UplateDataTable dt_uplate, string fName, string lName, string from, string to, string kurs)
{
this.dt_uplate = dt_uplate;
this.fName = fName;
this.lName = lName;
this.from = from;
this.to = to;
this.kurs = kurs;
InitializeComponent();
}
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_newCustomList_Click(object sender, EventArgs e)
{
customList = new DS_Uplate.view_UplateDataTable();
gB_customList.Visible = true;
}
