private string Submit(string id) { string message; try { if (CommonFunctions.CheckIfUserExists(id, id,out message, "GU")) { using (var dataContext = new nChangerDb()) { var user = dataContext.Users.FirstOrDefault( u => u.Email.ToLower().Equals(id) || u.UserId.ToLower().Equals(id)); if (user != null) { user.VerificationCode = Guid.NewGuid().ToString().ToLower(); dataContext.Users.AddOrUpdate(user); dataContext.SaveChanges(); if (SendRecoveryMail(user)) message = "An email has been sent to you with instructions to reset your password."; else message = "There was a problem sending recovery email. Please try again in some time or contact administrator."; } } } } catch (Exception ex) { message = ex.Message; } return message; }
public bool Submit(out string returnMessage) { returnMessage = string.Empty; var success = true; try { var message = string.Empty; if (CommonFunctions.CheckIfUserExists(txtEmailId.Text, txtUserId.Text, out message,"GU")) { returnMessage = message; return false; } using (var dataContext = new nChangerDb()) { var dbEntry = new User { Id = Guid.NewGuid(), UserTypeId="GU", UserId = txtUserId.Text, Email = txtEmailId.Text, Password = txtPassword.Text, FirstName = txtFirstName.Text, MiddleName = txtMiddleName.Text, LastName = txtLastName.Text, Phone = txtPhone.Text, City = txtCity.Text, State = ddlState.SelectedIndex == -1 ? txtState.Text : ddlState.SelectedValue, Zip = txtZipCode.Text, Country = ddlCountry.SelectedValue, Address = txtAddressLine1.Text, Address2 = txtAddressLine2.Text, IP = CommonFunctions.GetIpAddress(), IsActive = false, EmailVerified = false, VerificationCode = Guid.NewGuid().ToString(), RegistrationDate = DateTime.Now }; dataContext.Users.Add(dbEntry); dataContext.SaveChanges(); _queryId = dbEntry.UserId; AddUserPackage(_queryId); returnMessage = SendRegistrationMail(dbEntry) ? "SUCCESS" : "MAIL_ERROR"; } } catch (DbEntityValidationException ex) { success = false; returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors).Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } return success; }
protected void btnSubmit_OnClick(object sender, EventArgs e) { try { divMsg.InnerText = Submit(); var sections = Sections; var page = Path.GetFileName(Request.PhysicalPath); var curret = Sections.FirstOrDefault(s => s.AspxPath.Contains(page)); using (var dataContext = new nChangerDb()) { dataContext.Database.ExecuteSqlCommand("DELETE FROM UserFormDetail WHERE UserId='" + UserId + "' AND PdfTemplateId='" + CurrentId + "' AND FrmGuid='" + curret.FrmGuid.ToString() + "'"); dataContext.UserFormDetails.AddOrUpdate(new UserFormDetail { Id = Guid.NewGuid(), UserId = UserId, AspxPath = curret.AspxPath, TableName = curret.TableName, PdfTemplateId = Guid.Parse(CurrentId), FrmGuid = curret.FrmGuid, Completed = "Y" }); dataContext.SaveChanges(); } } catch (Exception exception) { throw new Exception(exception.Message); } var nextPage = FormIndex + 1; var redirect = Sections.Where(s => s.DisplayOrder.Equals(nextPage)).FirstOrDefault().AspxPath; Response.Redirect(redirect); }
public bool Submit() { var returnMessage = string.Empty; var success = true; var id = string.IsNullOrEmpty(hiddenProvinceId.Value) ? Guid.NewGuid() : Guid.Parse(hiddenProvinceId.Value); try { var message = string.Empty; using (var dataContext = new nChangerDb()) { var province = new Province() { Id = id, ProvinceName = hidName.Value, Description = hidDesc.Value, IsActive = true, EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId }; dataContext.Provinces.AddOrUpdate(province); dataContext.SaveChanges(); } } catch (DbEntityValidationException ex) { success = false; returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors).Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } // lblMsg.Text = returnMessage; return success; }
private void ActivateUser(string id) { try { using (var dataContext = new nChangerDb()) { var dbUser = dataContext.Users.FirstOrDefault(u => u.VerificationCode.ToLower().Equals(id)); if (dbUser != null) { dbUser.EmailVerified = true; dbUser.IsActive = true; dataContext.Users.AddOrUpdate(dbUser); dataContext.SaveChanges(); ShowMessage(dbUser); } } } catch (Exception ex) { } }
public bool Submit() { var success = true; var id = string.IsNullOrEmpty(hiddenCategoryId.Value) ? Guid.NewGuid() : Guid.Parse(hiddenCategoryId.Value); try { using (var dataContext = new nChangerDb()) { var category = new ProvinceCategory() { Id = id, ProvinceId = string.IsNullOrEmpty(hiddenProvinceId.Value)? Guid.Parse(ddlProvinceAdd.SelectedValue):Guid.Parse(hiddenProvinceId.Value), Category = hidCategoryName.Value, Description = hidCategoryDesc.Value, IsActive = true, EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId }; dataContext.ProvinceCategories.AddOrUpdate(category); dataContext.SaveChanges(); } } catch (DbEntityValidationException ex) { success = false; } return success; }
private string Submit() { var id = Guid.Parse(RecordId); var returnMessage = string.Empty; try { using (var dataContext = new nChangerDb()) { var dbEntry = dataContext.CriminalOffenceInformations.Find(id); if (dbEntry != null) { dbEntry.UserId = UserId; dbEntry.OutstandingCourtProceedings = rdLstOutstandingCourtProceedings.SelectedIndex == 0; dbEntry.CourtFileNumber = txtCourtFileNumber.Text; dbEntry.CourtName = txtCourtName.Text; dbEntry.CourtAddress = txtCourtAddress.Text; dbEntry.DescribeProceedings = txtDescribeProceedings.Text; dbEntry.OutstandingEnforcementOrders = rdLstOutstandingEnforcementOrders.SelectedIndex == 0; dbEntry.DetailsOfOutstandingEnforcementOrders = txtDetailsOfOutstandingEnforcementOrders.Text; dbEntry.EverConvictedOfCriminalOffence = rdLstEverConvictedOfCriminalOffence.SelectedIndex == 0; dbEntry.DetailsOfCriminalOffence = txtDetailsOfCriminalOffence.Text; dbEntry.FoundGuiltyDischarged = rdLstFoundGuiltyDischarged.SelectedIndex == 0; dbEntry.FoundGuiltyDetailsOfOffence = txtFoundGuiltyDetailsOfOffence.Text; dbEntry.AdultSentenceImposed = rdLstAdultSentenceImposed.SelectedIndex == 0; dbEntry.DescribeAdultSentence = txtDescribeAdultSentence.Text; dbEntry.PendingCharges = rdLstPendingCharges.SelectedIndex == 0; dbEntry.PendingChargesCourtNumber = txtPendingChargesCourtNumber.Text; dbEntry.PendingChargesCourtName = txtPendingChargesCourtName.Text; dbEntry.PendingChargesCourtAddress = txtPendingChargesCourtAddress.Text; dbEntry.PendingChargesDescribe = txtPendingChargesDescribe.Text; dbEntry.EntryDate = DateTime.Today; dbEntry.EntryIP = CommonFunctions.GetIpAddress(); dbEntry.IsActive = true; dbEntry.EntryId = UserId; } else { var entry = new CriminalOffenceInformation { Id = id, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = UserId, OutstandingCourtProceedings = rdLstOutstandingCourtProceedings.SelectedIndex == 0, CourtFileNumber = txtCourtFileNumber.Text, CourtName = txtCourtName.Text, CourtAddress = txtCourtAddress.Text, DescribeProceedings = txtDescribeProceedings.Text, OutstandingEnforcementOrders = rdLstOutstandingEnforcementOrders.SelectedIndex == 0, DetailsOfOutstandingEnforcementOrders = txtDetailsOfOutstandingEnforcementOrders.Text, EverConvictedOfCriminalOffence = rdLstEverConvictedOfCriminalOffence.SelectedIndex == 0, DetailsOfCriminalOffence = txtDetailsOfCriminalOffence.Text, FoundGuiltyDischarged = rdLstFoundGuiltyDischarged.SelectedIndex == 0, FoundGuiltyDetailsOfOffence = txtFoundGuiltyDetailsOfOffence.Text, AdultSentenceImposed = rdLstAdultSentenceImposed.SelectedIndex == 0, DescribeAdultSentence = txtDescribeAdultSentence.Text, PendingCharges = rdLstPendingCharges.SelectedIndex == 0, PendingChargesCourtNumber = txtPendingChargesCourtNumber.Text, PendingChargesCourtName = txtPendingChargesCourtName.Text, PendingChargesCourtAddress = txtPendingChargesCourtAddress.Text, PendingChargesDescribe = txtPendingChargesDescribe.Text, EntryDate = DateTime.Today, EntryIP = CommonFunctions.GetIpAddress(), IsActive = true, EntryId = UserId, }; dataContext.CriminalOffenceInformations.Add(entry); } dataContext.SaveChanges(); returnMessage = "Data submitted successfully!"; } } catch (DbEntityValidationException ex) { returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors) .Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } return returnMessage; }
public bool Submit() { var success = true; var id = string.IsNullOrEmpty(hidQuestionId.Value) ? Guid.NewGuid() : Guid.Parse(hidQuestionId.Value); try { using (var dataContext = new nChangerDb()) { var question = new DefineQuestion() { Id = id, ProvinceCategoryId = string.IsNullOrEmpty(hidProvinceCategoryId.Value)?Guid.Parse(ddlCategoryAdd.SelectedValue):Guid.Parse(hidProvinceCategoryId.Value), Question = hidQuestion.Value, QuestionType = hidQuestionType.Value, DataSource = string.IsNullOrEmpty(hidPreset.Value)?null:hidPreset.Value, IsActive =true, EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, }; dataContext.DefineQuestions.AddOrUpdate(question); #region Options... dataContext.Database.ExecuteSqlCommand("DELETE FROM QuestionOptions WHERE DefineQuestionsId='" + id + "'"); if (!string.IsNullOrEmpty(hidOptions.Value)) { if (!hidOptions.Value.Contains(",")) { var option = new QuestionOption { Id = Guid.NewGuid(), DefineQuestionsId = id, OptionLabel = hidOptions.Value, EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, IsActive = true }; dataContext.QuestionOptions.AddOrUpdate(option); } else { var optionsArray = hidOptions.Value.EndsWith(",")? hidOptions.Value.Substring(0, hidOptions.Value.Length - 1).Split(','): hidOptions.Value.Split(','); foreach (var option in optionsArray.Select(item => new QuestionOption { Id = Guid.NewGuid(), DefineQuestionsId = id, OptionLabel = item, EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, IsActive = true })) { dataContext.QuestionOptions.AddOrUpdate(option); } } } #endregion Package Features... dataContext.SaveChanges(); lblMsg.Text = "Question " + (string.IsNullOrEmpty(hidQuestionId.Value) ? "added" : "updated") + " successfully."; ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "showAlert()", true); } } catch (DbEntityValidationException ex) { lblMsg.Text = ex.Message; success = false; } return success; }
private string Submit() { var id = Guid.Parse(RecordId); var returnMessage = string.Empty; try { using (var dataContext = new nChangerDb()) { var dbEntry = dataContext.FinancialInformations.Find(id); if (dbEntry != null) { dbEntry.UserId = UserId; dbEntry.CourtOrTribunalOrder = rdLstCourtOrTribunalOrder.SelectedIndex == 0; dbEntry.CourtFileNumber = txtCourtFileNumber.Text; dbEntry.NameOfCourt = txtNameOfCourt.Text; dbEntry.DateOfCourtOrderDay = string.IsNullOrEmpty(txtDateCourtOrder.Text) ? 0 : DateTime.ParseExact(txtDateCourtOrder.Text, "MM/dd/yyyy", null).Day; dbEntry.DateOfCourtOrderMonth = string.IsNullOrEmpty(txtDateCourtOrder.Text) ? 0 : DateTime.ParseExact(txtDateCourtOrder.Text, "MM/dd/yyyy", null).Month; dbEntry.DateOfCourtOrderYear = string.IsNullOrEmpty(txtDateCourtOrder.Text) ? 0 : DateTime.ParseExact(txtDateCourtOrder.Text, "MM/dd/yyyy", null).Year; dbEntry.NameOfPersonWhoSuedYou = txtNameOfPersonWhoSuedYou.Text; dbEntry.AddressCourtTribunal = txtAddressCourtTribunal.Text; dbEntry.SheriffDirected = rdLstSheriffDirected.SelectedIndex == 0; dbEntry.WritNumber = txtWritNumber.Text; dbEntry.NameOfSherrif = txtNameOfSherrif.Text; dbEntry.AddressOfSheriff = txtAddressOfSheriff.Text; dbEntry.LiensOrSecurityInterests = rdLstLiensOrSecurityInterests.SelectedIndex == 0; dbEntry.LiensOrSecurityInterestsNameOfPerson = txtLiensOrSecurityInterestsNameOfPerson.Text; dbEntry.AmountOfMoneyOwed = txtAmountOfMoneyOwed.Text; dbEntry.RegitrationNumber = txtRegitrationNumber.Text; dbEntry.FinancialStatementsRegistered = rdLstFinancialStatementsRegistered.SelectedIndex == 0; dbEntry.FinancialStatementsRegitrationNumber = txtFinancialStatementsRegitrationNumber.Text; dbEntry.UndischargedBankrupt = rdLstUndischargedBankrupt.SelectedIndex == 0; dbEntry.DetailsOfBankruptcy = txtDetailsOfBankruptcy.Text; dbEntry.EntryDate = DateTime.Today; dbEntry.EntryIP = CommonFunctions.GetIpAddress(); dbEntry.IsActive = true; dbEntry.EntryId = UserId; } else { var entry = new FinancialInformation { Id = id, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = UserId, CourtOrTribunalOrder = rdLstCourtOrTribunalOrder.SelectedIndex == 0, CourtFileNumber = txtCourtFileNumber.Text, NameOfCourt = txtNameOfCourt.Text, DateOfCourtOrderDay = string.IsNullOrEmpty(txtDateCourtOrder.Text) ? 0 : DateTime.ParseExact(txtDateCourtOrder.Text, "MM/dd/yyyy", null).Day, DateOfCourtOrderMonth = string.IsNullOrEmpty(txtDateCourtOrder.Text) ? 0 : DateTime.ParseExact(txtDateCourtOrder.Text, "MM/dd/yyyy", null).Month, DateOfCourtOrderYear = string.IsNullOrEmpty(txtDateCourtOrder.Text) ? 0 : DateTime.ParseExact(txtDateCourtOrder.Text, "MM/dd/yyyy", null).Year, NameOfPersonWhoSuedYou = txtNameOfPersonWhoSuedYou.Text, AddressCourtTribunal = txtAddressCourtTribunal.Text, SheriffDirected = rdLstSheriffDirected.SelectedIndex == 0, WritNumber = txtWritNumber.Text, NameOfSherrif = txtNameOfSherrif.Text, AddressOfSheriff = txtAddressOfSheriff.Text, LiensOrSecurityInterests = rdLstLiensOrSecurityInterests.SelectedIndex == 0, LiensOrSecurityInterestsNameOfPerson = txtLiensOrSecurityInterestsNameOfPerson.Text, AmountOfMoneyOwed = txtAmountOfMoneyOwed.Text, RegitrationNumber = txtRegitrationNumber.Text, FinancialStatementsRegistered = rdLstFinancialStatementsRegistered.SelectedIndex == 0, FinancialStatementsRegitrationNumber = txtFinancialStatementsRegitrationNumber.Text, UndischargedBankrupt = rdLstUndischargedBankrupt.SelectedIndex == 0, DetailsOfBankruptcy = txtDetailsOfBankruptcy.Text, EntryDate = DateTime.Today, EntryIP = CommonFunctions.GetIpAddress(), IsActive = true, EntryId = UserId, }; dataContext.FinancialInformations.Add(entry); } dataContext.SaveChanges(); returnMessage = "Data submitted successfully!"; } } catch (DbEntityValidationException ex) { returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors) .Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } return returnMessage; }
private bool AddUserPackage(string userId) { var success = true; try { using (var dataContext = new nChangerDb()) { dataContext.UserPackages.Add(new UserPackage { Id=Guid.NewGuid(), PackageId = Guid.Parse(Request.QueryString["pid"]), UserId=userId, }); dataContext.SaveChanges(); } } catch (Exception exception) { var msg = exception.Message; success = false; } return success; }
public bool Submit() { var success = true; var id = string.IsNullOrEmpty(hidPackageId.Value) ? Guid.NewGuid() : Guid.Parse(hidPackageId.Value); try { using (var dataContext = new nChangerDb()) { var package = new Package() { Id = id, PackageName = hidPackageName.Value, Price = Convert.ToDecimal(hidPrice.Value), IsActive = !string.IsNullOrEmpty(hidActive.Value) && Convert.ToBoolean(hidActive.Value), EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, }; dataContext.Packages.AddOrUpdate(package); #region Package Features... dataContext.Database.ExecuteSqlCommand("DELETE FROM PackageFeature WHERE PackageId='"+id+"'"); if (!string.IsNullOrEmpty(hidFeatures.Value)) { var featureArray = hidFeatures.Value.Substring(0, hidFeatures.Value.Length - 1).Split(','); foreach (var feature in featureArray.Select(item => new PackageFeature { Id = Guid.NewGuid(), PackageId = id, FeatureId = Guid.Parse(chkFeatures.Items.FindByText(item).Value), FeatureName = item, EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, IsActive = true })) { dataContext.PackageFeatures.AddOrUpdate(feature); } } #endregion Package Features... dataContext.SaveChanges(); lblMsg.Text = "Package \"" + package.PackageName + "\" " + (string.IsNullOrEmpty(hidPackageId.Value) ? "added" : "updated") + " successfully."; ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "showAlert()", true); } } catch (DbEntityValidationException ex) { success = false; } return success; }
private void UploadPdf(string file) { var id = Request.UrlReferrer.Query.Substring(4); try { using (var dataContext = new nChangerDb()) { if (Request.UrlReferrer != null) dataContext.PdfFormTemplates.Add(new PdfFormTemplate { Id = Guid.NewGuid(), ProvinceCategoryId = Guid.Parse(Request.UrlReferrer.Query.Substring(4)), PdfFileName = file, TemplateName = file, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, EntryDate = DateTime.Now, IsActive = false, }); dataContext.SaveChanges(); } } catch (DbEntityValidationException ex) { foreach (var eve in ex.EntityValidationErrors) { lblMsg.Text += eve.Entry.Entity.GetType().Name + "<br/>" + eve.Entry.State; foreach (var ve in eve.ValidationErrors) { lblMsg.Text += ve.PropertyName + "<br/>" + ve.ErrorMessage; } } } }
private void UpdateGeneratedPdf(FileInfo fileInfo) { var id = Guid.Parse(RecordId); var pdfFormTemplateid = Guid.Parse(CurrentId); using (var dataContext=new nChangerDb()) { var dbEntry = dataContext.GeneratedPdfs.Find(id); if (dbEntry != null) { dataContext.GeneratedPdfs.Remove(dbEntry); dataContext.SaveChanges(); } dataContext.GeneratedPdfs.AddOrUpdate(new GeneratedPdf { Id=id, PdfFormTemplateId = pdfFormTemplateid, UserId = UserId, CompletedPdf ="../Output/"+Path.GetFileName(fileInfo.Name), EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId= UserId, IsActive=true }); dataContext.SaveChanges(); } }
protected void btnSubmit_OnClick(object sender, EventArgs e) { RemoveExisting(); var id = Guid.Parse(RecordId); foreach (HtmlTableRow row in tblFields.Rows) { { foreach (HtmlTableCell cell in row.Cells) { foreach (var ctl in cell.Controls) { if (ctl.GetType() == typeof (TextBox)) { var txt = (TextBox) ctl; using (var dataContext = new nChangerDb()) { dataContext.GeneralQuestionUserResponses.AddOrUpdate(new GeneralQuestionUserResponse { Id = Guid.NewGuid(), RecordId = id, Question = txt.Attributes["placeholder"].ToString(), UserAnswer = txt.Text, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = UserId, DefineQuestionId = Guid.Parse(Convert.ToString(txt.Attributes["DB_ID"])), EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, IsActive = true }); dataContext.SaveChanges(); } } else if (ctl.GetType() == typeof (RadioButtonList)) { var rdList = (RadioButtonList) ctl; using (var dataContext = new nChangerDb()) { dataContext.GeneralQuestionUserResponses.AddOrUpdate(new GeneralQuestionUserResponse { Id = Guid.NewGuid(), RecordId = id, Question = rdList.Attributes["Question"].ToString(), UserAnswer = rdList.SelectedIndex != -1 ? rdList.SelectedItem.Text : string.Empty, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = UserId, DefineQuestionId = Guid.Parse(Convert.ToString(rdList.Attributes["DB_ID"])), EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, IsActive = true }); dataContext.SaveChanges(); } } else if (ctl.GetType() == typeof (DropDownList)) { var ddl = (DropDownList) ctl; using (var dataContext = new nChangerDb()) { dataContext.GeneralQuestionUserResponses.AddOrUpdate(new GeneralQuestionUserResponse { Id = Guid.NewGuid(), RecordId = id, Question = ddl.Attributes["Question"].ToString(), UserAnswer = ddl.SelectedIndex != -1 ? ddl.SelectedItem.Text : string.Empty, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = UserId, DefineQuestionId = Guid.Parse(Convert.ToString(ddl.Attributes["DB_ID"])), EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, IsActive = true }); dataContext.SaveChanges(); } } } } } } var redirect = Sections.Where(s => s.DisplayOrder.Equals(1)).FirstOrDefault().AspxPath; Response.Redirect(redirect); }
private string Submit() { var id = Guid.Parse(RecordId); var returnMessage = string.Empty; try { using (var dataContext = new nChangerDb()) { var dbEntry = dataContext.ParentInformations.Find(id); if (dbEntry != null) { dbEntry.FatherFirstName = txtFatherFirstName.Text; dbEntry.FatherMiddleName = txtFatherMiddleName.Text; dbEntry.FatherLastName = txtFatherLastName.Text; dbEntry.FatherOtherLastName = txtFatherLastNameOther.Text; dbEntry.MotherFirstName = txtMotherFirstName.Text; dbEntry.MotherMiddleName = txtMotherMiddleName.Text; dbEntry.MotherLastNameWhenBorn = txtMotherLastNameBorn.Text; dbEntry.MotherLastNamePresent = txtMotherLastNamePresent.Text; dbEntry.MotherLastNameOther = txtMotherLastNameOther.Text; dbEntry.EntryDate = DateTime.Today; dbEntry.EntryIP = CommonFunctions.GetIpAddress(); dbEntry.IsActive = true; dbEntry.EntryId = UserId; dataContext.Entry(dbEntry).State = EntityState.Modified; } else { var entry = new ParentInformation() { Id = id, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = UserId, FatherFirstName = txtFatherFirstName.Text, FatherMiddleName = txtFatherMiddleName.Text, FatherLastName = txtFatherLastName.Text, FatherOtherLastName = txtFatherLastNameOther.Text, MotherFirstName = txtMotherFirstName.Text, MotherMiddleName = txtMotherMiddleName.Text, MotherLastNameWhenBorn = txtMotherLastNameBorn.Text, MotherLastNamePresent = txtMotherLastNamePresent.Text, MotherLastNameOther = txtMotherLastNameOther.Text, EntryDate = DateTime.Today, EntryIP = CommonFunctions.GetIpAddress(), IsActive = true, EntryId = UserId }; dataContext.ParentInformations.Add(entry); } dataContext.SaveChanges(); returnMessage = "Data submitted successfully!"; } } catch (DbEntityValidationException ex) { returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors).Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } return returnMessage; }
protected void gvProvinceCategory_OnRowDeleting(object sender, GridViewDeleteEventArgs e) { var id = Guid.Parse(Convert.ToString(gvProvinceCategory.DataKeys[e.RowIndex].Values[0])); try { using (var dataContext = new nChangerDb()) { var dbEntry = dataContext.ProvinceCategories.Find(id); dataContext.ProvinceCategories.Remove(dbEntry); dataContext.SaveChanges(); lblMsg.Text = "Category " + dbEntry.Category + " deleted successfully."; ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "showAlert()", true); if (Request.QueryString["id"] != null) BindCateory(Guid.Parse(Request.QueryString["id"])); else BindCateory(); } } catch (Exception exception) { lblMsg.Text = exception.Message; } }
protected void gvPackage_OnRowDeleting(object sender, GridViewDeleteEventArgs e) { var id = Guid.Parse(Convert.ToString(gvPackage.DataKeys[e.RowIndex].Values[0])); try { using (var dataContext = new nChangerDb()) { var dbEntry = dataContext.Packages.Find(id); dataContext.Packages.Remove(dbEntry); dataContext.SaveChanges(); BindPackages(); lblMsg.Text = "Package \"" + dbEntry.PackageName + "\" deleted successfully."; ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "showAlert()", true); } } catch (Exception exception) { lblMsg.Text = exception.Message; } }
private string Submit() { var id = Guid.Parse(RecordId); var returnMessage = string.Empty; try { using (var dataContext=new nChangerDb()) { var dbEntry = dataContext.PersonalInformations.Find(id); if (dbEntry != null) { dbEntry.PresentFirstName = txtPresentFirstName.Text; dbEntry.PresentMiddleName = txtPresentMiddleName.Text; dbEntry.PresentLastName = txtPresentLastName.Text; dbEntry.Sex =rdListSex.SelectedIndex==-1?string.Empty: rdListSex.SelectedItem.Value; dbEntry.MailAddStreetNo = txtMailAddStreetNo.Text; dbEntry.MailAddPOBox = txtMailAddPOBox.Text; dbEntry.MailAddAptSuitNo = txtMailAddAptSuitNo.Text; dbEntry.MailAddBuzzerNo = txtMailAddBuzzerNo.Text; dbEntry.MailAddCityTownVillage = txtMailAddCityTownVillage.Text; dbEntry.MailAddProvience = txtMailAddProvience.Text; dbEntry.MailAddPostalCode = txtMailAddPostalCode.Text; dbEntry.MailAddHomePhoneCode = txtMailAddHomePhoneCode.Text; dbEntry.MailAddHomePhoneNo = txtMailAddHomePhoneNo.Text; dbEntry.MailAddWorkPhoneCode = txtMailAddWorkPhoneCode.Text; dbEntry.MailAddWorkPhoneNo = txtMailAddWorkPhoneNo.Text; dbEntry.LivedInOntarioYears = string.IsNullOrEmpty(txtLivedInOntarioYears.Text)?0:Convert.ToInt32(txtLivedInOntarioYears.Text); dbEntry.LivedInOntarioMonths = string.IsNullOrEmpty(txtLivedInOntarioMonths.Text) ? 0 : Convert.ToInt32(txtLivedInOntarioMonths.Text); dbEntry.LivedInOntarioPast12Months = rdListLivedInOntarioPast12Months.SelectedIndex==-1?string.Empty : rdListLivedInOntarioPast12Months.SelectedValue; dbEntry.DOBYear = string.IsNullOrEmpty(txtDOB.Text) ? 0 : DateTime.ParseExact(txtDOB.Text, "MM/dd/yyyy", null).Year; dbEntry.DOBMonth = string.IsNullOrEmpty(txtDOB.Text) ? 0 : DateTime.ParseExact(txtDOB.Text, "MM/dd/yyyy", null).Month; dbEntry.DOBDay = string.IsNullOrEmpty(txtDOB.Text) ? 0 : DateTime.ParseExact(txtDOB.Text, "MM/dd/yyyy", null).Day; dbEntry.BirthCityTownVillage = txtBirthCityTownVillage.Text; dbEntry.BirthProvinceOrState = txtBirthProvinceOrState.Text; dbEntry.BirthCountry = txtBirthCountry.Text; dbEntry.NewFirstName = txtNewFirstName.Text; dbEntry.NewMiddleName = txtNewMiddleName.Text; dbEntry.NewLastName = txtNewLastName.Text; dbEntry.Married = rdListMarried.SelectedValue; dbEntry.PartnerFisrtName = txtPartnerFisrtName.Text; dbEntry.PartnerMiddleName = txtPartnerMiddleName.Text; dbEntry.PartnerLastName = txtPartnerLastName.Text; dbEntry.DateMarriedMonth = string.IsNullOrEmpty(txtDateMarried.Text) ? 0 : DateTime.ParseExact(txtDateMarried.Text, "MM/dd/yyyy",null).Month; dbEntry.DateMarriedDay = string.IsNullOrEmpty(txtDateMarried.Text) ? 0 : DateTime.ParseExact(txtDateMarried.Text, "MM/dd/yyyy",null).Day; dbEntry.DateMarriedYear = string.IsNullOrEmpty(txtDateMarried.Text) ? 0 : DateTime.ParseExact(txtDateMarried.Text, "MM/dd/yyyy", null).Year; dbEntry.CityTownMarried = txtCityTownMarried.Text; dbEntry.StateOrProvinceMarried = txtStateOrProvinceMarried.Text; dbEntry.CountryMarried =ddlCountryMarried.SelectedIndex==-1?string.Empty:ddlCountryMarried.SelectedValue; dbEntry.JDeclarationSigned = rdListJDeclarationSigned.SelectedIndex == -1 ? string.Empty : rdListJDeclarationSigned.SelectedValue; dbEntry.JDeclarationPersonFirstName = txtJDeclarationPersonFirstName.Text; dbEntry.JDeclarationPersonMiddleName = txtJDeclarationPersonMiddleName.Text; dbEntry.JDeclarationPersonLastName = txtJDeclarationPersonLastName.Text; dbEntry.SentRegistrarMonth = string.IsNullOrEmpty(txtSentRegistrarDate.Text) ? 0 : DateTime.ParseExact(txtSentRegistrarDate.Text, "MM/dd/yyyy", null).Month; dbEntry.SentRegistrarDay = string.IsNullOrEmpty(txtSentRegistrarDate.Text) ? 0 : Convert.ToDateTime(txtSentRegistrarDate.Text).Day; dbEntry.SentRegistrarYear = string.IsNullOrEmpty(txtSentRegistrarDate.Text) ? 0 : Convert.ToDateTime(txtSentRegistrarDate.Text).Year; dbEntry.SubmittedForm4 = rdListSubmittedForm4.SelectedIndex == -1 ? string.Empty : rdListSubmittedForm4.SelectedValue; dbEntry.EntryDate= DateTime.Today; dbEntry.EntryIP= CommonFunctions.GetIpAddress(); dbEntry.IsActive= true; dbEntry.EntryId = Convert.ToString(Session["USER_KEY"]); dataContext.Entry(dbEntry).State = EntityState.Modified; } else { var entry = new PersonalInformation { Id=id, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = Convert.ToString(Session["USER_KEY"]), PresentFirstName = txtPresentFirstName.Text, PresentMiddleName = txtPresentMiddleName.Text, PresentLastName = txtPresentLastName.Text, Sex = rdListSex.SelectedIndex == -1 ? string.Empty : rdListSex.SelectedItem.Value, MailAddStreetNo = txtMailAddStreetNo.Text, MailAddPOBox = txtMailAddPOBox.Text, MailAddAptSuitNo = txtMailAddAptSuitNo.Text, MailAddBuzzerNo = txtMailAddBuzzerNo.Text, MailAddCityTownVillage = txtMailAddCityTownVillage.Text, MailAddProvience = txtMailAddProvience.Text, MailAddPostalCode = txtMailAddPostalCode.Text, MailAddHomePhoneCode = txtMailAddHomePhoneCode.Text, MailAddHomePhoneNo = txtMailAddHomePhoneNo.Text, MailAddWorkPhoneCode = txtMailAddWorkPhoneCode.Text, MailAddWorkPhoneNo = txtMailAddWorkPhoneNo.Text, LivedInOntarioYears = string.IsNullOrEmpty(txtLivedInOntarioYears.Text) ? 0 : Convert.ToInt32(txtLivedInOntarioYears.Text), LivedInOntarioMonths = string.IsNullOrEmpty(txtLivedInOntarioMonths.Text) ? 0 : Convert.ToInt32(txtLivedInOntarioMonths.Text), LivedInOntarioPast12Months = rdListLivedInOntarioPast12Months.SelectedIndex == -1 ? string.Empty : rdListLivedInOntarioPast12Months.SelectedValue, DOBYear = string.IsNullOrEmpty(txtDOB.Text) ? 0 : DateTime.ParseExact(txtDOB.Text, "MM/dd/yyyy", null).Year, DOBMonth = string.IsNullOrEmpty(txtDOB.Text) ? 0 : DateTime.ParseExact(txtDOB.Text, "MM/dd/yyyy", null).Month, DOBDay = string.IsNullOrEmpty(txtDOB.Text) ? 0 : DateTime.ParseExact(txtDOB.Text, "MM/dd/yyyy", null).Day, BirthCityTownVillage = txtBirthCityTownVillage.Text, BirthProvinceOrState = txtBirthProvinceOrState.Text, BirthCountry = txtBirthCountry.Text, NewFirstName = txtNewFirstName.Text, NewMiddleName = txtNewMiddleName.Text, NewLastName = txtNewLastName.Text, Married = rdListMarried.SelectedValue, PartnerFisrtName = txtPartnerFisrtName.Text, PartnerMiddleName = txtPartnerMiddleName.Text, PartnerLastName = txtPartnerLastName.Text, DateMarriedMonth = string.IsNullOrEmpty(txtDateMarried.Text) ? 0 : DateTime.ParseExact(txtDateMarried.Text, "MM/dd/yyyy", null).Month, DateMarriedDay = string.IsNullOrEmpty(txtDateMarried.Text) ? 0 : DateTime.ParseExact(txtDateMarried.Text, "MM/dd/yyyy", null).Day, DateMarriedYear = string.IsNullOrEmpty(txtDateMarried.Text) ? 0 : DateTime.ParseExact(txtDateMarried.Text, "MM/dd/yyyy", null).Year, CityTownMarried = txtCityTownMarried.Text, StateOrProvinceMarried = txtStateOrProvinceMarried.Text, CountryMarried = ddlCountryMarried.SelectedIndex == -1 ? string.Empty : ddlCountryMarried.SelectedValue, JDeclarationSigned = rdListJDeclarationSigned.SelectedIndex == -1 ? string.Empty : rdListJDeclarationSigned.SelectedValue, JDeclarationPersonFirstName = txtJDeclarationPersonFirstName.Text, JDeclarationPersonMiddleName = txtJDeclarationPersonMiddleName.Text, JDeclarationPersonLastName = txtJDeclarationPersonLastName.Text, SentRegistrarMonth = string.IsNullOrEmpty(txtSentRegistrarDate.Text) ? 0 : DateTime.ParseExact(txtSentRegistrarDate.Text, "MM/dd/yyyy", null).Month, SentRegistrarDay = string.IsNullOrEmpty(txtSentRegistrarDate.Text) ? 0 : Convert.ToDateTime(txtSentRegistrarDate.Text).Day, SentRegistrarYear = string.IsNullOrEmpty(txtSentRegistrarDate.Text) ? 0 : Convert.ToDateTime(txtSentRegistrarDate.Text).Year, SubmittedForm4 = rdListSubmittedForm4.SelectedIndex == -1 ? string.Empty : rdListSubmittedForm4.SelectedValue, EntryDate = DateTime.Today, EntryIP = CommonFunctions.GetIpAddress(), IsActive = true, EntryId = Convert.ToString(Session["USER_KEY"]) }; dataContext.PersonalInformations.Add(entry); } dataContext.SaveChanges(); returnMessage = "Data submitted successfully!"; } } catch (DbEntityValidationException ex) { returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors).Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } return returnMessage; }
protected void btnSubmit_Click(object sender, EventArgs e) { if (Session["PKG"] != null) { try { var package = (Package)Session["PKG"]; using (var dataContext = new nChangerDb()) { var user = dataContext.Users.Find(UserId); if (user != null) { #region Charge.... var myCharge = new StripeChargeCreateOptions { Amount = (int)(package.Price * 100), Currency = "usd", Description = "Subscription Charges for " + package.PackageName + " package for " + UserName, Source = new StripeSourceOptions() { // set these properties if passing full card details (do not // set these properties if you set TokenId) Object = "card", Number = txtCardNumber.Text, ExpirationYear = txtExpieryYear.Text, ExpirationMonth = ddlExpiryMonth.SelectedValue, AddressCountry = user.Country, // optional AddressLine1 = user.Address, // optional AddressLine2 = user.Address2, // optional AddressCity = user.City, // optional AddressState = user.State, // optional AddressZip = user.Zip, // optional Name = UserName, // optional Cvc = txtCVC.Text, // optional ReceiptEmail = user.Email }, Capture = true }; var stripeCharge = new StripeCharge(); try { var chargeService = new StripeChargeService(ConfigurationManager.AppSettings["StripeApiKey"]); stripeCharge = chargeService.Create(myCharge); #region Log Entry... dataContext.UserPayments.Add(new UserPayment { Id = Guid.NewGuid(), Amount = (decimal)(stripeCharge.Amount / 100), Currency = stripeCharge.Currency, Status = stripeCharge.Status, FailureCode = stripeCharge.FailureCode, FailureMessage = stripeCharge.FailureMessage, PackageId = package.Id, PaymentDate = stripeCharge.Created, UserId = UserId, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, }); if (stripeCharge.Status.ToLower().Equals("succeeded")) dataContext.Database.ExecuteSqlCommand("UPDATE Users SET IsPaidMember='1' WHERE UserId='" + UserId + "'"); #endregion Log Entry... } catch(Exception error) { dataContext.UserPayments.Add(new UserPayment { Id = Guid.NewGuid(), Amount = (decimal)package.Price, Currency = "usd", Status = "Failed", FailureCode = stripeCharge.FailureCode, FailureMessage = error.Message, PackageId = package.Id, PaymentDate = DateTime.Now, UserId = UserId, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, }); } #endregion Charge.... dataContext.SaveChanges(); #region Response... Session.Add("PMS", stripeCharge); Response.Redirect("PaymentResponse.aspx"); #endregion Response... } } } catch (Exception exception) { } } }
protected void gvFeature_OnRowDeleting(object sender, GridViewDeleteEventArgs e) { var id = Guid.Parse(Convert.ToString(gvFeature.DataKeys[e.RowIndex].Values[0])); try { using (var dataContext = new nChangerDb()) { var dbEntry = dataContext.FeatureMasters.Find(id); dataContext.Database.ExecuteSqlCommand("DELETE FROM PackageFeature WHERE FeatureId='" + id + "'"); dataContext.FeatureMasters.Remove(dbEntry); dataContext.SaveChanges(); lblMsg.Text = "Feature " + dbEntry.Feature + " deleted successfully."; ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "showAlert()", true); BindFeatures(); } } catch (Exception exception) { lblMsg.Text = exception.Message; } }
protected void btnSubmit_OnClick(object sender, EventArgs e) { divMsg.InnerText = Submit(); var sections = Sections; var page = Path.GetFileName(Request.PhysicalPath); var curret = Sections.FirstOrDefault(s => s.AspxPath.Contains(page)); using (var dataContext = new nChangerDb()) { dataContext.Database.ExecuteSqlCommand("DELETE FROM UserFormDetail WHERE UserId='" + UserId + "' AND PdfTemplateId='" + CurrentId + "' AND FrmGuid='" + curret.FrmGuid.ToString() + "'"); dataContext.UserFormDetails.AddOrUpdate(new UserFormDetail { Id = Guid.NewGuid(), UserId = UserId, AspxPath = curret.AspxPath, TableName = curret.TableName, PdfTemplateId = Guid.Parse(CurrentId), FrmGuid = curret.FrmGuid, Completed = "Y" }); dataContext.SaveChanges(); } Response.Redirect("../Secured/FormCompleted.aspx"); }
public bool Submit() { var returnMessage = string.Empty; var success = true; var id = string.IsNullOrEmpty(hidFeatureId.Value) ? Guid.NewGuid() : Guid.Parse(hidFeatureId.Value); try { var message = string.Empty; using (var dataContext = new nChangerDb()) { var feature = new FeatureMaster() { Id = id, Feature = hidFeatureName.Value, Description = hidFeatureDesc.Value, IsActive = true, EntryDate = DateTime.Now, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId }; dataContext.FeatureMasters.AddOrUpdate(feature); dataContext.SaveChanges(); lblMsg.Text = "Feature \"" + feature.Feature + "\" " + (string.IsNullOrEmpty(hidFeatureId.Value) ? "added" : "updated") + " successfully."; ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "showAlert()", true); } } catch (DbEntityValidationException ex) { success = false; returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors).Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } return success; }
private void UploadPdf(string file) { try { using (var dataContext = new nChangerDb()) { dataContext.PdfTemplates.Add(new PdfTemplate { Id = Guid.NewGuid(), PdfFileName = file, TemplateName = file, EntryIP = CommonFunctions.GetIpAddress(), EntryId = UserId, EntryDate = DateTime.Now, IsActive = false, }); dataContext.SaveChanges(); } } catch (DbEntityValidationException ex) { foreach (var eve in ex.EntityValidationErrors) { lblMsg.Text += eve.Entry.Entity.GetType().Name + "<br/>" + eve.Entry.State; foreach (var ve in eve.ValidationErrors) { lblMsg.Text += ve.PropertyName + "<br/>" + ve.ErrorMessage; } } } }
private string Submit() { var id = Guid.Parse(RecordId); var returnMessage = string.Empty; try { using (var dataContext = new nChangerDb()) { var dbEntry = dataContext.NameChangeInformations.Find(id); if (dbEntry != null) { dbEntry.ResonForNameChange = txtResonForNameChange.Text; dbEntry.ChangedNamePriviously = rdListChangedNamePriviously.SelectedIndex != -1 ? rdListChangedNamePriviously.SelectedValue:string.Empty; dbEntry.UserId = UserId; dbEntry.PreviousNameChangeDay = string.IsNullOrEmpty(txtPreviousNameChangeDate.Text) ? 0 : DateTime.ParseExact(txtPreviousNameChangeDate.Text, "MM/dd/yyyy", null).Day; dbEntry.PreviousNameChangeMonth = string.IsNullOrEmpty(txtPreviousNameChangeDate.Text) ? 0 : DateTime.ParseExact(txtPreviousNameChangeDate.Text, "MM/dd/yyyy", null).Month; dbEntry.PreviousNameChangeYear = string.IsNullOrEmpty(txtPreviousNameChangeDate.Text) ? 0 : DateTime.ParseExact(txtPreviousNameChangeDate.Text, "MM/dd/yyyy", null).Year; dbEntry.PreviousFirstName = txtPreviousFirstName.Text; dbEntry.PreviousMiddleName = txtPreviousMiddleName.Text; dbEntry.PreviousLastName = txtPreviousLastName.Text; dbEntry.FirstNameAfterChange = txtFirstNameAfterChange.Text; dbEntry.MiddleNameAfterChange = txtMiddleNameAfterChange.Text; dbEntry.LastNameAfterChange = txtLastNameAfterChange.Text; dbEntry.PreviousNameChangeProvince = txtPreviousNameChangeProvince.Text; dbEntry.PreviousNameChangeCountry = ddlCountry.SelectedIndex != -1 ? ddlCountry.SelectedValue:string.Empty; dbEntry.AppliedForChangeAndRefused = rdLstAppliedForChangeAndRefused.SelectedIndex == 0; dbEntry.EntryDate = DateTime.Today; dbEntry.EntryIP = CommonFunctions.GetIpAddress(); dbEntry.IsActive = true; dbEntry.EntryId = UserId; dataContext.Entry(dbEntry).State = EntityState.Modified; } else { var entry = new NameChangeInformation() { Id =id, PdfFormTemplateId = Guid.Parse(CurrentId), UserId = UserId, ResonForNameChange = txtResonForNameChange.Text, ChangedNamePriviously = rdListChangedNamePriviously.SelectedIndex != -1? rdListChangedNamePriviously.SelectedValue:string.Empty, PreviousNameChangeDay = string.IsNullOrEmpty(txtPreviousNameChangeDate.Text) ? 0 : DateTime.ParseExact(txtPreviousNameChangeDate.Text, "MM/dd/yyyy", null).Day, PreviousNameChangeMonth = string.IsNullOrEmpty(txtPreviousNameChangeDate.Text) ? 0 : DateTime.ParseExact(txtPreviousNameChangeDate.Text, "MM/dd/yyyy", null).Month, PreviousNameChangeYear = string.IsNullOrEmpty(txtPreviousNameChangeDate.Text) ? 0 : DateTime.ParseExact(txtPreviousNameChangeDate.Text, "MM/dd/yyyy", null).Year, PreviousFirstName = txtPreviousFirstName.Text, PreviousMiddleName = txtPreviousMiddleName.Text, PreviousLastName = txtPreviousLastName.Text, FirstNameAfterChange = txtFirstNameAfterChange.Text, MiddleNameAfterChange = txtMiddleNameAfterChange.Text, LastNameAfterChange = txtLastNameAfterChange.Text, PreviousNameChangeProvince = txtPreviousNameChangeProvince.Text, PreviousNameChangeCountry = ddlCountry.SelectedIndex != -1 ? ddlCountry.SelectedValue:string.Empty, AppliedForChangeAndRefused = rdLstAppliedForChangeAndRefused.SelectedIndex == 0, EntryDate = DateTime.Today, EntryIP = CommonFunctions.GetIpAddress(), IsActive = true, EntryId = UserId }; dataContext.NameChangeInformations.Add(entry); } dataContext.SaveChanges(); returnMessage = "Data submitted successfully!"; } } catch (DbEntityValidationException ex) { returnMessage = ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors).Aggregate(returnMessage, (current, ve) => current + (ve.PropertyName + " Error Msg:" + ve.ErrorMessage)); } return returnMessage; }