public static Employeequalification GetObject(Employee e, FormCollection fc)
{
string paramStartdate = GetParam("start_date", fc);
DateTime startdate = CommonHelper.GetDateTime(paramStartdate);
string paramEnddate = GetParam("end_date", fc);
DateTime enddate = CommonHelper.GetDateTime(paramEnddate);
string paramLevel = GetParam("level", fc);
int level = CommonHelper.GetValue<int>(paramLevel);
string paramYear = GetParam("year", fc);
int year = CommonHelper.GetValue<int>(paramYear);
string paramGpa = GetParam("gpa", fc);
double gpa = CommonHelper.GetValue<double>(paramGpa);
Employeequalification o = e.Employeequalification;
if (o == null)
{
o = new Employeequalification();
o.Id = e.Id;
}
o.Level = level;
o.Institute = GetParam("institute", fc);
o.Major = GetParam("major", fc);
o.Year = year;
o.Gpa = gpa;
o.Startdate = startdate;
o.Enddate = enddate;
return o;
}
public static async Task<Employeejob> GetObject(ISession se, Employee e, FormCollection fc)
{
string paramJoindate = GetParam("join_date", fc);
DateTime joindate = CommonHelper.GetDateTime(paramJoindate);
string paramConfirmdate = GetParam("confirm_date", fc);
DateTime confirmdate = CommonHelper.GetDateTime(paramConfirmdate);
string paramDesignationid = GetParam("designation_id", fc);
Designation des = string.IsNullOrEmpty(paramDesignationid) || paramDesignationid == "0" ? null : new Designation();
string paramDepartmentid = GetParam("department_id", fc);
Department dept = string.IsNullOrEmpty(paramDepartmentid) || paramDepartmentid == "0" ? null : new Department();
string paramEmploymentstatusid = GetParam("employment_status_id", fc);
Employmentstatus es = string.IsNullOrEmpty(paramEmploymentstatusid) || paramEmploymentstatusid == "0" ? null : new Employmentstatus();
string paramJobcategoryid = GetParam("job_category_id", fc);
Jobcategory jobcat = string.IsNullOrEmpty(paramJobcategoryid) || paramJobcategoryid == "0" ? null : new Jobcategory();
if (des != null)
des = await Task.Run(() => { return se.Get<Designation>(CommonHelper.GetValue<int>(paramDesignationid)); });
if (dept != null)
dept = await Task.Run(() => { return se.Get<Department>(CommonHelper.GetValue<int>(paramDepartmentid)); });
if (es != null)
es = await Task.Run(() => { return se.Get<Employmentstatus>(CommonHelper.GetValue<int>(paramEmploymentstatusid)); });
if (jobcat != null)
jobcat = await Task.Run(() => { return se.Get<Jobcategory>(CommonHelper.GetValue<int>(paramJobcategoryid)); });
Employeejob o = e.Employeejob;
if (o == null)
{
o = new Employeejob();
o.Id = e.Id;
}
o.Designation = des;
o.Department = dept;
o.Employmentstatus = es;
o.Jobcategory = jobcat;
o.Joindate = joindate;
o.Confirmdate = confirmdate;
return o;
}
public static Employeesalary GetObject(Employee e,FormCollection fc)
{
string paramSalary = GetParam("salary", fc);
double salary = CommonHelper.GetValue<double>(paramSalary);
string paramAllowance = GetParam("allowance", fc);
double allowance = CommonHelper.GetValue<double>(paramAllowance);
string paramEpf = GetParam("epf", fc);
double epf = CommonHelper.GetValue<double>(paramEpf);
string paramSocso = GetParam("socso", fc);
double socso = CommonHelper.GetValue<double>(paramSocso);
string paramIncometax = GetParam("income_tax", fc);
double incometax = CommonHelper.GetValue<double>(paramIncometax);
string paramPaytype = GetParam("pay_type", fc);
int? paytype = string.IsNullOrEmpty(paramPaytype) ? null : new Nullable<int>(CommonHelper.GetValue<int>(paramPaytype));
Employeesalary o = e.Employeesalary;
if (o == null)
{
o = new Employeesalary();
o.Id = e.Id;
}
o.Salary = salary;
o.Allowance = allowance;
o.Epf = epf;
o.Socso = socso;
o.Incometax = incometax;
o.Bankname = GetParam("bank_name", fc);
o.Bankaccno = GetParam("bank_acc_no", fc);
o.Bankacctype = GetParam("bank_acc_type", fc);
o.Bankaddress = GetParam("bank_address", fc);
o.Epfno = GetParam("epf_no", fc);
o.Socsono = GetParam("socso_no", fc);
o.Incometaxno = GetParam("ncome_tax_no", fc);
o.Paytype = paytype;
return o;
}
public static Employeecontact GetObject(Employee e, FormCollection fc)
{
Employeecontact o = e.Employeecontact;
if (o == null)
{
o = new Employeecontact();
o.Id = e.Id;
}
o.Address1 = GetParam("address_1", fc);
o.Address2 = GetParam("address_2", fc);
o.Address3 = GetParam("address_3", fc);
o.City = GetParam("city", fc);
o.State = GetParam("state", fc);
o.Postcode = GetParam("postcode", fc);
o.Country = GetParam("country", fc);
o.Homephone = GetParam("home_phone", fc);
o.Mobilephone = GetParam("mobile_phone", fc);
o.Workemail = GetParam("work_email", fc);
o.Otheremail = GetParam("other_email", fc);
return o;
}
public static async Task<Employee> GetObject(ISession se, Employee o, FormCollection fc)
{
string paramDob = GetParam("dob", fc);
DateTime dob = CommonHelper.GetDateTime(paramDob);
string paramIsbumi = GetParam("is_bumi", fc);
bool? isbumi = string.IsNullOrEmpty(paramIsbumi) ? null : new Nullable<bool>(Convert.ToBoolean(paramIsbumi));
string paramUserid = GetParam("user_id", fc);
User user = string.IsNullOrEmpty(paramUserid) || paramUserid == "0" ? null : new User();
if (user != null)
user = await Task.Run(() => { return se.Get<User>(new Guid(paramUserid)); });
if (o == null)
o = new Employee();
string staff_id = GetParam("staff_id", fc);
if (!string.IsNullOrEmpty(staff_id))
o.Staffid = staff_id;
o.Firstname = GetParam("first_name", fc);
o.Middlename = GetParam("middle_name", fc);
o.Lastname = GetParam("last_name", fc);
o.Newic = GetParam("new_ic", fc);
o.Oldic = GetParam("old_ic", fc);
o.Passportno = GetParam("passport_no", fc);
o.Gender = GetParam("gender", fc);
o.Maritalstatus = GetParam("marital_status", fc);
o.Nationality = GetParam("nationality", fc);
o.Dob = dob;
o.Placeofbirth = GetParam("place_of_birth", fc);
o.Race = GetParam("race", fc);
o.Religion = GetParam("religion", fc);
o.Isbumi = isbumi;
if (!string.IsNullOrEmpty(paramUserid))
o.User = user;
return o;
}
private static async Task CreateSeed(ISessionFactory s)
{
using (ISession se = s.OpenSession())
{
using (ITransaction tx = se.BeginTransaction())
{
User a = new User { Username = "******", Password = "******", Role = 1, Status = true };
a.EncryptPassword();
se.SaveOrUpdate(a);
a = new User { Username = "******", Password = "******", Role = 2, Status = true };
a.EncryptPassword();
se.SaveOrUpdate(a);
Employee o = new Employee
{
Staffid = "S0001",
Firstname = "Ben",
Lastname = "Ng",
Newic = "77665544",
Gender = "M",
Maritalstatus = "S",
Nationality = "Malaysian",
Dob = new DateTime(1988, 6, 5),
Placeofbirth = "PJ",
Race = "Chinese",
Isbumi = false,
User = a
};
se.SaveOrUpdate(o);
Employeecontact ect = new Employeecontact
{
Id = o.Id,
Address1 = "No. 6, Jalan Awan Kecil 1",
Address2 = "Taman OUG",
Address3 = "Off Jalan Klang Lama",
City = "KL",
State = "WP",
Postcode = "58200",
Country = "Malaysia",
Homephone = "88098776",
Mobilephone = "77609887",
Workemail = "*****@*****.**",
Otheremail = "*****@*****.**",
};
se.SaveOrUpdate(ect);
await CreateListAttendance(se, o.Staffid, o);
Employeesalary es = new Employeesalary
{
Id = o.Id,
Salary = 0,
Allowance = 45,
Epf = 278,
Socso = 46,
Incometax = 57,
Bankname = "RHB",
Bankaccno = "5509800076",
Bankacctype = "Savings",
Bankaddress = "Jalan Awan Besar",
Epfno = "443987542",
Socsono = "8876908539",
Incometaxno = "439877055",
Paytype = 2
};
se.SaveOrUpdate(es);
Designation des = new Designation { Title = "Software Developer" };
se.SaveOrUpdate(des);
Department dept = new Department { Name = "R&D" };
se.SaveOrUpdate(dept);
Jobcategory jobcat = new Jobcategory { Name = "Software Development" };
se.SaveOrUpdate(jobcat);
Employmentstatus empstat = new Employmentstatus { Name = "Probation" };
se.SaveOrUpdate(empstat);
empstat = new Employmentstatus { Name = "Confirmed" };
se.SaveOrUpdate(empstat);
Employeejob empjob = new Employeejob
{
Id = o.Id,
Designation = des,
Department = dept,
Employmentstatus = empstat,
Jobcategory = jobcat,
Joindate = new DateTime(2000, 1, 1),
Confirmdate = new DateTime(2000, 3, 1)
};
se.SaveOrUpdate(empjob);
//
a = new User { Username = "******", Password = "******", Role = 2, Status = true };
a.EncryptPassword();
se.SaveOrUpdate(a);
o = new Employee
{
Staffid = "S0002",
Firstname = "Ken",
Lastname = "Lee",
Newic = "785400",
Gender = "M",
Maritalstatus = "S",
Nationality = "Malaysian",
Dob = new DateTime(1986, 6, 5),
Placeofbirth = "PJ",
Race = "Chinese",
Isbumi = false,
User = a
};
se.SaveOrUpdate(o);
ect = new Employeecontact
{
Id = o.Id,
Address1 = "No. 7, Jalan Putra 1",
Address2 = "Taman Pinang",
Address3 = "Off Jalan Putra Perdana",
City = "KL",
State = "WP",
Postcode = "59200",
Country = "Malaysia",
Homephone = "88028776",
Mobilephone = "77659887",
Workemail = "*****@*****.**",
Otheremail = "*****@*****.**"
};
se.SaveOrUpdate(ect);
await CreateListAttendance(se, o.Staffid, o);
es = new Employeesalary
{
Id = o.Id,
Salary = 0,
Allowance = 55,
Epf = 298,
Socso = 65,
Incometax = 95,
Bankname = "RHB",
Bankaccno = "5509800077",
Bankacctype = "Savings",
Bankaddress = "Jalan Awan Besar",
Epfno = "443987548",
Socsono = "8878908539",
Incometaxno = "439899055",
Paytype = 2
};
se.SaveOrUpdate(es);
des = new Designation { Title = "Account Executive" };
se.SaveOrUpdate(des);
dept = new Department { Name = "Admin" };
se.SaveOrUpdate(dept);
jobcat = new Jobcategory { Name = "Administration" };
se.SaveOrUpdate(jobcat);
empjob = new Employeejob
{
Id = o.Id,
Designation = des,
Department = dept,
Employmentstatus = empstat,
Jobcategory = jobcat,
Joindate = new DateTime(2000, 2, 1),
Confirmdate = new DateTime(2000, 4, 1)
};
se.SaveOrUpdate(empjob);
//
a = new User { Username = "******", Password = "******", Role = 2, Status = true };
a.EncryptPassword();
se.SaveOrUpdate(a);
o = new Employee
{
Staffid = "S0003",
Firstname = "Steve",
Lastname = "Yap",
Newic = "65098765",
Gender = "M",
Maritalstatus = "S",
Nationality = "Malaysian",
Dob = new DateTime(1974, 6, 5),
Placeofbirth = "PJ",
Race = "Chinese",
Isbumi = false,
User = a
};
se.SaveOrUpdate(o);
ect = new Employeecontact
{
Id = o.Id,
Address1 = "No. 5, Jalan Bukit Bintang",
Address2 = "Taman Bintang",
Address3 = "Off Jalan Bukit",
City = "KL",
State = "WP",
Postcode = "57200",
Country = "Malaysia",
Homephone = "88798776",
Mobilephone = "79609887",
Workemail = "*****@*****.**",
Otheremail = "*****@*****.**"
};
se.SaveOrUpdate(ect);
await CreateListAttendance(se, o.Staffid, o);
es = new Employeesalary
{
Id = o.Id,
Salary = 0,
Allowance = 55,
Epf = 300,
Socso = 62,
Incometax = 48,
Bankname = "RHB",
Bankaccno = "5509100076",
Bankacctype = "Savings",
Bankaddress = "Jalan Awan Besar",
Epfno = "473987542",
Socsono = "8879908539",
Incometaxno = "439817055",
Paytype = 2
};
se.SaveOrUpdate(es);
des = new Designation { Title = "Sales Executive" };
se.SaveOrUpdate(des);
dept = new Department { Name = "Sales" };
se.SaveOrUpdate(dept);
jobcat = new Jobcategory { Name = "Sales" };
se.SaveOrUpdate(jobcat);
empjob = new Employeejob
{
Id = o.Id,
Designation = des,
Department = dept,
Employmentstatus = empstat,
Jobcategory = jobcat,
Joindate = new DateTime(2000, 3, 1),
Confirmdate = new DateTime(2000, 5, 1)
};
se.SaveOrUpdate(empjob);
await CreatePayRate(se, "S0001");
await CreatePayRate(se, "S0002");
await CreatePayRate(se, "S0003");
//
a = new User { Username = "******", Password = "******", Role = 2, Status = true };
a.EncryptPassword();
se.SaveOrUpdate(a);
o = new Employee
{
Staffid = "S0004",
Firstname = "Kelly",
Lastname = "Yap",
Newic = "55441122",
Gender = "F",
Maritalstatus = "S",
Nationality = "Malaysian",
Dob = new DateTime(1979, 6, 5),
Placeofbirth = "KL",
Race = "Chinese",
Isbumi = false,
User = a
};
se.SaveOrUpdate(o);
ect = new Employeecontact
{
Id = o.Id,
Address1 = "No. 2, Jalan Kerinchi 5",
Address2 = "Taman Bukit Kerinchi",
Address3 = "Off Jalan Kerinchi Besar",
City = "KL",
State = "WP",
Postcode = "56200",
Country = "Malaysia",
Homephone = "88098476",
Mobilephone = "77609187",
Workemail = "*****@*****.**",
Otheremail = "*****@*****.**"
};
se.SaveOrUpdate(ect);
await CreateListAttendance(se, o.Staffid, o);
Random r = new Random();
es = new Employeesalary
{
Id = o.Id,
Salary = r.Next(2500, 3000),
Allowance = r.Next(60, 100),
Epf = r.Next(100, 200),
Socso = r.Next(90, 100),
Incometax = r.Next(100, 200),
Bankname = "RHB",
Bankaccno = "667743290",
Bankacctype = "Savings",
Bankaddress = "Jalan Pinang",
Epfno = "59876000",
Socsono = "76545",
Incometaxno = "ASD965777",
Paytype = 1
};
se.SaveOrUpdate(es);
des = new Designation { Title = "Marketing Executive" };
se.SaveOrUpdate(des);
dept = new Department { Name = "Marketing" };
se.SaveOrUpdate(dept);
jobcat = new Jobcategory { Name = "Marketing" };
se.SaveOrUpdate(jobcat);
empjob = new Employeejob
{
Id = o.Id,
Designation = des,
Department = dept,
Employmentstatus = empstat,
Jobcategory = jobcat,
Joindate = new DateTime(2000, 1, 1),
Confirmdate = new DateTime(2000, 3, 1)
};
se.SaveOrUpdate(empjob);
await CreateOvertimeRate(se);
await CreateSalaryAdj(se, o.Staffid);
tx.Commit();
}
}
}
private static async Task CreateListAttendance(ISession se, string staffId, Employee e)
{
Random r = new Random();
await Task.Run(() =>
{
for (int y = 2000; y <= DateTime.Now.Year; y++)
{
for (int m = 1; m <= 12; m++)
{
List<int> days = ListDay(m, y);
foreach (int k in days)
{
DateTime ti = new DateTime(y, m, k, 8, r.Next(20, 59), 0, DateTimeKind.Utc);
DateTime to = new DateTime(y, m, k, r.Next(18, 20), r.Next(0, 50), 0, DateTimeKind.Utc);
Attendance a = new Attendance { Staffid = staffId, Timein = ti, Timeout = to, Workdate = new DateTime(y, m, k) };
se.SaveOrUpdate(a);
}
}
}
});
}