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