Exemplo n.º 1
0
 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);
        }