public int AddTraining(TrainingDtl newEntry)
{
try
{
db.TrainingDtls.Add(newEntry);
db.SaveChanges();
return(1);
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"",
ve.PropertyName,
eve.Entry.CurrentValues.GetValue <object>(ve.PropertyName),
ve.ErrorMessage);
}
}
throw;
}
}
//Save to Trainer Table
public void addTrainingDtls(TrainingDtl trainingDtl)
{
try
{
var newTraining = new TrainingDtl()
{
startDate = trainingDtl.startDate,
endDate = trainingDtl.endDate,
timeSlot = trainingDtl.timeSlot,
accept = trainingDtl.accept,
userId = trainingDtl.userId,
userName = trainingDtl.userName,
mentorId = trainingDtl.mentorId,
skillId = trainingDtl.skillId,
skillname = trainingDtl.skillname,
rejected = trainingDtl.rejected,
mentorName = trainingDtl.mentorName,
};
data.TrainingDtls.Add(newTraining);
data.SaveChanges();
}
catch
{
throw;
}
}
public int UpdateTraining(int id, TrainingDtl training)
{
TrainingDtl emp = db.TrainingDtls.Find(id);
if (emp != null)
{
try
{
emp.mentorId = training.mentorId;
emp.startDate = training.startDate;
emp.endDate = training.endDate;
emp.timeSlot = training.timeSlot;
emp.userId = training.userId;
emp.userName = training.userName;
emp.progress = training.progress;
emp.status = training.status;
emp.mentorId = training.mentorId;
emp.mentorName = training.mentorName;
emp.skillId = training.skillId;
emp.skillname = training.skillname;
emp.fees = training.fees;
emp.requested = training.requested;
emp.rejectNotify = training.rejectNotify;
emp.paymentStatus = training.paymentStatus;
db.SaveChanges();
}
catch
{
throw;
}
}
return(1);
}
public IHttpActionResult saveTraining(TrainingDtl trainingDtl)
{
TrainingDtl result;
result = ctrl.saveTraining(trainingDtl);
return(Ok(result));
}
public TrainingDtl saveTraining(TrainingDtl trainingDtl)
{
try
{
TrainingDtl result;
result = db.TrainingDtls.Add(trainingDtl);
db.SaveChanges();
return(result);
}
catch
{
throw;
}
}
public void rejectTrainingRequestById(int id)
{
try
{
TrainingDtl trainingDtl = db.TrainingDtls.Find(id);
trainingDtl.rejectNotify = true;
db.Configuration.ValidateOnSaveEnabled = false;
db.Entry(trainingDtl).State = System.Data.Entity.EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = true;
db.SaveChanges();
}
catch
{
throw;
}
}
public void acceptTrainingRequestById(int id)
{
try
{
TrainingDtl trainingDtl = samrat.TrainingDtls.Find(id);
trainingDtl.accept = true;
samrat.Configuration.ValidateOnSaveEnabled = false;
samrat.Entry(trainingDtl).State = System.Data.Entity.EntityState.Modified;
samrat.Configuration.ValidateOnSaveEnabled = true;
samrat.SaveChanges();
}
catch
{
throw;
}
}
public void updateTrainingRatingById(int id, int rating)
{
try
{
TrainingDtl user = db.TrainingDtls.Find(id);
user.rating = rating;
db.Configuration.ValidateOnSaveEnabled = false;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = true;
db.SaveChanges();
}
catch
{
throw;
}
}
public void updateTrainingAndPaymentStatusById(int id)
{
try
{
TrainingDtl user = samrat.TrainingDtls.Find(id);
user.trainingPaymentStatus = true;
samrat.Configuration.ValidateOnSaveEnabled = false;
samrat.Entry(user).State = System.Data.Entity.EntityState.Modified;
samrat.Configuration.ValidateOnSaveEnabled = true;
samrat.SaveChanges();
}
catch
{
throw;
}
}
//Update Training Progress
public void UpdateProg(TrainingDtl updateData)
{
try
{
TrainingDtl prog = data.TrainingDtls.Find(updateData.id);
prog.progress = updateData.progress;
data.Entry(prog).State = EntityState.Modified;
data.Configuration.ValidateOnSaveEnabled = false;
data.SaveChanges();
data.Configuration.ValidateOnSaveEnabled = true;
}
catch
{
throw;
}
}
//update Payment Status
public void PayUpdate(int id)
{
try
{
TrainingDtl payStatus = data.TrainingDtls.Find(id);
payStatus.PaymentStatus = true;
data.Entry(payStatus).State = EntityState.Modified;
data.Configuration.ValidateOnSaveEnabled = false;
data.SaveChanges();
data.Configuration.ValidateOnSaveEnabled = true;
}
catch
{
throw;
}
}
public void updateTrainingStatusById(int id)
{
try
{
TrainingDtl user = db.TrainingDtls.Find(id);
user.status = "current";
user.progress = 0;
db.Configuration.ValidateOnSaveEnabled = false;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = true;
db.SaveChanges();
}
catch
{
throw;
}
}
public void Declined(int id)
{
try
{
TrainingDtl user = data.TrainingDtls.Find(id);
user.accept = false;
user.rejected = true;
data.Entry(user).State = EntityState.Modified;
data.Configuration.ValidateOnSaveEnabled = false;
data.SaveChanges();
data.Configuration.ValidateOnSaveEnabled = true;
}
catch
{
throw;
}
}
public void updateTrainingProgressById(int id, int progressValue)
{
try
{
TrainingDtl user = db.TrainingDtls.Find(id);
user.progress = progressValue;
if (progressValue == 100)
{
user.status = "completed";
}
db.Configuration.ValidateOnSaveEnabled = false;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = true;
db.SaveChanges();
}
catch
{
throw;
}
}
public int AddTraining1(TrainingDtl details)
{
return(userlogic.AddTraining(details));
}
public IHttpActionResult Progress(TrainingDtl proData)
{
userLogic.UpdateProg(proData);
return(Ok("Progress Updated"));
}
public IHttpActionResult TrainingData(TrainingDtl trainingDtl)
{
userLogic.addTrainingDtls(trainingDtl);
return(Ok("Sent"));
}
public int AddTraining(TrainingDtl Dtl)
{
return(userlogic.NewTraining(Dtl));
}
public int Edit(int id, TrainingDtl training)
{
return(userlogic.UpdateTraining(id, training));
}
public TrainingDtl GetTrainingDetails(int id)
{
TrainingDtl details = db.TrainingDtls.Find(id);
return(details);
}
public int NewTraining(TrainingDtl sd)
{
md.TrainingDtls.Add(sd);
md.SaveChanges();
return(1);
}
