public OrganizationExt(Organization org) { this.Adress = org.Adress; this.ID = org.ID; this.OrganizationDescription = org.OrganizationDescription; this.OrganizationName = org.OrganizationName; this.Phone = org.Phone; this.listJournal = null; this.listClients = null; }
private void btnAddClient_Click(object sender, EventArgs e) { int[] rowsSel=gridViewSearchClient.GetSelectedRows(); if (rowsSel.Length == 1) { organization = (Organization)gridViewSearchClient.GetRow(rowsSel[0]); this.DialogResult = DialogResult.OK; } else { //выберите строку } }
public EditOrganForm(Organization organizationTo) { InitializeComponent(); try { if (organizationTo != null) { textEditAdress.Text = organizationTo.Adress; textEditPhone.Text = organizationTo.Phone; textEditName.Text = organizationTo.OrganizationName; memoEditDescription.Text = organizationTo.OrganizationDescription; organizationToAdd.ID = organizationTo.ID; } } catch (Exception ex) { } }
public static List<Organization> GetOrganizations() { List<Organization> orgList = new List<Organization>(); try { SqlConnection connection = OpenConnection(); if ((connection == null) || (connection.State == ConnectionState.Closed)) return null; SqlCommand ngCommand = connection.CreateCommand(); ngCommand.CommandType = CommandType.StoredProcedure; ngCommand.CommandText = GET_ORGANIZATIONS_REGISRTY; // ngCommand.CommandTimeout = CommandTimeOut > 2 * connection.ConnectionTimeout ? CommandTimeOut : 2 * connection.ConnectionTimeout; ngCommand.ExecuteNonQuery(); SqlDataReader reader = null; if (connection != null) { reader = ngCommand.ExecuteReader(); while (reader.Read()) { Organization newOrganization = new Organization(); newOrganization.OrganizationName = (string)reader["Name"]; newOrganization.ID = (int)reader["ID"]; newOrganization.OrganizationDescription = (string)reader["Description"]; newOrganization.Phone = (string)reader["Phone"]; newOrganization.Adress = (string)reader["Adress"]; orgList.Add(newOrganization); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); CloseConnection(); return null; } CloseConnection(); return orgList; }