/// <summary> /// Load form with initial settings and hidden buttons /// </summary> private void LoadInitialForm() { this.model = new INVESTORS_FUNDS(); this.comboTypePerson.DataSource = _typesRepo.GetAll <string>(null, x => x.TYPE); this.comboEmployee.DataSource = new List <string>() { "СЛУЖИТЕЛ", "ПЪЛНОМОЩНИК", "НЕПРИЛОЖИМО" }; this.comboRegisterCd.DataSource = new List <string>() { "ДА", "НЕ" }; this.comboDds.DataSource = new List <string>() { "ДА", "НЕ" }; this.comboMailCountry.DataSource = _countriesRepo.GetAll <string>(null, x => x.COUNTRY); this.comboPersCountry.DataSource = _countriesRepo.GetAll <string>(null, x => x.COUNTRY); this.comboMailTown.DataSource = _townsRepo.GetAll <string>(null, x => x.TOWNNAME); this.comboPersTown.DataSource = _townsRepo.GetAll <string>(null, x => x.TOWNNAME); this.comboPersMunic.DataSource = _municRepo.GetAll <string>(null, x => x.MUNICIPALITY1); this.comboMailMunic.DataSource = _municRepo.GetAll <string>(null, x => x.MUNICIPALITY1); this.buttonClientDelete.Visible = false; this.buttonClientSave.Visible = false; this.labelClientId.Visible = false; this.textClientId.Visible = false; this.labelStatus.Visible = false; this.tеxtStatus.Visible = false; }
private void buttonClientSave_Click(object sender, EventArgs e) { var idText = this.textId.Text; if (!this.CheckPrimaryFields(idText)) { return; } model = this.CreateModelFromForm(); if (this.newClient == true) { this._investorsFundsRepo.Add(model); } else { this._investorsFundsRepo.Update(model); } try { this._uow.Commit(); MessageBox.Show("Записът е успешен!"); } catch (Exception ex) { MessageBox.Show("Неуспешен запис! Опитайте отново!" + "\n" + ex.Message); } }
/// <summary> /// when row clicked load data to fields /// </summary> private void dataGrid_DoubleClick(object sender, System.EventArgs e) { if (dataGrid.CurrentRow.Index != -1) { int id = (int)dataGrid.CurrentRow.Cells["columnId"].Value; model = this._investorsFundsRepo.GetById(id); this.PopulateFormFromModel(model); } }
/// <summary> /// Takes all information about selected client and populates fields of form /// </summary> private void PopulateFormFromModel(INVESTORS_FUNDS model) { // initial info this.textId.Text = model.PERSONALID_BULSTAT; this.comboTypePerson.SelectedIndex = comboTypePerson.FindStringExact(model.TYPE_PERSON); this.comboEmployee.SelectedIndex = comboEmployee.FindStringExact(model.EMPLOYEE_AUTHORISED); this.comboRegisterCd.SelectedIndex = comboRegisterCd.FindStringExact(model.CD_REG); this.tеxtStatus.Text = model.CL_STATUS; this.textClientId.Text = model.CLIENTID_STRING; // address this.comboMailCountry.SelectedIndex = comboMailCountry.FindStringExact(model.COUNTRY_ADDRESS_ID); this.comboPersCountry.SelectedIndex = comboPersCountry.FindStringExact(model.COUNTRY1); this.comboMailTown.SelectedIndex = comboMailTown.FindStringExact(model.TOWN_ADDRESS_ID); this.comboPersTown.SelectedIndex = comboPersTown.FindStringExact(model.TOWN1); this.comboMailMunic.SelectedIndex = comboMailMunic.FindStringExact(model.MUNICIPALITY); this.comboPersMunic.SelectedIndex = comboPersMunic.FindStringExact(model.MUNICIPALITY); this.textPersStreet.Text = model.STREET; this.textMailAddress.Text = model.ADDRESS_ID; this.textPersDistr.Text = model.RESIDENCE; this.textPersStrNum.Text = model.STRNUM; this.textPersApt.Text = model.FLAT; this.textPersFloor.Text = model.FLOOR1; // person this.textFirstName.Text = model.FIRSTNAME; this.textMiddleName.Text = model.SECONDNAME; this.textFamilyName.Text = model.LASTNAME; this.dateTimeBirthDate.Value = this.normalizeDate(model.CLIENT_BIRTHDATE); this.textPassportNumber.Text = model.PERSONAL_ID; this.dateTimePassportIssued.Value = this.normalizeDate(model.PERSONAL_ID_DATE); this.textPassportIssued.Text = model.PERSONAL_ID_ISSUED_BY; // company this.textCompanyName.Text = model.FULL_NAME; this.textCompanyTaxId.Text = model.ID_NUMBER_TAX_ID; this.comboDds.SelectedIndex = comboDds.FindStringExact(model.DDS_REGISTERED); this.comboOrgType.SelectedIndex = comboOrgType.FindStringExact(model.TYPE_ORGANIZATION); // bank accounts this.textIban1.Text = model.IBAN1; this.textBicCode1.Text = model.BIC1; this.textBankName1.Text = model.BANK1; this.textIban2.Text = model.IBAN2; this.textBicCode2.Text = model.BIC2; this.textBankName2.Text = model.BANK2; this.textIban3.Text = model.IBAN3; this.textBicCode3.Text = model.BIC3; this.textBankName3.Text = model.BANK3; // other data this.textEmail.Text = model.E_MAIL; this.textPhone.Text = model.TEL_FIXED; this.textMobile.Text = model.TEL_MOBILE; this.textGlobalIdCd.Text = model.CD_GLOBID.ToString(); this.textBicCodeCd.Text = model.CD_BIC; // attorney data this.textAttorneyType.Text = model.AUTHORISED_TYPE; this.textAttorneyDoc.Text = model.AUTHORISED_DOC; this.dateTimeAttorney.Value = this.normalizeDate(model.AUTHORISED_DATE); this.textAttorneyNotary.Text = model.AUTH_NOTARY; // show hidden buttons this.buttonClientDelete.Visible = true; this.buttonClientSave.Visible = true; // show client number and status if existing this.labelClientId.Visible = true; this.textClientId.Visible = true; this.labelStatus.Visible = true; this.tеxtStatus.Visible = true; this.buttonClientSave.Text = "ОБНОВИ"; this.ChangeFormForPersonType(); }
/// <summary> /// Takes all information about client from form and creates data model /// </summary> private INVESTORS_FUNDS CreateModelFromForm() { var md = new INVESTORS_FUNDS(); // TODO: set user modified - use identity // TODO: create this here - do not use field! if (this.newClient) { md.CLIENTID_STRING = "noClString"; } else { md.CLIENTID_STRING = this.textClientId.Text; } md.CLIENTID = this._investorsFundsRepo.GetAll <int>(null, x => x.CLIENTID).Max() + 1; md.PERSONALID_BULSTAT = this.textId.Text; md.TYPE_PERSON = this.comboTypePerson.Text; md.EMPLOYEE_AUTHORISED = this.comboEmployee.Text; md.CD_REG = this.comboRegisterCd.Text; // address md.COUNTRY_ADDRESS_ID = this.comboMailCountry.Text; md.COUNTRY1 = this.comboPersCountry.Text; md.TOWN_ADDRESS_ID = this.comboMailTown.Text; md.TOWN1 = this.comboPersTown.Text; md.MUNICIPALITY = this.comboMailMunic.Text; md.STREET = this.textPersStreet.Text; md.ADDRESS_ID = this.textMailAddress.Text; md.RESIDENCE = this.textPersDistr.Text; md.STRNUM = this.textPersStrNum.Text; md.FLAT = this.textPersApt.Text; md.FLOOR1 = this.textPersFloor.Text; // person md.FIRSTNAME = this.textFirstName.Text; md.SECONDNAME = this.textMiddleName.Text; md.LASTNAME = this.textFamilyName.Text; md.CLIENT_BIRTHDATE = this.dateTimeBirthDate.Text; md.PERSONAL_ID = this.textPassportNumber.Text; md.PERSONAL_ID_DATE = this.dateTimePassportIssued.Text; md.PERSONAL_ID_ISSUED_BY = this.textPassportIssued.Text; // company md.FULL_NAME = this.textCompanyName.Text; md.ID_NUMBER_TAX_ID = this.textCompanyTaxId.Text; md.DDS_REGISTERED = this.comboDds.Text; md.TYPE_ORGANIZATION = this.comboOrgType.Text; // bank accounts md.IBAN1 = this.textIban1.Text; md.BIC1 = this.textBicCode1.Text; md.BANK1 = this.textBankName1.Text; md.IBAN2 = this.textIban2.Text; md.BIC2 = this.textBicCode2.Text; md.BANK2 = this.textBankName2.Text; md.IBAN3 = this.textIban3.Text; md.BIC3 = this.textBicCode3.Text; md.BANK3 = this.textBankName3.Text; // other data md.E_MAIL = this.textEmail.Text; md.TEL_FIXED = this.textPhone.Text; md.TEL_MOBILE = this.textMobile.Text; md.CD_GLOBID = int.Parse(this.textGlobalIdCd.Text); md.CD_BIC = this.textBicCodeCd.Text; // attorney data md.AUTHORISED_TYPE = this.textAttorneyType.Text; md.AUTHORISED_DOC = this.textAttorneyDoc.Text; md.AUTHORISED_DATE = this.dateTimeAttorney.Text; md.AUTH_NOTARY = this.textAttorneyNotary.Text; // select authorised md.CL_STATUS = "OK"; return(md); }
public ActionResult Register(ClientRegisterViewModel model) { var id = this.User.Identity.GetUserId(); if (!this.ModelState.IsValid) { return(this.View(model)); } // проверка за физическо или юридическо лице и създаване на FULL_NAME if (model.TYPE_PERSON == GlobalConstants.PerTypes[0] || model.TYPE_PERSON == GlobalConstants.PerTypes[2]) { model.FULL_NAME = model.FirmName; } else { model.FULL_NAME = $"{model.FIRSTNAME} {model.SECONDNAME} {model.LASTNAME}"; } // TODO: създаване на тези неща model.CREATED_BY = int.Parse(id); model.CREATED_WHEN = DateTime.Now.ToString(); var clientNewId = this.clients.GetNewId(); model.CLIENTID = clientNewId; var tempStr = "000000"; var i2 = tempStr.Length - clientNewId.ToString().Length; var tempstr2 = tempStr.Substring(0, i2); var clstring = "AC"; model.CLIENTID_STRING = clstring + tempstr2.ToString() + clientNewId.ToString(); /*Dim rst As ADODB.Recordset * myuser = conn_sql.myuser '' DLookup("[user]", "current_user") * 'mypass = DLookup("[pass]", "current_user") * Dim userid As Integer * userid = conn_sql.userid ''DLookup("[user_int]", "current_user") * 'Call CONNECT_SQL * 'conn.Open MYCONN * '''''''''''''''''''''''''''''''''''''''''''''''''''' * Dim udid As String * udid = conn_sql.udid '' Trim(DLookup("[udid]", "tblcurrentud")) * '''''''''''''''''''''''''''''''''''''''''''''''''''' * * * '//////////////////////////////////////////////////////////////// * Dim i As Double * rst = conn.Execute("exec sp_getmaxinvid") * If rst.EOF Then * i = 1 * Else * i = rst.Fields("max_id").Value * i = i + 1 * End If * * '//////////////////////////////////////////////////////////////// * 'GET USER CLIENT STRING * Dim clstring As String * rst = conn.Execute("exec sp_getuserstring " _ * & userid & "") * If rst.EOF Then * MsgBox("Не мога да намеря код за потребителя!") * Exit Sub * Else * clstring = rst.Fields("strindex").Value * End If * '/////////////////////////////////////////////////////////////// * Dim tempstr As String * Dim tempstr2 As String * Dim i2 As Integer * Dim clidstring As String * * * If udid = "AC" Then * tempstr = "000000" * i2 = Len(tempstr) - Len(Trim(i)) * tempstr2 = msvb.Left(tempstr, i2) * clidstring = clstring & "-" & tempstr2 & i * Else * tempstr = "000000" * i2 = Len(tempstr) - Len(Trim(i)) * tempstr2 = msvb.Left(tempstr, i2) * clidstring = clstring & tempstr2 & i * End If * * * '/////////////////////////////////////////////////////////////////// * Dim fullnm As String * If Me.cmbPERTYPE.Text = "БЪЛГАРСКО ФИЗИЧЕСКО ЛИЦЕ" Or Me.cmbPERTYPE.Text = "ЧУЖДО ФИЗИЧЕСКО ЛИЦЕ" Then * fullnm = Me.txtFNAME.Text & " " & Me.txtSNAME.Text & " " & Me.txtLNAME.Text * Else * fullnm = Me.txtNAME.Text * End If * '/////////////////////////////////////////////////////////////////// * Dim crwhen As Date * crwhen = Now() * '/////////////////////////////////////////////////////////////////// * * Dim dcit As String * If Me.checkRES.Checked = True Then * dcit = "YES" * Else * dcit = "NO" * End If*/ var newClient = new INVESTORS_FUNDS(); this.Mapper.Map(model, newClient); this.clients.CreateClient(newClient); return(this.RedirectToAction("Index", "Home")); }