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