Exemple #1
0
        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;
        }