private void btn_WorkerOn_Click(object sender, EventArgs e)
{
try
{
WorkAssignment_Vo wa = new WorkAssignment_Vo();
wa.User_Name = a;
wa.Wc_Name = cb_Wc_Name.Text;
WorkAllocation_Service service = new WorkAllocation_Service();
service.WorkAssignment(wa);
SetWorkerList();
SetWorker();
a = "";
service.InsertWorkerHistory(wa);
}
catch { }
}
public List <WorkAssignment_Vo> WorkAssignment(WorkAssignment_Vo item)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "WorkAssignment";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Wc_Name", item.Wc_Name);
cmd.Parameters.AddWithValue("@User_Name", item.User_Name);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <WorkAssignment_Vo> list = Helper.DataReaderMapToList <WorkAssignment_Vo>(reader);
cmd.Connection.Close();
return(list);
}
}
public List <WorkAssignment_Vo> InsertWorkerHistory(WorkAssignment_Vo item)
{
WorkAllocation_Dac dac = new WorkAllocation_Dac();
return(dac.InsertWorkerHistory(item));
}
public List <WorkAssignment_Vo> WorkAssignment(WorkAssignment_Vo item)
{
WorkAllocation_Dac dac = new WorkAllocation_Dac();
return(dac.WorkAssignment(item));
}
