public static EmpTraining ConvertRespondentInfoFromDTO(EmpTrainingDTO Record)
{
EmpTraining ReturnRecord = new EmpTraining
{
Id = Record.Id,
EmpCode = Record.EmpCode,
Designation = Record.Designation,
Rank = Record.Rank,
Office = Record.Office,
TrainingTitle = Record.TrainingTitle,
TrainingFocus = Record.TrainingFocus,
TrainingStartDate = Convert.ToDateTime(Record.TrainingStartDate),
TrainingEndDate = Convert.ToDateTime(Record.TrainingEndDate),
TrainingVisitStartDate = Convert.ToDateTime(Record.TrainingVisitStartDate),
TrainingVisitEndDate = Convert.ToDateTime(Record.TrainingVisitEndDate),
TrainingOrganization = Record.TrainingOrganization,
NationalInternational = Record.NationalInternational,
LetterDate = Record.LetterDate,
TrainingCountry = Record.TrainingCountry,
TrainingVenue = Record.TrainingVenue,
Sponsorship = Record.Sponsorship,
SponsorerOrganizationName = Record.SponsorerOrganizationName,
Approver = Record.Approver,
};
return(ReturnRecord);
}
public int CreateEmployeeTraining(EmpTrainingDTO Record)
{
Record.Id = 0;
EmpTraining Domain = EmpTrainingRequestFormatter.ConvertRespondentInfoFromDTO(Record);
using (TransactionScope Scope = new TransactionScope())
{
//for (DateTime Today = Convert.ToDateTime(Record.TrainingVisitStartDate).Date; Today.Date <= Convert.ToDateTime(Record.TrainingVisitEndDate).Date; Today = Today.AddDays(1))
//{
// AttendaceDaily DailyRecord = _unitOfWork.AttendanceDailyRepository.Get(x => x.AttDate == Today && x.AttEmpCode == Record.EmpCode).FirstOrDefault();
// if(DailyRecord != null)
// {
// DailyRecord.IsTraining = true;
// _unitOfWork.AttendanceDailyRepository.Update(DailyRecord);
// }else
// {
// DailyRecord = new AttendaceDaily();
// DailyRecord.AttEmpCode = Record.EmpCode;
// DailyRecord.AttDate = Today;
// DailyRecord.IsTraining = true;
// _unitOfWork.AttendanceDailyRepository.Create(DailyRecord);
// }
//}
var newEntryId = _unitOfWork.EmpTrainingRepository.Create(Domain);
Scope.Complete();
return(newEntryId.Id);
//Calling stroprocedure for data in attendance daily table
// exec Sp_TrainingAttendanceRecord newEntryId,'I'
}
}
public EmpTrainingDTO GetEmployeeTrainingById(int id)
{
EmpTraining Record = _unitOfWork.EmpTrainingRepository.GetById(id);
EmpTrainingDTO ReturnRecord = EmpTrainingResponseFormatter.ModelData(Record);
return(ReturnRecord);
}
public ActionResult DeleteConfirmed(int id)
{
EmpTraining empTraining = db.EmpTrainings.Find(id);
db.EmpTrainings.Remove(empTraining);
db.SaveChanges();
return(RedirectToAction("Create"));
}
public void Add(EmpTrainingDTO DTO)
{
using (var container = new InventoryContainer())
{
EmpTraining gur = new EmpTraining();
container.EmpTrainings.AddObject((EmpTraining )DTOMapper.DTOObjectConverter(DTO, gur));
container.SaveChanges();
}
}
public ActionResult Edit([Bind(Prefix = "Item1", Include = "empTrainID,empID,TrainingTitle,StartDate,EndDate,DurationHours,EventSponsor,EventVenue")] EmpTraining empTraining)
{
if (ModelState.IsValid)
{
db.Entry(empTraining).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Create"));
}
return(View(empTraining));
}
public ActionResult Create([Bind(Prefix = "Item1", Include = "empTrainID,empID,TrainingTitle,StartDate,EndDate,DurationHours,EventSponsor,EventVenue")] EmpTraining empTraining)
{
if (empTraining.empID != null)
{
if (ModelState.IsValid)
{
db.EmpTrainings.Add(empTraining);
db.SaveChanges();
return(RedirectToAction("Create"));
}
}
ModelState.AddModelError("", "Search for and employee first before saving data!");
return(View(empTraining));
}
// GET: Trainings/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmpTraining empTraining = db.EmpTrainings.Find(id);
if (empTraining == null)
{
return(HttpNotFound());
}
return(View(empTraining));
}
public void Edit(EmpTrainingDTO EduDTO)
{
using (var container = new InventoryContainer())
{
var Comp = new EmpTraining();
Comp = container.EmpTrainings.FirstOrDefault(o => o.TrainingId.Equals(EduDTO.TrainingId));
Comp.TrainingId = EduDTO.TrainingId;
Comp.EmpId = EduDTO.EmpId;
Comp.Duration = EduDTO.Duration;
Comp.InstituteName = EduDTO.InstituteName;
Comp.Location = EduDTO.Location;
Comp.TopicsCovered = EduDTO.TopicsCovered;
Comp.TrainingName = EduDTO.TrainingName;
Comp.TrainingYear = EduDTO.TrainingYear;
Comp.UpdateBy = EduDTO.UpdateBy;
Comp.UpdateDate = EduDTO.UpdateDate; //problem can be occur
Comp = (EmpTraining )DTOMapper.DTOObjectConverter(EduDTO, Comp);
container.SaveChanges();
}
}
public static EmpTrainingDTO ModelData(EmpTraining Record)
{
EmpTrainingDTO ReturnRecord = new EmpTrainingDTO
{
Id = Record.Id,
EmpCode = Record.EmpCode,
Designation = Record.Designation,
Rank = Record.Rank,
Office = Record.Office,
TrainingTitle = Record.TrainingTitle,
TrainingFocus = Record.TrainingFocus,
TrainingStartDate = Record.TrainingStartDate,
TrainingEndDate = Record.TrainingEndDate,
LetterDate = Record.LetterDate,
TrainingVisitStartDate = Record.TrainingVisitStartDate,
TrainingVisitEndDate = Record.TrainingVisitEndDate,
TrainingOrganization = Record.TrainingOrganization,
NationalInternational = Record.NationalInternational,
TrainingCountry = Record.TrainingCountry,
TrainingVenue = Record.TrainingVenue,
Sponsorship = Record.Sponsorship,
SponsorerOrganizationName = Record.SponsorerOrganizationName,
Approver = Record.Approver,
Designation1 = new DesignationDTO
{
},
Employee = new EmployeeDTO
{
},
Office1 = new OfficeDTOs
{
},
Rank1 = new RankDTO
{
}
};
return(ReturnRecord);
}
public void UpdateEmployeeTraining(EmpTrainingDTO Record)
{
EmpTraining Domain = EmpTrainingRequestFormatter.ConvertRespondentInfoFromDTO(Record);
_unitOfWork.EmpTrainingRepository.Update(Domain);
}
