Ejemplo n.º 1
0
        public HttpResponseMessage UpdateServiceMaster(ServiceMasterUpdateDTO objServiceMaster)
        {
            HttpResponseMessage message;

            try
            {
                //   ServiceMasterDataAccessLayer dal = new ServiceMasterDataAccessLayer();
                var dynObj = new { result = _Service.UpdateServiceMaster(objServiceMaster) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = " Somthing wrong,try Again!" });
                ErrorLog.CreateErrorMessage(ex, "ServiceMaster", "UpdateServiceMaster");
            }
            return(message);
        }
        public bool UpdateServiceMaster(ServiceMasterUpdateDTO objServiceMater)
        {
            bool       res    = false;
            SqlCommand SqlCmd = new SqlCommand("spUpdateServices");

            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.Parameters.AddWithValue("@Id", objServiceMater.Id);
            SqlCmd.Parameters.AddWithValue("@Name", objServiceMater.Name);
            SqlCmd.Parameters.AddWithValue("@SACCode", objServiceMater.SACCode);
            SqlCmd.Parameters.AddWithValue("@EmployeeType", objServiceMater.EmployeeType);
            SqlCmd.Parameters.AddWithValue("@ModifiedBy", objServiceMater.ModifiedBy);
            SqlCmd.Parameters.AddWithValue("@Active", objServiceMater.Active);
            int result = new DbLayer().ExecuteNonQuery(SqlCmd);

            if (result != Int32.MaxValue)
            {
                res = true;
            }
            return(res);
        }