public async Task <ActionResult> Create(FormCollection fc)
{
Jobcategory o = JobcategoryHelper.GetObject(null, fc);
Dictionary <string, object> err = null;
ISession se = NHibernateHelper.CurrentSession;
err = o.IsValid(se);
if (err == null)
{
await Task.Run(() =>
{
using (ITransaction tx = se.BeginTransaction())
{
se.SaveOrUpdate(o);
tx.Commit();
}
});
return(Json(new Dictionary <string, object>
{
{ "success", 1 },
{ "message", "Job Category was successfully added." }
},
JsonRequestBehavior.AllowGet));
}
else
{
return(Json(err, JsonRequestBehavior.AllowGet));
}
}
private async Task DeleteReferences(ISession se, string[] idlist)
{
foreach (string id in idlist)
{
int uid = CommonHelper.GetValue <int>(id);
Jobcategory o = se.Get <Jobcategory>(uid);
IList <Employeejob> l = o.Employeejob;
if (l != null)
{
foreach (Employeejob e in l)
{
e.Jobcategory = null;
await Task.Run(() =>
{
using (ITransaction tx = se.BeginTransaction())
{
se.SaveOrUpdate(e);
tx.Commit();
}
});
}
}
}
}
public async Task <ActionResult> Edit(int id)
{
ViewBag.form_id = "edit-form";
ISession se = NHibernateHelper.CurrentSession;
Jobcategory o = await Task.Run(() => { return(se.Get <Jobcategory>(id)); });
return(View("_form", 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 Jobcategory GetObject(Jobcategory o, FormCollection fc)
{
if (o == null)
{
o = new Jobcategory();
}
o.Name = fc.Get("name");
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();
}
}
}