public Reception_Register CreateNewReceptionRegister(int?personId, string reasonForVisit, int?receptionVisitTypeId, DateTime?visitDate, int?receptionActionTakenId, DateTime dateCreated, string createdBy, bool isActive, bool isDeleted)
        {
            Reception_Register newReceptionRegister;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                var receptionRegister = new Reception_Register()
                {
                    Person_Id                 = personId,
                    Reason_For_Visit          = reasonForVisit,
                    Reception_Visit_Type_Id   = receptionVisitTypeId,
                    Visit_Date                = visitDate,
                    Reception_Action_Taken_Id = receptionActionTakenId,
                    Date_Created              = dateCreated,
                    Created_By                = createdBy,
                    Is_Active                 = isActive,
                    Is_Deleted                = isDeleted
                };

                try
                {
                    newReceptionRegister = dbContext.Reception_Registers.Add(receptionRegister);
                    dbContext.SaveChanges();
                }
                catch (Exception)
                {
                    return(null);
                }
            }

            return(newReceptionRegister);
        }
        public Incident_Correspondence EditIncidentCorrespondence(int incidentCorrespondenceId, int incidentId, int correspondenceTypeId, DateTime dateCorrespondenceSent)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                var editincidentCorrespondence = (from a in dbContext.Incident_Correspondence_Items
                                                  where a.Incident_Correspondence_Id.Equals(incidentCorrespondenceId)
                                                  select a).FirstOrDefault();

                if (editincidentCorrespondence == null)
                {
                    return(null);
                }

                editincidentCorrespondence.Incident_Id              = incidentId;
                editincidentCorrespondence.Correspondence_Type_Id   = correspondenceTypeId;
                editincidentCorrespondence.Date_Correspondence_Sent = dateCorrespondenceSent;

                dbContext.SaveChanges();

                return(editincidentCorrespondence);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Example #3
0
        public NISIS_Profiling_Instance_Referral UpdateProfilingInstanceReferral(int profilingInstanceReferralId, int serviceStatusId)
        {
            NISIS_Profiling_Instance_Referral editReferral;

            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                editReferral = (from e in dbContext.NISIS_Profiling_Instance_Referrals
                                where e.NISIS_Household_Referral_Id.Equals(profilingInstanceReferralId)
                                select e).FirstOrDefault();

                if (editReferral == null)
                {
                    return(null);
                }

                editReferral.Service_Status_Id = serviceStatusId;

                dbContext.SaveChanges();
            }
            catch (Exception)
            {
                return(null);
            }

            return(editReferral);
        }
Example #4
0
        public Organization CreateOrganization(string description, string telephoneNumber, string faxNumber, string emailAddress, bool isActive, bool isDeleted, DateTime dateCreated, string createdBy)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            var organization = new Organization()
            {
                Description      = description,
                Telephone_Number = telephoneNumber,
                Fax_Number       = faxNumber,
                Email_Address    = emailAddress,
                Is_Active        = isActive,
                Is_Deleted       = isDeleted,
                Date_Created     = dateCreated,
                Created_By       = createdBy
            };

            try
            {
                var newOrganization = dbContext.Organizations.Add(organization);

                dbContext.SaveChanges();

                return(newOrganization);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Example #5
0
        public Organization SetOrganizationIsDeleted(int organizationId, bool isDeleted)
        {
            Organization editOrganization;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                try
                {
                    editOrganization = (from e in dbContext.Organizations
                                        where e.Organization_Id.Equals(organizationId)
                                        select e).FirstOrDefault();

                    if (editOrganization == null)
                    {
                        return(null);
                    }

                    editOrganization.Is_Deleted = isDeleted;

                    dbContext.SaveChanges();
                }
                catch (Exception)
                {
                    return(null);
                }
            }

            return(editOrganization);
        }
Example #6
0
        public Address EditAddress(int addressId, int addressTypeId, string addressLine1, string addressLine2, int?townId, string postalCode)
        {
            Address editAddress;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                editAddress = (from a in dbContext.Addresses
                               where a.Address_Id.Equals(addressId)
                               select a).FirstOrDefault();

                if (editAddress == null)
                {
                    return(null);
                }

                editAddress.Address_Type_Id = addressTypeId;
                editAddress.Address_Line_1  = addressLine1;
                editAddress.Address_Line_2  = addressLine2;
                editAddress.Town_Id         = townId;
                editAddress.Postal_Code     = postalCode;

                dbContext.SaveChanges();
            }

            return(editAddress);
        }
Example #7
0
        public CYCA_Dynamic_Form_Data AddOrUpdateDynamicFormDatas(CYCA_Dynamic_Form_Data data)
        {
            CYCA_Dynamic_Form_Data record = dbContext.CYCA_Dynamic_Form_Data.Where(d => d.Dynamic_Form_Data_Id == data.Dynamic_Form_Data_Id).SingleOrDefault();

            if (record == null)
            {
                record = new CYCA_Dynamic_Form_Data()
                {
                    Client_Id       = data.Client_Id,
                    CreatedDate     = data.CreatedDate,
                    Data            = data.Data,
                    Dynamic_Form_Id = data.Dynamic_Form_Id,
                    User_Id         = data.User_Id,
                    Venue_Id        = data.Venue_Id
                };
                dbContext.CYCA_Dynamic_Form_Data.Add(record);

                //dbContext.SaveChanges();
                data.Dynamic_Form_Data_Id = record.Dynamic_Form_Data_Id;
            }
            else
            {
                record.Data = data.Data;
            }
            dbContext.SaveChanges();

            return(data);
        }
Example #8
0
        public Questionnaire_Section SetQuestionnaireSectionIsActive(int sectionId, bool isActive)
        {
            Questionnaire_Section editSection;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                try
                {
                    editSection = (from x in dbContext.Questionnaire_Sections
                                   where x.Questionnaire_Section_Id.Equals(sectionId)
                                   select x).FirstOrDefault();

                    if (editSection == null)
                    {
                        return(null);
                    }

                    editSection.Is_Active = isActive;

                    dbContext.SaveChanges();
                }
                catch (Exception)
                {
                    return(null);
                }
            }

            return(editSection);
        }
Example #9
0
        public Intake_Assessment AcceptVEPCase(int intakeAssessmentId)
        {
            Intake_Assessment editIntakeAssessment;

            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                editIntakeAssessment = dbContext.Intake_Assessments.SingleOrDefault(a => a.Intake_Assessment_Id == intakeAssessmentId);

                if (editIntakeAssessment == null)
                {
                    return(null);
                }

                editIntakeAssessment.Treatment_Date = DateTime.Now;

                dbContext.SaveChanges();
            }
            catch (Exception)
            {
                return(null);
            }

            return(editIntakeAssessment);
        }
Example #10
0
        public VEP_Referals EditReferralDetails(int referralId, string referralNotes, int?referralTypeId)
        {
            VEP_Referals editReferralDetails;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                try
                {
                    editReferralDetails = (from p in dbContext.VEP_Referals
                                           where p.ReferalsId.Equals(referralId)
                                           select p).FirstOrDefault();

                    if (editReferralDetails == null)
                    {
                        return(null);
                    }

                    editReferralDetails.ReferalsId   = referralId;
                    editReferralDetails.Notes        = referralNotes.Trim();
                    editReferralDetails.ToDepartment = referralTypeId.Value;

                    dbContext.SaveChanges();
                }
                catch (Exception)
                {
                    return(null);
                }
            }

            return(editReferralDetails);
        }
Example #11
0
        public Service_Office CreateServiceOffice(string Description, string Municipality, string UserName)
        {
            var dbContext = new SDIIS_DatabaseEntities();
            int munId     = (from a in dbContext.Local_Municipalities
                             where a.Description == Municipality
                             select a.Local_Municipality_Id).FirstOrDefault();
            var service_Office = new Service_Office()
            {
                Description           = Description,
                Local_Municipality_Id = munId,

                Is_Active    = true,
                Is_Deleted   = false,
                Date_Created = DateTime.Now,
                Created_By   = UserName
            };

            try
            {
                var newService_Office = dbContext.Service_Offices.Add(service_Office);

                dbContext.SaveChanges();

                return(newService_Office);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Example #12
0
        public VEP_Referals CreateReferrals(VEP_Referals model)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                VEP_Referals referalTable = new VEP_Referals();

                referalTable.CaseId         = model.CaseId;
                referalTable.FromDepartment = 1;
                referalTable.ToDepartment   = Convert.ToInt32(model.ToDepartment);
                referalTable.Notes          = model.Notes;
                referalTable.Createdby      = model.Createdby;
                referalTable.CreateDate     = DateTime.Now;

                dbContext.VEP_Referals.Add(referalTable);
                dbContext.SaveChanges();

                return(model);
            }
            catch (Exception ex)
            {
                var Test = ex.Message;
                return(null);
            }
        }
Example #13
0
        public Questionnaire EditQuestionnaire(int questionnaireId, int profilingToolId, string description, bool isActive, bool isDeleted, DateTime?dateLastModified, string modifiedBy)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                var editQuestionnaire = (from x in dbContext.Questionnaires
                                         where x.Questionnaire_Id.Equals(questionnaireId)
                                         select x).FirstOrDefault();

                if (editQuestionnaire == null)
                {
                    return(null);
                }

                editQuestionnaire.Profiling_Tool_Id  = profilingToolId;
                editQuestionnaire.Description        = description;
                editQuestionnaire.Is_Active          = isActive;
                editQuestionnaire.Is_Deleted         = isDeleted;
                editQuestionnaire.Date_Last_Modified = dateLastModified;
                editQuestionnaire.Modified_By        = modifiedBy;

                dbContext.SaveChanges();

                return(editQuestionnaire);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Example #14
0
        public Questionnaire CreateQuestionnaire(int profilingToolId, string description, bool isActive, bool isDeleted, DateTime dateCreated, string createdBy)
        {
            Questionnaire newQuestionnaire;

            var dbContext = new SDIIS_DatabaseEntities();

            var questionnaire = new Questionnaire()
            {
                Profiling_Tool_Id = profilingToolId,
                Description       = description,
                Is_Active         = isActive,
                Is_Deleted        = isDeleted,
                Date_Created      = dateCreated,
                Created_By        = createdBy
            };

            try
            {
                newQuestionnaire = dbContext.Questionnaires.Add(questionnaire);
                dbContext.SaveChanges();
            }
            catch (Exception ex)
            {
                return(null);
            }

            return(newQuestionnaire);
        }
Example #15
0
        public CPR_Incident AssignReferenceNumber(int incidentId, string referenceNumber)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                var editIncident = (from i in dbContext.CPR_Incidents
                                    where i.Incident_Id.Equals(incidentId)
                                    select i).FirstOrDefault();

                if (editIncident == null)
                {
                    return(null);
                }

                editIncident.Reference_Number = referenceNumber;

                dbContext.SaveChanges();

                return(editIncident);
            }
            catch (Exception ex)
            {
                return(null);
            }
        }
Example #16
0
        public Intake_Assessment AssignCaseManager(int intakeAssessmentId, int caseManagerId)
        {
            Intake_Assessment editIntakeAssessment;

            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                editIntakeAssessment = (from e in dbContext.Intake_Assessments
                                        where e.Intake_Assessment_Id.Equals(intakeAssessmentId)
                                        select e).FirstOrDefault();

                if (editIntakeAssessment == null)
                {
                    return(null);
                }

                editIntakeAssessment.Case_Manager_Id = caseManagerId;

                dbContext.SaveChanges();
            }
            catch (Exception)
            {
                return(null);
            }

            return(editIntakeAssessment);
        }
Example #17
0
        public CPR_Incident AddAbuseIndicatorsToIncident(int incidentId, List <int> abuseIndicatorIds)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                var incidentToEdit = dbContext.CPR_Incidents.FirstOrDefault(x => x.Incident_Id.Equals(incidentId));
                if (incidentToEdit == null)
                {
                    return(null);
                }

                incidentToEdit.Abuse_Indicators.Clear();

                foreach (var abuseIndicatorId in abuseIndicatorIds)
                {
                    var indicatorToAdd = dbContext.Abuse_Indicators.FirstOrDefault(x => x.Abuse_Indicator_Id.Equals(abuseIndicatorId));
                    if (indicatorToAdd == null)
                    {
                        return(null);
                    }

                    incidentToEdit.Abuse_Indicators.Add(indicatorToAdd);
                }

                dbContext.SaveChanges();

                return(incidentToEdit);
            }
            catch (Exception ex)
            {
                return(null);
            }
        }
Example #18
0
        public Intake_Assessment AddReferralFocusAreaToIntakeAssessment(int intakeAssessmentId, List <int> referralFocusAreaIds)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                var intakeAssessmentToEdit = dbContext.Intake_Assessments.FirstOrDefault(x => x.Intake_Assessment_Id.Equals(intakeAssessmentId));
                if (intakeAssessmentToEdit == null)
                {
                    return(null);
                }

                intakeAssessmentToEdit.Referral_Focus_Areas.Clear();

                foreach (var roleId in referralFocusAreaIds)
                {
                    var focusAreaToAdd = dbContext.Referral_Focus_Areas.FirstOrDefault(x => x.Referral_Focus_Area_Id.Equals(roleId));
                    if (focusAreaToAdd == null)
                    {
                        return(null);
                    }

                    intakeAssessmentToEdit.Referral_Focus_Areas.Add(focusAreaToAdd);
                }

                dbContext.SaveChanges();

                return(intakeAssessmentToEdit);
            }
            catch (Exception ex)
            {
                return(null);
            }
        }
        public Client_Foster_Parent EditClientFosterParent(int itemId, int personId, bool?isDeceased, DateTime?dateDeceased, DateTime dateLastModified, string modifiedBy, bool isActive, bool isDeleted)
        {
            Client_Foster_Parent editFosterParent;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                try
                {
                    editFosterParent = (from a in dbContext.Client_Foster_Parents
                                        where a.Client_Foster_Parent_Id.Equals(itemId)
                                        select a).FirstOrDefault();

                    if (editFosterParent == null)
                    {
                        return(null);
                    }

                    editFosterParent.Person_Id          = personId;
                    editFosterParent.Is_Deceased        = isDeceased;
                    editFosterParent.Date_Deceased      = dateDeceased;
                    editFosterParent.Is_Active          = isActive;
                    editFosterParent.Is_Deleted         = isDeleted;
                    editFosterParent.Date_Last_Modified = dateLastModified;
                    editFosterParent.Modified_By        = modifiedBy;

                    dbContext.SaveChanges();
                }
                catch (Exception)
                {
                    return(null);
                }
            }

            return(editFosterParent);
        }
Example #20
0
        public void UpdateReferalToCouncelling(PCMReferralsViewModel vm, int userId, int Referrals_Councelling_Id)
        {
            using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
            {
                try
                {
                    PCM_Referral_Counselling ass = db.PCM_Referral_Counselling.Find(Referrals_Councelling_Id);

                    //cases.PCM_Case_Id = cas
                    ass.Referrals_Id     = vm.Referrals_Id;
                    ass.Type_Referral_Id = vm.Type_Referral_Id;
                    ass.Referral_of_Child_To_Counselling = vm.Referral_of_Child_To_Counselling;
                    ass.Period_From    = vm.Period_From;
                    ass.Period         = vm.Period_To;
                    ass.Child_Progress = vm.Progress_Report;
                    ass.Modified_By    = userId;
                    ass.Date_Modified  = DateTime.Now;


                    db.SaveChanges();
                }
                catch
                {
                }
            }
        }
Example #21
0
        public CPR_First_Reporter EditCPRFirstReporter(int cprFirstReporterId, int incidentId, int personId, int?districtId, int?childRelationTypeId)
        {
            CPR_First_Reporter editCPRFirstReporter;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                try
                {
                    editCPRFirstReporter = (from a in dbContext.CPR_First_Reporters
                                            where a.CPR_First_Reporter_Id.Equals(cprFirstReporterId)
                                            select a).FirstOrDefault();

                    if (editCPRFirstReporter == null)
                    {
                        return(null);
                    }

                    editCPRFirstReporter.Incident_Id = incidentId;
                    editCPRFirstReporter.Person_Id   = personId;
                    editCPRFirstReporter.District_Id = districtId;
                    editCPRFirstReporter.Child_Relationship_Type_Id = childRelationTypeId;

                    dbContext.SaveChanges();
                }
                catch (Exception)
                {
                    return(null);
                }
            }

            return(editCPRFirstReporter);
        }
Example #22
0
        public void UpdateReferalToSocialWorker(PCMReferralsViewModel vm, int userId, int Referrals_SocilaWorker_Id)
        {
            using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
            {
                try
                {
                    PCM_Referral_SocilaWorker ass = db.PCM_Referral_SocilaWorker.Find(Referrals_SocilaWorker_Id);

                    //cases.PCM_Case_Id = cas
                    ass.Referrals_Id     = vm.Referrals_Id;
                    ass.Type_Referral_Id = vm.Type_Referral_Id;
                    ass.Referral_Child_To_Social_Worker = vm.Referral_Child_To_Social_Worker;
                    ass.Programme_Period_From           = vm.Period_From;
                    ass.Programme_Period = vm.Period_To;
                    ass.Child_Progress   = vm.Progress_Report;
                    ass.Modified_By      = userId;
                    ass.Date_Modified    = DateTime.Now;


                    db.SaveChanges();
                }
                catch
                {
                }
            }
        }
Example #23
0
        public Organization EditOrganization(int organizationId, string description, string telephoneNumber, string faxNumber, string emailAddress, bool isActive, bool isDeleted, DateTime dateLastModified, string modifiedBy)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                var editOrganization = (from mc in dbContext.Organizations
                                        where mc.Organization_Id.Equals(organizationId)
                                        select mc).FirstOrDefault();

                if (editOrganization == null)
                {
                    return(null);
                }

                editOrganization.Description        = description;
                editOrganization.Telephone_Number   = telephoneNumber;
                editOrganization.Fax_Number         = faxNumber;
                editOrganization.Email_Address      = emailAddress;
                editOrganization.Is_Active          = isActive;
                editOrganization.Is_Deleted         = isDeleted;
                editOrganization.Date_Last_Modified = dateLastModified;
                editOrganization.Modified_By        = modifiedBy;

                dbContext.SaveChanges();

                return(editOrganization);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Example #24
0
        public Person UpdateNISISData(int personId, string firstName, string lastName, string idNumber, int?maritalStatusId)
        {
            Person editPerson;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                try
                {
                    editPerson = (from p in dbContext.Persons
                                  where p.Person_Id.Equals(personId)
                                  select p).FirstOrDefault();

                    if (editPerson == null)
                    {
                        return(null);
                    }

                    editPerson.First_Name            = firstName;
                    editPerson.Last_Name             = lastName;
                    editPerson.Identification_Number = idNumber;
                    editPerson.Marital_Status_Id     = maritalStatusId;

                    dbContext.SaveChanges();
                }
                catch (Exception ex)
                {
                    return(null);
                }
            }

            return(editPerson);
        }
Example #25
0
        public Questionnaire_Question SetQuestionnaireQuestionIsDeleted(int questionId, bool isDeleted)
        {
            Questionnaire_Question editQuestion;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                try
                {
                    editQuestion = (from x in dbContext.Questionnaire_Questions
                                    where x.Questionnaire_Question_Id.Equals(questionId)
                                    select x).FirstOrDefault();

                    if (editQuestion == null)
                    {
                        return(null);
                    }

                    editQuestion.Is_Deleted = isDeleted;

                    dbContext.SaveChanges();
                }
                catch (Exception)
                {
                    return(null);
                }
            }

            return(editQuestion);
        }
        public Community_Profiling_Instance CreateCommunityProfilingInstance(DateTime profilingDate, int profilingToolId, int capturedByUserId, int siteEAId, string createdBy, DateTime createdDate, bool isActive, bool isDeleted)
        {
            Community_Profiling_Instance newCommunityProfilingInstance;

            var dbContext = new SDIIS_DatabaseEntities();

            var communityProfilingInstance = new Community_Profiling_Instance()
            {
                Profiling_Date     = profilingDate,
                Profiling_Tool_Id  = profilingToolId,
                Captured_By_UserId = capturedByUserId,
                NISIS_Site_EA_Id   = siteEAId,
                QA_Status_Item_Id  = (int)QAStatusEnum.NotSet,
                Created_By         = createdBy,
                Date_Created       = createdDate,
                Is_Active          = isActive,
                Is_Deleted         = isDeleted
            };

            try
            {
                newCommunityProfilingInstance = dbContext.Community_Profiling_Instances.Add(communityProfilingInstance);
                dbContext.SaveChanges();
            }
            catch (Exception ex)
            {
                var exMsg = ex.Message;
                return(null);
            }

            return(newCommunityProfilingInstance);
        }
        public Incident_Correspondence CreateIncidentCorrespondence(int incidentId, int correspondenceTypeId, DateTime dateCorrespondenceSent)
        {
            Incident_Correspondence newIncidentCorrespondence;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                var incidentCorrespondence = new Incident_Correspondence()
                {
                    Incident_Id              = incidentId,
                    Correspondence_Type_Id   = correspondenceTypeId,
                    Date_Correspondence_Sent = dateCorrespondenceSent
                };

                try
                {
                    newIncidentCorrespondence = dbContext.Incident_Correspondence_Items.Add(incidentCorrespondence);
                    dbContext.SaveChanges();
                }
                catch (Exception ex)
                {
                    string exVal = ex.Message;
                    return(null);
                }
            }

            return(newIncidentCorrespondence);
        }
        public Community_Profiling_Instance SetCommunityProfilingInstanceQAStatus(int communityProfilingInstanceId, int qaStatusId)
        {
            Community_Profiling_Instance editCommunityProfilingInstance;

            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                editCommunityProfilingInstance = (from x in dbContext.Community_Profiling_Instances
                                                  where x.Community_Profiling_Instance_Id.Equals(communityProfilingInstanceId)
                                                  select x).FirstOrDefault();

                if (editCommunityProfilingInstance == null)
                {
                    return(null);
                }

                editCommunityProfilingInstance.QA_Status_Item_Id = qaStatusId;

                dbContext.SaveChanges();
            }
            catch (Exception)
            {
                return(null);
            }

            return(editCommunityProfilingInstance);
        }
Example #29
0
        public int Create(int selected_SpecialNeedId, int personId)
        {
            var dbContext = new SDIIS_DatabaseEntities();

            try
            {
                var personSpecialNeedRecord = new Int_Person_SpecialNeed();

                personSpecialNeedRecord.Person_Id      = personId;
                personSpecialNeedRecord.SpecialNeed_Id = selected_SpecialNeedId;

                dbContext.Int_Person_SpecialNeed.Add(personSpecialNeedRecord);
                dbContext.SaveChanges();

                return(personSpecialNeedRecord.Person_SpecialNeed_Id);
            }
            //catch (Exception ex)
            //{
            //    return -1;
            //}
            catch (DbEntityValidationException ex)
            {
                foreach (var entityValidationErrors in ex.EntityValidationErrors)
                {
                    foreach (var validationError in entityValidationErrors.ValidationErrors)
                    {
                        //Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
                        var msg = validationError.PropertyName + " Error: " + validationError.ErrorMessage;
                    }
                }
            }
            return(-1);
        }
Example #30
0
        public CPR_Conviction CreateCPRConviction(int allegedOffenderId, string j14ReferenceNumber, string sapsCaseNumber, int?courtId, string conviction, string natureOfCharge, string sentence, DateTime?dateSentenced, string accountOfCharge)
        {
            CPR_Conviction newConviction;

            using (var dbContext = new SDIIS_DatabaseEntities())
            {
                var cprConviction = new CPR_Conviction()
                {
                    Alleged_Offender_Id              = allegedOffenderId,
                    J14_Reference_Number             = j14ReferenceNumber,
                    SAPS_Case_Number                 = sapsCaseNumber,
                    Court_Id                         = courtId,
                    Conviction                       = conviction,
                    Nature_Of_Charge                 = natureOfCharge,
                    Sentence                         = sentence,
                    Date_Sentenced                   = dateSentenced,
                    Account_Of_Charge_And_Conviction = accountOfCharge
                };

                try
                {
                    newConviction = dbContext.CPR_Convictions.Add(cprConviction);
                    dbContext.SaveChanges();
                }
                catch (Exception ex)
                {
                    string exVal = ex.Message;
                    return(null);
                }
            }

            return(newConviction);
        }