Example #1
0
        public static ResponseMsg editSegcodeGrid(string oper, string id, string seg_code, string program_code,
                                                  string buy_method, string include_in_bolt, string include_in_spo, string include_in_tav_reporting,
                                                  string site_location)
        {
            //Session Login Check
            if (HttpContext.Current.Session["Connection"] == null)
            {
                throw new Exception("Session State Timeout");
            }

            //Variables
            ResponseMsg result = new ResponseMsg();

            //Create request
            SegcodeEditRequest editRequest = new SegcodeEditRequest();

            editRequest.oper                     = oper.Trim().ToLower();
            editRequest.id                       = id.Trim().ToUpper();
            editRequest.seg_code                 = seg_code.Trim().ToUpper();
            editRequest.program_code             = program_code.Trim().ToUpper();
            editRequest.buy_method               = buy_method.Trim();
            editRequest.include_in_bolt          = include_in_bolt.Trim().ToUpper();
            editRequest.include_in_spo           = include_in_spo.Trim().ToUpper();
            editRequest.include_in_tav_reporting = include_in_tav_reporting.Trim().ToUpper();
            editRequest.site_location            = site_location.Trim();

            //Validate request input
            if (!editRequest._isValid())
            {
                //set error message
                result.addError("Your request to edit this segcode contains invalid input and was not saved.");

                //Return invalid request
                return(result);
            }

            //Edit database using request
            using (Interface db = new Interface())
            {
                try
                {
                    //Check if user has permissions to edit
                    if (!db.checkSegcodeEditPerm())
                    {
                        //set error message
                        result.addMsg("You do not have permission to edit segcodes.");

                        //Return request
                        return(result);
                    }
                }
                catch (Exception)
                {
                    //set error message
                    result.addError("Unable to verify permissions. Please try again or contact application support.");

                    //Return request
                    return(result);
                }

                //Perform action
                if (editRequest.oper == "edit")
                {
                    result = db.editSegcode(editRequest);
                }
                else if (editRequest.oper == "delete")
                {
                    result = db.deleteSegcode(editRequest);
                }
                else if (editRequest.oper == "new")
                {
                    result = db.newSegcode(editRequest);
                }
            }

            return(result);
        }