public static List<OrganizationExt> GetOrganizExt(DateTime dateFrom, DateTime dateTo)
{
List<OrganizationExt> orgList = new List<OrganizationExt>();
try
{
SqlConnection connection = OpenConnection();
if ((connection == null) || (connection.State == ConnectionState.Closed))
return null;
SqlCommand ngCommand = connection.CreateCommand();
ngCommand.CommandType = CommandType.StoredProcedure;
ngCommand.CommandText = GET_ORGANIZATIONSEXT_REGISRTY;
ngCommand.Parameters.AddWithValue("@dateFrom", dateFrom);
ngCommand.Parameters.AddWithValue("@dateTo", dateTo);
// ngCommand.CommandTimeout = CommandTimeOut > 2 * connection.ConnectionTimeout ? CommandTimeOut : 2 * connection.ConnectionTimeout;
ngCommand.ExecuteNonQuery();
SqlDataReader reader = null;
if (connection != null)
{
reader = ngCommand.ExecuteReader();
while (reader.Read())
{
OrganizationExt newOrg = new OrganizationExt();
newOrg.OrganizationName = (string)reader["Name"];
newOrg.OrganizationDescription = (string)reader["Description"];
newOrg.Adress = (string)reader["Adress"];
newOrg.Phone = (string)reader["Phone"];
newOrg.ID = (int)reader["ID"];
orgList.Add(newOrg);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CloseConnection();
return null;
}
CloseConnection();
return orgList;
}
private void repositoryItemButtonEditInfo_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
Cursor current = this.Cursor;
this.Cursor = Cursors.WaitCursor;
StatisticOrganizationForm form = new StatisticOrganizationForm();
List<OrganizationExt> journaitems = new List<OrganizationExt>();
Organization item = null;
OrganizationExt itemExt = null;
int[] selected = gridViewOrganizMain.GetSelectedRows();
if (selected.Length == 1)
{
item = ((Organization)gridViewOrganizMain.GetRow(selected[0]));
itemExt = new OrganizationExt(item);
}
if (item != null)
{
List<JournalItem> journalitems = DataProvider.DataProvider.GetJournalItemOrganizationExt(item.ID);
foreach (JournalItem itemjournal in journalitems)
{
List<JournalUslugiItem> journaluslugiitems = DataProvider.DataProvider.GetJournalUslugiItems(itemjournal.ID);
itemjournal.listUslugiJournal = journaluslugiitems;
}
itemExt.listJournal = journalitems;
journaitems.Add(itemExt);
}
form.SetBindItems(journaitems);
this.Cursor = current;
form.ShowDialog();
}
