Example #1
0
        public ActionResult Save(SeminarRegistration data)
        {
            PureJson result = new PureJson();
            if (string.IsNullOrEmpty(data.firstName))
            {
                using (SPJsonObject jRoot = new SPJsonObject(new JsonKeyValueWriter(result.StringBuilder)))
                {
                    jRoot.Add("Status", 1);
                }
                return new SimpleJsonResult(result);
            }
            else if (string.IsNullOrEmpty(data.lastName))
            {
                using (SPJsonObject jRoot = new SPJsonObject(new JsonKeyValueWriter(result.StringBuilder)))
                {
                    jRoot.Add("Status", 2);
                }
                return new SimpleJsonResult(result);
            }
            else if (string.IsNullOrEmpty(data.userOIB))
            {
                using (SPJsonObject jRoot = new SPJsonObject(new JsonKeyValueWriter(result.StringBuilder)))
                {
                    jRoot.Add("Status", 3);
                }
                return new SimpleJsonResult(result);
            }
            Database.SeminarRegistrationSave(data);

            using (SPJsonObject jRoot = new SPJsonObject(new JsonKeyValueWriter(result.StringBuilder)))
            {
                jRoot.Add("Status", 0);
            }
            return new SimpleJsonResult(result);
        }
Example #2
0
        public int SeminarRegistrationSave(SeminarRegistration input)
        {
            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew))
            {
                using (DbCommand command = GetCommand("tblSeminarRegistration_save"))
                {
                    SetParameterValue(command, "@userOIB", input.userOIB);
                    SetParameterValue(command, "@firstName", input.firstName);
                    SetParameterValue(command, "@lastName", input.lastName);
                    SetParameterValue(command, "@academicDegree", input.academicDegree);
                    SetParameterValue(command, "@academicTitle", input.academicTitle);
                    SetParameterValue(command, "@dateOfBirth", input.dateOfBirth);
                    SetParameterValue(command, "@placeOfBirth", input.placeOfBirth);
                    SetParameterValue(command, "@address", input.address);
                    SetParameterValue(command, "@ZIP", input.ZIP);
                    SetParameterValue(command, "@city", input.city);
                    SetParameterValue(command, "@email", input.email);
                    SetParameterValue(command, "@telephone", input.telephone);
                    SetParameterValue(command, "@mobile", input.mobile);
                    SetParameterValue(command, "@companyName", input.companyName);
                    SetParameterValue(command, "@companyPhone", input.companyPhone);
                    SetParameterValue(command, "@companyMob", input.companyMob);
                    SetParameterValue(command, "@companyFax", input.companyFax);
                    SetParameterValue(command, "@companyAddress", input.companyAddress);
                    SetParameterValue(command, "@companyZIP", input.companyZIP);
                    SetParameterValue(command, "@companyCity", input.companyCity);
                    SetParameterValue(command, "@companyOIB", input.companyOIB);
                    SetParameterValue(command, "@companyWorkPosition", input.companyWorkPosition);
                    SetParameterValue(command, "@seminarList", input.seminarList);

                    ExecuteNonQuery(command);
                }
                scope.Complete();
            }
            return 0;
        }