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