Beispiel #1
0
 public ActionResult AddOriginalDocket(RequestOriginalDocket request)
 {
     if (_requestRepository.AddOriginalDocketNoAsync(request))
     {
         return(new JsonErrorResult(new { Message = "Docket No Updated" }, HttpStatusCode.OK));
     }
     else
     {
         return(new JsonErrorResult(new { Message = "Docket No Updation Failed" }, HttpStatusCode.NotFound));
     }
 }
Beispiel #2
0
        public bool AddOriginalDocketNoAsync(RequestOriginalDocket originalDocket)
        {
            List <SqlParameter> parms = new List <SqlParameter>
            {
                new SqlParameter {
                    ParameterName = AddDocketStoredProcedure.StoredProcedureParameters[0].ToString(),
                    Value         = originalDocket.RequestNo.AsDbValue()
                },
                new SqlParameter {
                    ParameterName = AddDocketStoredProcedure.StoredProcedureParameters[1].ToString(),
                    Value         = originalDocket.DocketNo.AsDbValue()
                },
                new SqlParameter {
                    ParameterName = AddDocketStoredProcedure.StoredProcedureParameters[2].ToString(),
                    Value         = originalDocket.LuUser.AsDbValue()
                }
            };

            return(_tcContext.Set <BoolReturn>().FromSqlRaw(AddDocketStoredProcedure.Sql, parms.ToArray()).AsEnumerable().First().Value);
        }