private void repositoryItemButtonEditPlus_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
StatisticClientForm form = new StatisticClientForm();
List<ClientExt> journaitems = new List<ClientExt>();
Client item = null;
ClientExt itemExt = null;
int[] selected = gridViewClientMain.GetSelectedRows();
if (selected.Length == 1)
{
item = ((Client)gridViewClientMain.GetRow(selected[0]));
itemExt = new ClientExt(item);
}
if (item != null)
{
List<JournalItem> journalitems = DataProvider.DataProvider.GetJournalItemClientsExt(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);
form.ShowDialog();
}
public static List<ClientExt> GetClientsExt(DateTime dateFrom, DateTime dateTo, bool isAll)
{
List<ClientExt> clientList = new List<ClientExt>();
try
{
SqlConnection connection = OpenConnection();
if ((connection == null) || (connection.State == ConnectionState.Closed))
return null;
SqlCommand ngCommand = connection.CreateCommand();
ngCommand.CommandType = CommandType.StoredProcedure;
ngCommand.CommandText = GET_CLIENTSEXT_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())
{
ClientExt newClient = new ClientExt();
newClient.Name = (string)reader["Name"];
newClient.SurName = (string)reader["Surname"];
newClient.SecondName = (string)reader["SecondName"];
newClient.Phone = (string)reader["Phone"];
newClient.ID = (int)reader["ID"];
clientList.Add(newClient);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CloseConnection();
return null;
}
CloseConnection();
return clientList;
}