public int AddEditActivity(AngularActivity selectedActivity)
{
int newId = 0;
string success = "ono";
try
{
using (var db = new curtisGodaddyEntities())
{
JobSearchActivity dbJobSearchActivity = null;
if (selectedActivity.ActivityId == 0)
{
dbJobSearchActivity = new JobSearchActivity { };
dbJobSearchActivity.JobListingId = selectedActivity.JobListingId;
db.JobSearchActivities.Add(dbJobSearchActivity);
}
else
{
dbJobSearchActivity = db.JobSearchActivities.Where(j => j.JobSearchActivityId == selectedActivity.ActivityId).First();
}
dbJobSearchActivity.Comments = selectedActivity.Comments;
dbJobSearchActivity.ActivityDate = DateTime.Parse(selectedActivity.ActivityDate);
dbJobSearchActivity.ActivityStatus = selectedActivity.ActivityStatus;
db.SaveChanges();
newId = dbJobSearchActivity.JobSearchActivityId;
success = "ok";
}
}
catch (DbEntityValidationException ex)
{
success = "ValidationExceptions: ";
foreach (var eve in ex.EntityValidationErrors)
{
success += eve.Entry.Entity.GetType().Name + ": " + eve.Entry.State;
foreach (var ve in eve.ValidationErrors)
{
success += " Property: " + ve.PropertyName + " Error: " + ve.ErrorMessage;
}
}
}
catch (Exception ex)
{
success = ex.Message;
if (ex.InnerException != null)
success += " inner: " + ex.InnerException.Message;
}
return newId;
}
public JobActivityModel GetJobSearchActivities(int selectedJobListingId)
{
JobActivityModel jobActivityModel = new JobActivityModel();
using (var db = new curtisGodaddyEntities())
{
var activitites = db.JobSearchActivities.Where(jl => jl.JobListingId == selectedJobListingId).ToList();
foreach (JobSearchActivity ja in activitites)
{
var item = new AngularActivity()
{
JobListingId = selectedJobListingId,
ActivityId = ja.JobSearchActivityId,
ActivityDate = ja.ActivityDate.ToShortDateString(),
ActivityStatus = ja.ActivityStatus.Value,
Comments = ja.Comments
};
jobActivityModel.Activitites.Add(item);
}
jobActivityModel.ActivityTypes = GetRefs(1);
return jobActivityModel;
}
}