public List <CompanyEmployees> GetCompanyEmployees() { using (var conn = new SqlConnection(TimesheetConnectionString)) { conn.Open(); string qry = " select CompanyId, (select CompanyName from Company_Tbl where Company_Tbl.CompanyId = [CompanyEmployees].CompanyId) as 'CompanyName',EmployeeId ," + "(select UserName from AspNetUsers where AspNetUsers.id = [CompanyEmployees].EmployeeId) as 'UserName'" + "from[CompanyEmployees] group by CompanyId,EmployeeId"; using (var cmd = new SqlCommand(qry, conn)) { cmd.CommandType = CommandType.Text; List <CompanyEmployees> data = new List <CompanyEmployees>(); //var myReader = cmd.ExecuteReader(); using (var myReader = cmd.ExecuteReader()) { try { while (myReader.Read()) { var get = new CompanyEmployees(myReader); data.Add(get); } } catch (Exception ex) { // LOG ERROR throw ex; } } return(data); } } }
public bool AddCompanyEmployees([FromBody] CompanyEmployees Model) { try { TimesheetRepositrory _searchRepository = new TimesheetRepositrory(); var Result = _searchRepository.AddCompanyEmployees(Model); return(Result); } catch (Exception ex) { throw; } }
private async void DeleteSelectedEntity() { await DeleteEntityFromFile(); string[] type = SelectedEntity.GetType().ToString().Split('.'); switch (type[type.Length - 1]) { case "Employee": var employeeToRemove = CompanyEmployees.FirstOrDefault(c => c.Id == SelectedEntity.Id); if (employeeToRemove != null) { SelectedCompany.Employees.RemoveAll(e => e.Id == SelectedEntity.Id); CompanyEmployees.Remove(employeeToRemove); } break; case "Todo": var todoToRemove = CompanyTodos.FirstOrDefault(c => c.Id == SelectedEntity.Id); if (todoToRemove != null) { SelectedCompany.Todos.RemoveAll(t => t.Id == SelectedEntity.Id); CompanyTodos.Remove(todoToRemove); } break; case "HistoryPost": var historyToRemove = CompanyHistories.FirstOrDefault(c => c.Id == SelectedEntity.Id); if (historyToRemove != null) { SelectedCompany.Histories.RemoveAll(h => h.Id == SelectedEntity.Id); CompanyHistories.Remove(historyToRemove); } break; } SelectedEntity = null; EntitySelected(null); }
public bool AddCompanyEmployees(CompanyEmployees Model) { using (var conn = new SqlConnection(TimesheetConnectionString)) { conn.Open(); string s = Model.EmployeeId.ToString(); String[] words = s.Split(','); foreach (var a in words) { string qry = "insert into [CompanyEmployees] ([CompanyId] ,[EmployeeId] )values (" + Model.CompanyId + ", '" + a + "')"; using (var cmd = new SqlCommand(qry, conn)) { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } } return(true); } }