コード例 #1
0
        public HttpResponseMessage scheduleroutes([FromBody] ScheduleroutesModel objScheduleroutesModel)
        {
            objScheduleroutesDL.insert_scheduleroutes(objScheduleroutesModel);

            var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
                                                              new ResponseModel()
            {
                message = "scheduledroutes successfully", statuscode = Convert.ToInt16(HttpStatusCode.OK)
            });

            return(resp);
        }
コード例 #2
0
        public int insert_scheduleroutes(ScheduleroutesModel objscheduleroutes)
        {
            try
            {
                return(Execution.ExecuteNonQuery_with_result("sp_scheduleroutes", new SqlParameter[]
                {
                    new SqlParameter("@Command", "INSERT"),

                    new SqlParameter("@routeId", objscheduleroutes.routeid),
                    new SqlParameter("@driverid", objscheduleroutes.driverid),
                    new SqlParameter("@vehicleId", objscheduleroutes.vehicleId),

                    new SqlParameter("@status", 1),
                }));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }