public string insertData(M01004 tM01004, string user)
{
//string msg = "";
//var dt = obj.CheckExistOrNot(tM01004);
//obj.BeginTransaction();
//if (dt.Rows.Count == 0)
//{
// if (obj.insertData(tM01004,user))
// {
// obj.CommitTransaction();
// msg = "Data Saved Successfully";
// }
// else
// {
// obj.RollbackTransaction();
// msg = "Data Not Saved";
// }
//}
//else if (dt.Rows.Count > 0)
//{
// if (obj.updateData(tM01004,user))
// {
// obj.CommitTransaction();
// msg = "Data Updated Successfully";
// }
// else
// {
// obj.RollbackTransaction();
// msg = "Data Not Updated";
// }
//}
string msg = "";
try
{
var dt = obj.CheckExistOrNot(tM01004);
obj.BeginTransaction();
if (dt.Rows.Count == 0)
{
if (obj.insertData(tM01004, user))
{
obj.CommitTransaction();
msg = "Data Saved Successfully";
}
else
{
obj.RollbackTransaction();
msg = "Data Not Saved";
}
}
else if (dt.Rows.Count > 0)
{
if (obj.updateData(tM01004, user))
{
obj.CommitTransaction();
msg = "Data Updated Successfully";
}
else
{
obj.RollbackTransaction();
msg = "Data Not Updated";
}
}
}
catch (Exception e)
{
MethodBase m = MethodBase.GetCurrentMethod();
obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message);
}
return(msg);
}
public bool insertData(M01004 tM01004, string user)
{
Command($"INSERT INTO T01004 ( T_ENTRY_USER,T_ENTRY_DATE,T_MSG_CODE,T_LANG1_MSG,T_LANG2_MSG) VALUES ('{user}',TRUNC(SYSDATE),'{tM01004.T_MSG_CODE}','{tM01004.T_LANG1_MSG}','{tM01004.T_LANG2_MSG}')");
return(true);
}
public bool updateData(M01004 tM01004, string user)
{
Command($"UPDATE T01004 SET T_UPD_USER='******',T_UPD_DATE=TRUNC(SYSDATE),T_LANG1_MSG='{tM01004.T_LANG1_MSG}',T_LANG2_MSG='{tM01004.T_LANG2_MSG}' WHERE T_MSG_CODE = '{tM01004.T_MSG_CODE}'");
return(true);
}
public DataTable CheckExistOrNot(M01004 tM01004)
{
return(Query($"Select * from T01004 where T_MSG_CODE = '{tM01004.T_MSG_CODE}'"));
}
