public int singleInsert(T12071 t71)
{
int msg = 0;
obj.BeginTransaction();
if (t71.T_QUES_ID == 0)
{
int res = obj.insertSingleQues71(t71.T_ENTRY_USER, t71.T_ENTRY_TIME, t71.T_DONOR_ID,
t71.T_DONOR_PATNO,
t71.T_DONOR_EPISODE, t71.T_QNO, t71.T_QNO_ANS, t71.T_QHEAD_NO, t71.T_DISP_SEQ,
t71.T_DIFFERAL_DAY,
t71.T_REQUEST_ID);
if (res > 0)
{
obj.CommitTransaction();
msg = res;
}
else
{
obj.RollbackTransaction();
}
}
else
{
if (obj.updateSingleQues71(t71.T_UPD_USER, t71.T_QNO, t71.T_QNO_ANS, t71.T_QUES_ID,
t71.T_REQUEST_ID, t71.T_DONOR_PATNO, t71.T_DONOR_EPISODE, t71.T_DIFFERAL_DAY))
{
obj.CommitTransaction();
msg = t71.T_QUES_ID;
}
else
{
obj.RollbackTransaction();
}
}
return(msg);
}
public ActionResult singleInsert(T12071 t71)
{
try
{
t71.T_ENTRY_USER = Session["T_EMP_CODE"].ToString();
t71.T_ENTRY_TIME = DateTime.Now.TimeOfDay.Hours + DateTime.Now.TimeOfDay.Minutes.ToString();
t71.T_UPD_USER = Session["T_EMP_CODE"].ToString();
var data = repository.singleInsert(t71);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(data);
return(Json(JSONString, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
err.SetServerErrorLog(ControllerContext.RouteData.Values["controller"].ToString(),
ControllerContext.RouteData.Values["action"].ToString(),
Session["T_ENTRY_USER"] == null ? "" : Session["T_ENTRY_USER"].ToString(), e.Message);
return(Json(e.Message, JsonRequestBehavior.AllowGet));
}
}
