public ActionResult Create(LeaveRequest Createleave)
{
string reason;
if (ModelState.IsValid)
{
if (cek_data("*", "KMIHRMS_DETAIL_LEAVE", "EMPID='" + Createleave.Empid + "' and leave_type='" + Createleave.SelectedItem + "' and to_char(FROMLEAVE,'dd/mm/yyyy')='" + Createleave.fromleave + "'and to_char(TOLEAVE,'dd/mm/yyyy')='" + Createleave.toleave + "'") == false)
{
string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;";
string empid, empname, bagian, namabagian, namaapproved, emailapproved;
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (Createleave.SelectedItem == "CT")
{
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "INSERT INTO KMIHRMS_DETAIL_LEAVE (EMPID,LEAVE_TYPE,FROMLEAVE,TOLEAVE,REASON,ADDRESS,STATUS,DAYS) VALUES ('" + Createleave.Empid + "','" + Createleave.SelectedItem + "',to_date('" + Createleave.fromleave + "','DD/MM/YYYY'),to_date('" + Createleave.toleave + "','DD/MM/YYYY'),'" + Createleave.reasonpost1 + "','" + Createleave.Alamat + "','Release','" + Createleave.hari + "')";
cmd1.CommandType = CommandType.Text;
cmd1.Connection = connection;
connection.Open();
cmd1.ExecuteNonQuery();
OracleCommand cmd2 = new OracleCommand();
cmd2.CommandText = "select t.EMP_ID,t.EMP_NAME,T.COST_CENTER,t.CC_DESC from person.personal_master t where t.emp_id='" + Createleave.Empid + "'";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
using (OracleDataReader rdr1 = cmd2.ExecuteReader())
{
rdr1.Read();
empid = rdr1.GetString(0);
empname = rdr1.GetString(1);
bagian = rdr1.GetString(2);
namabagian = rdr1.GetString(3);
}
OracleCommand cmd3 = new OracleCommand();
cmd3.CommandText = "select KLAT.app1_id app_id,CEMT.EMP_NAME,cemt.email,KLAT.app1_as app_as from person.KMIHRMS_LEAVE_APP_TAB KLAT " +
"INNER JOIN PERSON.CTM_EMPLOYEE_MASTER_TAB CEMT ON CEMT.EMP_ID=KLAT.APP1_ID " +
"where requsioner_id='" + bagian + "' and app_type='HR'";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = connection;
using (OracleDataReader rdr2 = cmd3.ExecuteReader())
{
rdr2.Read();
namaapproved = rdr2.GetString(1);
emailapproved = rdr2.GetString(2);
}
sendmail(namaapproved, emailapproved, empid, empname, bagian, namabagian, DateTime.ParseExact(Createleave.fromleave, "dd/MM/yyyy", null), DateTime.ParseExact(Createleave.toleave, "dd/MM/yyyy", null), Createleave.reasonpost1, Createleave.SelectedItem, Createleave.Alamat, Createleave.hpl, Createleave.tglkej, Createleave.times);
connection.Close();
/*}*/
}
else if (Createleave.SelectedItem == "CH")
{
TimeSpan date = (DateTime.ParseExact(Createleave.toleave, "dd/MM/yyyy", null) - DateTime.ParseExact(Createleave.fromleave, "dd/MM/yyyy", null));
if (Math.Round(date.TotalDays + 1) > 2)
{
return Content("<script language='javascript' type='text/javascript'>alert('Your Request More Then 2 Days !');location.href = 'Create'; ;</script>", "WARNING");
}
else
{
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "INSERT INTO KMIHRMS_DETAIL_LEAVE (EMPID,LEAVE_TYPE,FROMLEAVE,TOLEAVE,ADDRESS,STATUS,DAYS) VALUES ('" + Createleave.Empid + "','" + Createleave.SelectedItem + "',to_date('" + Createleave.fromleave + "','DD/MM/YYYY'),to_date('" + Createleave.toleave + "','DD/MM/YYYY'),'" + Createleave.Alamat + "','Release','" + Createleave.hari + "')";
cmd1.CommandType = CommandType.Text;
cmd1.Connection = connection;
connection.Open();
cmd1.ExecuteNonQuery();
OracleCommand cmd2 = new OracleCommand();
cmd2.CommandText = "select t.EMP_ID,t.EMP_NAME,T.COST_CENTER,t.CC_DESC from person.personal_master t where t.emp_id='" + Createleave.Empid + "'";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
using (OracleDataReader rdr1 = cmd2.ExecuteReader())
{
rdr1.Read();
empid = rdr1.GetString(0);
empname = rdr1.GetString(1);
bagian = rdr1.GetString(2);
namabagian = rdr1.GetString(3);
}
OracleCommand cmd3 = new OracleCommand();
cmd3.CommandText = "select KLAT.app1_id app_id,CEMT.EMP_NAME,cemt.email,KLAT.app1_as app_as from person.KMIHRMS_LEAVE_APP_TAB KLAT " +
"INNER JOIN PERSON.CTM_EMPLOYEE_MASTER_TAB CEMT ON CEMT.EMP_ID=KLAT.APP1_ID " +
"where requsioner_id='" + bagian + "' and app_type='HR'";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = connection;
using (OracleDataReader rdr2 = cmd3.ExecuteReader())
{
rdr2.Read();
namaapproved = rdr2.GetString(1);
emailapproved = rdr2.GetString(2);
}
sendmail(namaapproved, emailapproved, empid, empname, bagian, namabagian, DateTime.ParseExact(Createleave.fromleave, "dd/MM/yyyy", null), DateTime.ParseExact(Createleave.toleave, "dd/MM/yyyy", null), Createleave.reasonpost, Createleave.SelectedItem, Createleave.Alamat, Createleave.hpl, Createleave.tglkej, Createleave.times);
connection.Close();
}
}
else if (Createleave.SelectedItem == "DI")
{
if (Createleave.reasonpost== "Perkawinan")
{
reason = Createleave.reasonpost + " " + Createleave.detail;
}
else if (Createleave.reasonpost == "Meninggal Dunia")
{
reason = Createleave.reasonpost + " " + Createleave.detail1;
}
else
{
reason = Createleave.reasonpost;
}
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "INSERT INTO KMIHRMS_DETAIL_LEAVE (EMPID,LEAVE_TYPE,FROMLEAVE,TOLEAVE,ADDRESS,STATUS,REASON,DAYS,REALDATE,TIMESREAL) VALUES ('" + Createleave.Empid + "','" + Createleave.SelectedItem + "',to_date('" + Createleave.fromleave + "','DD/MM/YYYY'),to_date('" + Createleave.toleave + "','DD/MM/YYYY'),'" + Createleave.Alamat + "','Release','" + reason + "','" + Createleave.hari + "',to_date('" + Createleave.tglkej + "','DD/MM/YYYY'),to_date('" + Createleave.times + "','HH24:MI'))";
cmd1.CommandType = CommandType.Text;
cmd1.Connection = connection;
connection.Open();
cmd1.ExecuteNonQuery();
OracleCommand cmd2 = new OracleCommand();
cmd2.CommandText = "select t.EMP_ID,t.EMP_NAME,T.COST_CENTER,t.CC_DESC from person.personal_master t where t.emp_id='" + Createleave.Empid + "'";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
using (OracleDataReader rdr1 = cmd2.ExecuteReader())
{
rdr1.Read();
empid = rdr1.GetString(0);
empname = rdr1.GetString(1);
bagian = rdr1.GetString(2);
namabagian = rdr1.GetString(3);
}
OracleCommand cmd3 = new OracleCommand();
cmd3.CommandText = "select KLAT.app1_id app_id,CEMT.EMP_NAME,cemt.email,KLAT.app1_as app_as from person.KMIHRMS_LEAVE_APP_TAB KLAT " +
"INNER JOIN PERSON.CTM_EMPLOYEE_MASTER_TAB CEMT ON CEMT.EMP_ID=KLAT.APP1_ID " +
"where requsioner_id='" + bagian + "' and app_type='HR'";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = connection;
using (OracleDataReader rdr2 = cmd3.ExecuteReader())
{
rdr2.Read();
namaapproved = rdr2.GetString(1);
emailapproved = rdr2.GetString(2);
}
sendmail(namaapproved, emailapproved, empid, empname, bagian, namabagian, DateTime.ParseExact(Createleave.fromleave, "dd/MM/yyyy", null), DateTime.ParseExact(Createleave.toleave, "dd/MM/yyyy", null), reason, Createleave.SelectedItem, Createleave.Alamat, Createleave.hpl, Createleave.tglkej, Createleave.times);
connection.Close();
}
else if (Createleave.SelectedItem == "I")
{
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "INSERT INTO KMIHRMS_DETAIL_LEAVE (EMPID,LEAVE_TYPE,FROMLEAVE,TOLEAVE,REASON,ADDRESS,STATUS,DAYS) VALUES ('" + Createleave.Empid + "','" + Createleave.SelectedItem + "',to_date('" + Createleave.fromleave + "','DD/MM/YYYY'),to_date('" + Createleave.toleave + "','DD/MM/YYYY'),'" + Createleave.reasonpost1 + "','" + Createleave.Alamat + "','Release','" + Createleave.hari + "')";
cmd1.CommandType = CommandType.Text;
cmd1.Connection = connection;
connection.Open();
cmd1.ExecuteNonQuery();
OracleCommand cmd2 = new OracleCommand();
cmd2.CommandText = "select t.EMP_ID,t.EMP_NAME,T.COST_CENTER,t.CC_DESC from person.personal_master t where t.emp_id='" + Createleave.Empid + "'";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
using (OracleDataReader rdr1 = cmd2.ExecuteReader())
{
rdr1.Read();
empid = rdr1.GetString(0);
empname = rdr1.GetString(1);
bagian = rdr1.GetString(2);
namabagian = rdr1.GetString(3);
}
OracleCommand cmd3 = new OracleCommand();
cmd3.CommandText = "select KLAT.app1_id app_id,CEMT.EMP_NAME,cemt.email,KLAT.app1_as app_as from person.KMIHRMS_LEAVE_APP_TAB KLAT " +
"INNER JOIN PERSON.CTM_EMPLOYEE_MASTER_TAB CEMT ON CEMT.EMP_ID=KLAT.APP1_ID " +
"where requsioner_id='" + bagian + "' and app_type='HR'";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = connection;
using (OracleDataReader rdr2 = cmd3.ExecuteReader())
{
rdr2.Read();
namaapproved = rdr2.GetString(1);
emailapproved = rdr2.GetString(2);
}
sendmail(namaapproved, emailapproved, empid, empname, bagian, namabagian, DateTime.ParseExact(Createleave.fromleave, "dd/MM/yyyy", null), DateTime.ParseExact(Createleave.toleave, "dd/MM/yyyy", null), Createleave.reasonpost1, Createleave.SelectedItem, Createleave.Alamat, Createleave.hpl, Createleave.tglkej, Createleave.times);
connection.Close();
}
else if (Createleave.SelectedItem == "CI")
{
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "INSERT INTO KMIHRMS_DETAIL_LEAVE (EMPID,LEAVE_TYPE,FROMLEAVE,TOLEAVE,REASON,ADDRESS,STATUS,DAYS) VALUES ('" + Createleave.Empid + "','" + Createleave.SelectedItem + "',to_date('" + Createleave.fromleave + "','DD/MM/YYYY'),to_date('" + Createleave.toleave + "','DD/MM/YYYY'),'" + Createleave.reasonpost1 + "','" + Createleave.Alamat + "','Release','" + Createleave.hari + "')";
cmd1.CommandType = CommandType.Text;
cmd1.Connection = connection;
connection.Open();
cmd1.ExecuteNonQuery();
OracleCommand cmd2 = new OracleCommand();
cmd2.CommandText = "select t.EMP_ID,t.EMP_NAME,T.COST_CENTER,t.CC_DESC from person.personal_master t where t.emp_id='" + Createleave.Empid + "'";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
using (OracleDataReader rdr1 = cmd2.ExecuteReader())
{
rdr1.Read();
empid = rdr1.GetString(0);
empname = rdr1.GetString(1);
bagian = rdr1.GetString(2);
namabagian = rdr1.GetString(3);
}
OracleCommand cmd3 = new OracleCommand();
cmd3.CommandText = "select KLAT.app1_id app_id,CEMT.EMP_NAME,cemt.email,KLAT.app1_as app_as from person.KMIHRMS_LEAVE_APP_TAB KLAT " +
"INNER JOIN PERSON.CTM_EMPLOYEE_MASTER_TAB CEMT ON CEMT.EMP_ID=KLAT.APP1_ID " +
"where requsioner_id='" + bagian + "' and app_type='HR'";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = connection;
using (OracleDataReader rdr2 = cmd3.ExecuteReader())
{
rdr2.Read();
namaapproved = rdr2.GetString(1);
emailapproved = rdr2.GetString(2);
}
sendmail(namaapproved, emailapproved, empid, empname, bagian, namabagian, DateTime.ParseExact(Createleave.fromleave, "dd/MM/yyyy", null), DateTime.ParseExact(Createleave.toleave, "dd/MM/yyyy", null), Createleave.reasonpost1, Createleave.SelectedItem, Createleave.Alamat, Createleave.hpl, Createleave.tglkej, Createleave.times);
connection.Close();
}
else if (Createleave.SelectedItem == "CM")
{
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "INSERT INTO KMIHRMS_DETAIL_LEAVE (EMPID,LEAVE_TYPE,FROMLEAVE,TOLEAVE,REASON,ADDRESS,STATUS,DAYS,REALDATE) VALUES ('" + Createleave.Empid + "','" + Createleave.SelectedItem + "',to_date('" + Createleave.fromleave + "','DD/MM/YYYY'),to_date('" + Createleave.toleave + "','DD/MM/YYYY'),'Melahirkan','" + Createleave.Alamat + "','Release','" + Createleave.hari + "',to_date('" + Createleave.hpl + "','DD/MM/YYYY'))";
cmd1.CommandType = CommandType.Text;
cmd1.Connection = connection;
connection.Open();
cmd1.ExecuteNonQuery();
OracleCommand cmd2 = new OracleCommand();
cmd2.CommandText = "select t.EMP_ID,t.EMP_NAME,T.COST_CENTER,t.CC_DESC from person.personal_master t where t.emp_id='" + Createleave.Empid + "'";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
using (OracleDataReader rdr1 = cmd2.ExecuteReader())
{
rdr1.Read();
empid = rdr1.GetString(0);
empname = rdr1.GetString(1);
bagian = rdr1.GetString(2);
namabagian = rdr1.GetString(3);
}
OracleCommand cmd3 = new OracleCommand();
cmd3.CommandText = "select KLAT.app1_id app_id,CEMT.EMP_NAME,cemt.email,KLAT.app1_as app_as from person.KMIHRMS_LEAVE_APP_TAB KLAT " +
"INNER JOIN PERSON.CTM_EMPLOYEE_MASTER_TAB CEMT ON CEMT.EMP_ID=KLAT.APP1_ID " +
"where requsioner_id='" + bagian + "' and app_type='HR'";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = connection;
using (OracleDataReader rdr2 = cmd3.ExecuteReader())
{
rdr2.Read();
namaapproved = rdr2.GetString(1);
emailapproved = rdr2.GetString(2);
}
sendmail(namaapproved, emailapproved, empid, empname, bagian, namabagian, DateTime.ParseExact(Createleave.fromleave, "dd/MM/yyyy", null), DateTime.ParseExact(Createleave.toleave, "dd/MM/yyyy", null), "Melahirkan", Createleave.SelectedItem, Createleave.Alamat, Createleave.hpl, Createleave.tglkej, Createleave.times);
connection.Close();
}
return RedirectToAction("Index");
}
}
else
{
return Content("<script language='javascript' type='text/javascript'>alert('Your Request Already Exist!');location.href = 'Index'; ;</script>", "WARNING");
}
}
return View(Createleave);
}
public ViewResult Index(LeaveRequest model)
{
return View(model);
}
public ActionResult Create()
{
LeaveRequest model = new LeaveRequest();
return View(model);
}