public bool UpdateDbidsOperator(Trainee trainee)
{
// update dbids operator
try
{
secdivDataContext db = new secdivDataContext();
var dbidsOperators = db.DbidsOperators.Where(d => d.PID.Equals(trainee.PID));
if (dbidsOperators.Count() > 0)
{
DbidsOperator dbidsOperator = dbidsOperators.First();
dbidsOperator.OperatorType = trainee.OperatorType;
dbidsOperator.LastTrainedDate = trainee.LastTrainedDate;
db.SubmitChanges();
return true;
}
else
return false;
}
catch
{
return false;
}
}
public bool UpdatePerson(Trainee trainee)
{
// update person
try
{
secdivDataContext db = new secdivDataContext();
var persons = db.Persons.Where(p => p.PID.Equals(trainee.PID));
if (persons.Count() > 0)
{
Person person = persons.First();
person.LastName = trainee.LastName;
person.FirstName = trainee.FirstName;
person.MiddleName = trainee.MiddleName;
person.TypeOfPID = trainee.TypeOfPID;
person.EMail = trainee.Email;
person.JobTitle = trainee.JobTitle;
person.OFFICECODE = trainee.OfficeCode;
person.HomePhone = trainee.HomePhone;
person.MobilePhone = trainee.MobilePhone;
person.Gender = trainee.Gender;
person.DateOfBirth = trainee.DateOfBirth;
person.PersonStatus = "Current";
person.OfficePhone = trainee.OfficePhone;
person.Fax = trainee.Fax;
person.Photo = trainee.Photo;
person.RankID = trainee.RankID;
db.SubmitChanges();
return true;
}
else
return false;
}
catch
{
return false;
}
}
public bool UpdatePersonDetail(Trainee trainee)
{
// update person details
try
{
secdivDataContext db = new secdivDataContext();
var personDetails = db.PersonDetails.Where(pd => pd.PID.Equals(trainee.PID));
if (personDetails.Count() > 0)
{
PersonDetail detailPerson = personDetails.First();
detailPerson.CountryCode = trainee.Nationality;
db.SubmitChanges();
return true;
}
else
return false;
}
catch
{
return false;
}
}
public bool UpdateUserAccount(Trainee trainee)
{
// update user account
try
{
string userName = string.Format("{0}{1}{2}", trainee.LastName, trainee.FirstName.Substring(0, 1), trainee.PID.Substring(trainee.PID.Length - 4, 4));
string password = string.Format("{0}{1}", trainee.LastName, trainee.PID.Substring(trainee.PID.Length - 4, 4));
byte[] passwd = DataHash.GetHashData(password, "SHA1");
secdivDataContext db = new secdivDataContext();
var userAccounts = db.UserAccounts.Where(u => u.PID.Equals(trainee.PID));
if (userAccounts.Count() > 0)
{
UserAccount userAccount = userAccounts.First();
if (userAccount.UserName == userName)
{
userAccount.Password = passwd;
userAccount.PID = trainee.PID;
userAccount.TypeOfUser = trainee.OperatorType;
userAccount.UAStatus = "Current";
db.SubmitChanges();
return true;
}
else
{
UserAccount ua = new UserAccount
{
UserName = userName,
Password = passwd,
PID = trainee.PID,
TypeOfUser = trainee.OperatorType,
UAStatus = "Current"
};
db.UserAccounts.InsertOnSubmit(ua);
db.SubmitChanges();
return true;
}
}
else
return false;
}
catch
{
return false;
}
}
public bool UpdateDbidsCertificate(Trainee trainee)
{
try
{
secdivDataContext db = new secdivDataContext();
var dbidsCertificates = db.DbidsCertificates.Where(d => d.OperatorPID.Equals(trainee.PID));
string remarks = string.Format("{0}. - Update thru trainee registration program", trainee.PersonRemarks);
if (dbidsCertificates.Count() > 0)
{
DbidsCertificate dbidsCertificate = dbidsCertificates.First();
dbidsCertificate.CertificateStatus = "Current";
dbidsCertificate.CertificateRemarks = remarks;
dbidsCertificate.CertificateUpdatedDate = trainee.LastTrainedDate;
dbidsCertificate.CertificateExpiredDate = trainee.LastTrainedDate.AddYears(1);
db.SubmitChanges();
return true;
}
else
return false;
}
catch
{
return false;
}
}
private void GetTrainees(List<PersonAndDbidsOperators.Person> operators)
{
TraineeByDate = new List<Trainee>();
Trainee trainee;
DeserializeXml dx = new DeserializeXml();
foreach (PersonAndDbidsOperators.Person person in operators)
{
DateTime dateOfBirth;
if (!string.IsNullOrEmpty(person.DateOfBirth))
dateOfBirth = DateTime.Parse(person.DateOfBirth);
else
dateOfBirth = DateTime.Now;
DateTime regDate = DateTime.Parse(person.RegDate);
DateTime lastTrainedDate = DateTime.Parse(person.LastTrainedDate);
Byte[] buffer = null;
ImageConverter ic = new ImageConverter();
buffer = ic.FromFileToByte(person.Photo);
var installation = dx.DeserializeInstallation().InstallationOptions.Where(i => i.InstallationCode.Equals(person.Installation)).Select(i => i.InstallationName).First();
trainee = new Trainee
{
PID = person.PID,
LastName = person.LastName,
HomePhone = person.HomePhone,
MobilePhone = person.MobilePhone,
FirstName = person.FirstName,
MiddleName = person.MiddleName,
DateOfBirth = dateOfBirth,
Gender = person.Gender,
OfficePhone = person.OfficePhone,
Fax = person.Fax,
Photo = buffer,
Email = person.Email,
RankID = int.Parse(person.RankID),
OfficeCode = person.OfficeCode,
TypeOfPID = person.TypeOfPID,
RegDate = regDate,
JobTitle = person.JobTitle,
PersonRemarks = person.PersonRemarks,
OperatorType = person.OperatorType,
Installation = person.Installation,
InstallationName = installation.ToString(),
LastTrainedDate = lastTrainedDate,
Nationality = person.Nationality
};
TraineeByDate.Add(trainee);
}
}
// Remove trainee data from XML
private void RemoveTraineeFromXML(Trainee trainee, bool isSuccess)
{
var trainedPerson = Trainees.Persons.Where(p => p.PID.Equals(trainee.PID)).Select(p => p).First();
if (File.Exists(trainedPerson.Photo))
{
try
{
File.Delete(trainedPerson.Photo);
}
catch
{
MessageBox.Show(string.Format("{0}'s photo couldn't remove.", trainedPerson.LastName), "Image File Delete", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
Trainees.Persons.Remove(trainedPerson);
TraineeToUpload.Remove(trainee);
}
public void RemoveTraineeFromXML(object sender, Trainee trainee, bool isSuccess)
{
Dispatcher.Invoke(new RemoveTraineeFromXMLDelegate(RemoveTraineeFromXML), trainee, isSuccess);
}
