public async Task <IActionResult> Edit(int id, [Bind("NoteId,Title,Content,EID")] EmployeeNote employeeNote)
{
if (id != employeeNote.NoteId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(employeeNote);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeNoteExists(employeeNote.NoteId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(employeeNote));
}
public object ValidateSave(bool isPhantom, string obj, JsonObject values)
{
if (!values.ContainsKey("note"))
{
return(new { valid = false, msg = "Salary must be >=1000 for new employee" });
}
PostRequest <EmployeeNote> req = new PostRequest <EmployeeNote>();
EmployeeNote note = JsonConvert.DeserializeObject <List <EmployeeNote> >(obj)[0];
//note.recordId = id;
note.employeeId = CurrentEmployee.Text;
note.note = values["note"].ToString();
int bulk;
req.entity = note;
PostResponse <EmployeeNote> resp = _employeeService.ChildAddOrUpdate <EmployeeNote>(req);
if (!resp.Success)
{
Common.errorMessage(resp);
return(new { valid = false });
}
employeementHistoryStore.Reload();
return(new { valid = true });
}
protected void ADDNewRecord(object sender, DirectEventArgs e)
{
string noteText = e.ExtraParams["noteText"];
X.Call("ClearNoteText");
PostRequest <EmployeeNote> req = new PostRequest <EmployeeNote>();
EmployeeNote note = new EmployeeNote();
//note.recordId = id;
note.employeeId = CurrentEmployee.Text;
note.note = noteText;
note.recordId = "";
note.date = DateTime.Now;
req.entity = note;
PostResponse <EmployeeNote> resp = _employeeService.ChildAddOrUpdate <EmployeeNote>(req);
if (!resp.Success)
{
Common.errorMessage(resp);
}
employeementHistoryStore.Reload();
//Reset all values of the relative object
}
public EmployeeNote Create(EmployeeNote EmployeeNote)
{
if (context.EmployeeNotes.Where(x => x.Identifier != null && x.Identifier == EmployeeNote.Identifier).Count() == 0)
{
EmployeeNote.Id = 0;
EmployeeNote.Active = true;
EmployeeNote.UpdatedAt = DateTime.Now;
EmployeeNote.CreatedAt = DateTime.Now;
context.EmployeeNotes.Add(EmployeeNote);
return(EmployeeNote);
}
else
{
// Load item that will be updated
EmployeeNote dbEntry = context.EmployeeNotes
.FirstOrDefault(x => x.Identifier == EmployeeNote.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.CompanyId = EmployeeNote.CompanyId ?? null;
dbEntry.CreatedById = EmployeeNote.CreatedById ?? null;
// Set properties
dbEntry.Note = EmployeeNote.Note;
dbEntry.NoteDate = EmployeeNote.NoteDate;
dbEntry.ItemStatus = EmployeeNote.ItemStatus;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public static List <EmployeeNoteViewModel> ConvertToEmployeeNoteViewModelList(this IEnumerable <EmployeeNote> EmployeeNotes)
{
List <EmployeeNoteViewModel> EmployeeNoteViewModels = new List <EmployeeNoteViewModel>();
foreach (EmployeeNote EmployeeNote in EmployeeNotes)
{
EmployeeNoteViewModels.Add(EmployeeNote.ConvertToEmployeeNoteViewModel());
}
return(EmployeeNoteViewModels);
}
/// <summary>
/// Creates a new employee note object. Takes a MySqlDataReader object.
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
public EmployeeNote CreateEmployeeNote(MySqlDataReader rdr)
{
EmployeeNote enote = new EmployeeNote()
{
ClockNumber = int.Parse(rdr["clocknumber"].ToString()),
EmployeeName = rdr["empname"].ToString(),
Shift = int.Parse(rdr["shiftpref"].ToString()),
DateRange = rdr["daterange"].ToString(),
IsEligible = Convert.ToBoolean(int.Parse(rdr["eligible"].ToString())),
Note = rdr["note"].ToString()
};
return(enote);
}
public EmployeeNote Delete(Guid identifier)
{
EmployeeNote dbEntry = context.EmployeeNotes
.Union(context.ChangeTracker.Entries()
.Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(EmployeeNote))
.Select(x => x.Entity as EmployeeNote))
.FirstOrDefault(x => x.Identifier == identifier);
if (dbEntry != null)
{
dbEntry.Active = false;
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
public static EmployeeNoteViewModel ConvertToEmployeeNoteViewModelLite(this EmployeeNote EmployeeNote)
{
EmployeeNoteViewModel EmployeeNoteViewModel = new EmployeeNoteViewModel()
{
Id = EmployeeNote.Id,
Identifier = EmployeeNote.Identifier,
Note = EmployeeNote.Note,
NoteDate = EmployeeNote.NoteDate,
ItemStatus = EmployeeNote.ItemStatus,
IsActive = EmployeeNote.Active,
UpdatedAt = EmployeeNote.UpdatedAt,
CreatedAt = EmployeeNote.CreatedAt
};
return(EmployeeNoteViewModel);
}
public async Task <IActionResult> Create([Bind("NoteId,Title,Content,EID")] EmployeeNote employeeNote)
{
ViewData["Employee"] = _context.Employees.OrderBy(c => c.EmpID).ToList()
.Select(n => new SelectListItem
{
Value = n.ToString(),
Text = n.ToString()
}).ToList();
ViewData["EmployeeId"] = _context.Employees.OrderBy(c => c.EmpID).ToList();
ViewData["EmployeeName"] = _context.Employees.OrderBy(c => c.FullName).ToList();
if (ModelState.IsValid)
{
_context.Add(employeeNote);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(employeeNote));
}
public void DeleteEH(string index)
{
try
{
//Step 1 Code to delete the object from the database
EmployeeNote n = new EmployeeNote();
n.recordId = index;
n.note = "";
n.date = DateTime.Now;
n.employeeId = CurrentEmployee.Text;
PostRequest <EmployeeNote> req = new PostRequest <EmployeeNote>();
req.entity = n;
PostResponse <EmployeeNote> res = _employeeService.ChildDelete <EmployeeNote>(req);
if (!res.Success)
{
//Show an error saving...
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.Error, res.Summary).Show();
return;
}
else
{
//Step 2 : remove the object from the store
employeementHistoryStore.Remove(index);
//Step 3 : Showing a notification for the user
Notification.Show(new NotificationConfig
{
Title = Resources.Common.Notification,
Icon = Icon.Information,
Html = Resources.Common.RecordDeletedSucc
});
}
}
catch (Exception ex)
{
//In case of error, showing a message box to the user
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.Error, Resources.Common.ErrorDeletingRecord).Show();
}
}
public static EmployeeNote ConvertToEmployeeNote(this EmployeeNoteViewModel EmployeeNoteViewModel)
{
EmployeeNote EmployeeNote = new EmployeeNote()
{
Id = EmployeeNoteViewModel.Id,
Identifier = EmployeeNoteViewModel.Identifier,
EmployeeId = EmployeeNoteViewModel.Employee?.Id ?? null,
Note = EmployeeNoteViewModel.Note,
NoteDate = EmployeeNoteViewModel.NoteDate,
ItemStatus = EmployeeNoteViewModel.ItemStatus,
Active = EmployeeNoteViewModel.IsActive,
CreatedById = EmployeeNoteViewModel.CreatedBy?.Id ?? null,
CompanyId = EmployeeNoteViewModel.Company?.Id ?? null,
CreatedAt = EmployeeNoteViewModel.CreatedAt,
UpdatedAt = EmployeeNoteViewModel.UpdatedAt
};
return(EmployeeNote);
}
public static EmployeeNoteViewModel ConvertToEmployeeNoteViewModel(this EmployeeNote EmployeeNote)
{
EmployeeNoteViewModel EmployeeNoteViewModel = new EmployeeNoteViewModel()
{
Id = EmployeeNote.Id,
Identifier = EmployeeNote.Identifier,
Employee = EmployeeNote.Employee?.ConvertToEmployeeViewModelLite(),
Note = EmployeeNote.Note,
NoteDate = EmployeeNote.NoteDate,
ItemStatus = EmployeeNote.ItemStatus,
IsActive = EmployeeNote.Active,
CreatedBy = EmployeeNote.CreatedBy?.ConvertToUserViewModelLite(),
Company = EmployeeNote.Company?.ConvertToCompanyViewModelLite(),
UpdatedAt = EmployeeNote.UpdatedAt,
CreatedAt = EmployeeNote.CreatedAt
};
return(EmployeeNoteViewModel);
}
public List <EmployeeNote> GetEmployeeNotes(int companyId)
{
List <EmployeeNote> EmployeeNotes = new List <EmployeeNote>();
string queryString =
"SELECT EmployeeNoteId, EmployeeNoteIdentifier, " +
"EmployeeId, EmployeeIdentifier, EmployeeCode, EmployeeName, " +
"Note, NoteDate, ItemStatus, " +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vEmployeeNotes " +
"WHERE CompanyId = @CompanyId;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;
command.Parameters.Add(new SqlParameter("@CompanyId", companyId));
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
EmployeeNote employeeNote;
while (reader.Read())
{
employeeNote = new EmployeeNote();
employeeNote.Id = Int32.Parse(reader["EmployeeNoteId"].ToString());
employeeNote.Identifier = Guid.Parse(reader["EmployeeNoteIdentifier"].ToString());
if (reader["EmployeeId"] != DBNull.Value)
{
employeeNote.Employee = new Employee();
employeeNote.EmployeeId = Int32.Parse(reader["EmployeeId"].ToString());
employeeNote.Employee.Id = Int32.Parse(reader["EmployeeId"].ToString());
employeeNote.Employee.Identifier = Guid.Parse(reader["EmployeeIdentifier"].ToString());
employeeNote.Employee.Code = reader["EmployeeCode"].ToString();
employeeNote.Employee.Name = reader["EmployeeName"].ToString();
}
if (reader["Note"] != DBNull.Value)
{
employeeNote.Note = reader["Note"].ToString();
}
if (reader["NoteDate"] != DBNull.Value)
{
employeeNote.NoteDate = DateTime.Parse(reader["NoteDate"].ToString());
}
if (reader["ItemStatus"] != DBNull.Value)
{
employeeNote.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString());
}
employeeNote.Active = bool.Parse(reader["Active"].ToString());
employeeNote.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
employeeNote.CreatedBy = new User();
employeeNote.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
employeeNote.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
employeeNote.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
employeeNote.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
employeeNote.Company = new Company();
employeeNote.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
employeeNote.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
employeeNote.Company.Name = reader["CompanyName"].ToString();
}
EmployeeNotes.Add(employeeNote);
}
}
}
return(EmployeeNotes);
//List<EmployeeNote> EmployeeNotes = context.EmployeeNotes
// .Include(x => x.Employee)
// .Include(x => x.Company)
// .Include(x => x.CreatedBy)
// .Where(x => x.Active == true && x.CompanyId == companyId)
// .AsNoTracking()
// .ToList();
//return EmployeeNotes;
}
