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();
}
}
}
public static Jobcategory GetObject(Jobcategory o, FormCollection fc)
{
if (o == null)
o = new Jobcategory();
o.Name = fc.Get("name");
return o;
}