public ActionResult Create(P2K3 P2K3)
{
if (ModelState.IsValid)
{
string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;";
string P2K3_ID;
using (OracleConnection connection = new OracleConnection(connectionString))
{
string number = null;
number = "";
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select nvl(max(substr(P2K3_ID,7,3)),0) from KMIINTRANET_MASTER_P2K3 where substr(P2K3_ID,1,6)='" + Convert.ToDateTime(System.DateTime.Now).ToString("yyyyMM") + "'";
cmd1.Connection = connection;
connection.Open();
objDataReader = cmd1.ExecuteReader();
if (objDataReader.HasRows)
{
objDataReader.Read();
number = Convert.ToString(Convert.ToInt32(objDataReader[0]) + 1);
if (number.Length == 1)
{
number = "00" + number;
}
else if (number.Length == 2)
{
number = "0" + number;
}
else if (number.Length == 3)
{
number = number;
}
}
cmd1 = null;
connection.Close();
OracleCommand cmd2 = new OracleCommand();
P2K3_ID = Convert.ToDateTime(System.DateTime.Now).ToString("yyyyMM") + number;
byte[] tempFile = new byte[P2K3.P2K3File.InputStream.Length];
P2K3.P2K3File.InputStream.Read(tempFile, 0, tempFile.Length);
cmd2.CommandText = "INSERT INTO KMIINTRANET_MASTER_P2K3(P2K3_ID,P2K3_TITLE,P2K3_INFO,P2K3_FILE,STATUS,CREATE_BY,CREATE_DATE) VALUES (:p2k3id,:title,:info,:p2k3file,:stat,'" + Session["USER"] + "',sysdate)";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
connection.Open();
cmd2.Parameters.Add(":stat", OracleType.VarChar).Value = P2K3.stat.ToString();
cmd2.Parameters.Add(":p2k3file", OracleType.Blob).Value = tempFile;
cmd2.Parameters.Add(":info", OracleType.VarChar).Value = P2K3.isi.ToString();
cmd2.Parameters.Add(":title", OracleType.VarChar).Value = P2K3.title.ToString();
cmd2.Parameters.Add(":p2k3id", OracleType.VarChar).Value = P2K3_ID;
cmd2.ExecuteNonQuery();
cmd2 = null;
connection.Close();
return(RedirectToAction("Index"));
}
}
return(View());
}
public ActionResult Edit(P2K3 P2K3)
{
if (ModelState.IsValid)
{
string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;";
using (OracleConnection connection = new OracleConnection(connectionString))
{
string number = null;
number = "";
OracleCommand cmd2 = new OracleCommand();
cmd2.Connection = connection;
connection.Open();
if (P2K3.P2K3File != null)
{
byte[] tempFile = new byte[P2K3.P2K3File.InputStream.Length];
P2K3.P2K3File.InputStream.Read(tempFile, 0, tempFile.Length);
cmd2.CommandText = "Update KMIINTRANET_MASTER_P2K3 set P2K3_TITLE=:title,P2K3_INFO=:info,P2K3_FILE=:p2k3file,STATUS=:stat,MODIFY_BY='" + Session["USER"] + "',MODIFY_DATE=SYSDATE where P2K3_ID=:p2k3id";
cmd2.CommandType = CommandType.Text;
cmd2.Parameters.Add(":stat", OracleType.VarChar).Value = P2K3.stat.ToString();
cmd2.Parameters.Add(":newsfile", OracleType.Blob).Value = tempFile;
cmd2.Parameters.Add(":info", OracleType.VarChar).Value = P2K3.isi.ToString();
cmd2.Parameters.Add(":title", OracleType.VarChar).Value = P2K3.title.ToString();
cmd2.Parameters.Add(":p2k3id", OracleType.VarChar).Value = P2K3.idP2K3;
}
else
{
cmd2.CommandText = "Update KMIINTRANET_MASTER_P2K3 set P2K3_TITLE=:title,P2K3_INFO=:info,STATUS=:stat,MODIFY_BY='" + Session["USER"] + "',MODIFY_DATE=SYSDATE where P2K3_ID=:p2k3id";
cmd2.CommandType = CommandType.Text;
cmd2.Parameters.Add(":stat", OracleType.VarChar).Value = P2K3.stat.ToString();
cmd2.Parameters.Add(":info", OracleType.VarChar).Value = P2K3.isi.ToString();
cmd2.Parameters.Add(":title", OracleType.VarChar).Value = P2K3.title.ToString();
cmd2.Parameters.Add(":p2k3id", OracleType.VarChar).Value = P2K3.idP2K3;
}
cmd2.ExecuteNonQuery();
cmd2 = null;
connection.Close();
return(RedirectToAction("Index"));
}
}
return(View());
}
