public ActionResult insert(T12022 t12022, string t) { try { string u = Session["T_EMP_CODE"].ToString(); var data = repository.insert(t12022, t, u); 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)); } }
public string insert(T12022 t22, string t, string u) { string user = u; string msg = ""; obj.BeginTransaction(); if (t == "i") { if (obj.insert22(user, t22.T_PAT_NO, t22.T_EPISODE_NO, t22.T_REQUEST_ID, t22.T_SER_USE, t22.T_MAX_DIFFERED_DATE, t22.T_MAX_DIFFERED_DAY, t22.T_WEIGHT, t22.T_TEMPTURE, t22.T_HB, t22.T_PULS, t22.T_BP_HIGH, t22.T_BP_LOW, t22.T_REJECT_REASON, t22.REC_DIF_DAY, t22.T_COMMENT, t22.T_DIFFERED_DATE, t22.T_DIFFERED_STATUS, t22.T_ACCEPT_STATUS)) { obj.CommitTransaction(); msg = "Data Saved Successfully"; } else { obj.RollbackTransaction(); msg = "Data not Saved"; } } else if (t == "u") { if (obj.update22(user, t22.T_PAT_NO, t22.T_EPISODE_NO, t22.T_REQUEST_ID, t22.T_SER_USE, t22.T_MAX_DIFFERED_DATE, t22.T_MAX_DIFFERED_DAY, t22.T_WEIGHT, t22.T_TEMPTURE, t22.T_HB, t22.T_PULS, t22.T_BP_HIGH, t22.T_BP_LOW, t22.T_REJECT_REASON, t22.REC_DIF_DAY, t22.T_COMMENT, t22.T_DIFFERED_DATE, t22.T_DIFFERED_STATUS, t22.T_ACCEPT_STATUS, t22.T_VITAL_ID)) { obj.CommitTransaction(); msg = "Data Updated Successfully"; } else { obj.RollbackTransaction(); msg = "Data not Updated"; } } //if (isInsert) //{ // obj.CommitTransaction(); // if (t12071!=null) // { // i = t12071.Count; // obj.BeginTransaction(); // foreach (T12071 t71 in t12071) // { // isInsert71 = obj.update71(user, t71.T_QNO, t71.T_QNO_ANS, t71.T_QUES_ID, t22.T_REQUEST_ID, // t22.T_PAT_NO, t22.T_EPISODE_NO, t71.T_DIFFERAL_DAY); // a = isInsert71 ? a + 1 : a; // //{ obj.CommitTransaction(); } // //else { obj.RollbackTransaction(); } // } // if (a==i&&a>0) // { // obj.CommitTransaction(); // } // else // { // obj.RollbackTransaction(); // } // } //} //else //{ // obj.RollbackTransaction(); // msg = "Data not Saved"; //} return(msg); }