public async Task <ActionResult> Post([FromBody] CreateMemo command)
{
if (User.Identity.IsAuthenticated)
{
command.UserId = Guid.Parse(User.Identity.Name);
command.MemoId = Guid.NewGuid();
await _memoService.CreateAsync(command.MemoId, command.Name, command.Description, command.UserId);
}
return(Created($"memos/{command.MemoId}", null));
}
public ActionResult Create(CreateMemo Memo)
{
if (ModelState.IsValid)
{
string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;";
string MEMO_ID,AUTORIZE_DETAIL;
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (Memo.Autorize.ToString() == "Department")
{
AUTORIZE_DETAIL = Memo.Autorize_detail;
}
else
{
AUTORIZE_DETAIL = "";
}
string number = null;
number = "";
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select nvl(max(substr(MEMO_ID,7,3)),0) from KMIINTRANET_MASTER_MEMO where substr(MEMO_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();
MEMO_ID = Convert.ToDateTime(System.DateTime.Now).ToString("yyyyMM") + number;
byte[] tempFile = new byte[Memo.MemoFile.InputStream.Length];
Memo.MemoFile.InputStream.Read(tempFile, 0, tempFile.Length);
cmd2.CommandText = "INSERT INTO KMIINTRANET_MASTER_MEMO(MEMO_ID,MEMO_THEME,AUTORIZE,AUTORIZE_DETAIL,MEMO_FILE,VALID_FROM,VALID_UNTIL,CREATE_BY,CREATE_DATE) VALUES (:memoid,:theme,:autorize,:detail,:memofile,:validfrom,:validuntil,'" + Session["USER"] + "',sysdate)";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
connection.Open();
cmd2.Parameters.Add(":memofile", OracleType.Blob).Value = tempFile;
cmd2.Parameters.Add(":validuntil", OracleType.DateTime).Value = Memo.ValidUntil.ToString("MM/dd/yyyy");
cmd2.Parameters.Add(":validfrom", OracleType.DateTime).Value = Memo.ValidFrom.ToString("MM/dd/yyyy");
cmd2.Parameters.Add(":detail", OracleType.VarChar).Value = AUTORIZE_DETAIL;
cmd2.Parameters.Add(":autorize", OracleType.VarChar).Value = Memo.Autorize.ToString();
cmd2.Parameters.Add(":theme", OracleType.VarChar).Value = Memo.Theme.ToString();
cmd2.Parameters.Add(":memoid", OracleType.VarChar).Value = MEMO_ID;
cmd2.ExecuteNonQuery();
cmd2 = null;
connection.Close();
return RedirectToAction("Index");
}
}
return View();
}
public ActionResult Create(CreateMemo Memo)
{
if (ModelState.IsValid)
{
string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;";
string MEMO_ID, AUTORIZE_DETAIL;
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (Memo.Autorize.ToString() == "Department")
{
AUTORIZE_DETAIL = Memo.Autorize_detail;
}
else
{
AUTORIZE_DETAIL = "";
}
string number = null;
number = "";
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select nvl(max(substr(MEMO_ID,7,3)),0) from KMIINTRANET_MASTER_MEMO where substr(MEMO_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();
MEMO_ID = Convert.ToDateTime(System.DateTime.Now).ToString("yyyyMM") + number;
byte[] tempFile = new byte[Memo.MemoFile.InputStream.Length];
Memo.MemoFile.InputStream.Read(tempFile, 0, tempFile.Length);
cmd2.CommandText = "INSERT INTO KMIINTRANET_MASTER_MEMO(MEMO_ID,MEMO_THEME,AUTORIZE,AUTORIZE_DETAIL,MEMO_FILE,VALID_FROM,VALID_UNTIL,CREATE_BY,CREATE_DATE) VALUES (:memoid,:theme,:autorize,:detail,:memofile,:validfrom,:validuntil,'" + Session["USER"] + "',sysdate)";
cmd2.CommandType = CommandType.Text;
cmd2.Connection = connection;
connection.Open();
cmd2.Parameters.Add(":memofile", OracleType.Blob).Value = tempFile;
cmd2.Parameters.Add(":validuntil", OracleType.DateTime).Value = Memo.ValidUntil.ToString("MM/dd/yyyy");
cmd2.Parameters.Add(":validfrom", OracleType.DateTime).Value = Memo.ValidFrom.ToString("MM/dd/yyyy");
cmd2.Parameters.Add(":detail", OracleType.VarChar).Value = AUTORIZE_DETAIL;
cmd2.Parameters.Add(":autorize", OracleType.VarChar).Value = Memo.Autorize.ToString();
cmd2.Parameters.Add(":theme", OracleType.VarChar).Value = Memo.Theme.ToString();
cmd2.Parameters.Add(":memoid", OracleType.VarChar).Value = MEMO_ID;
cmd2.ExecuteNonQuery();
cmd2 = null;
connection.Close();
return(RedirectToAction("Index"));
}
}
return(View());
}
