public List <GetPhoneCallsData> getPhoneCalls(String Date)
{
List <GetPhoneCallsData> PhoneCalls = new List <GetPhoneCallsData>();
connect();
MySqlCommand sql_cmd = new MySqlCommand(String.Format("SELECT pc.* FROM phone_calls pc LEFT JOIN call_status cs ON pc.PhoneCallId = cs.phoneCallId WHERE STR_TO_DATE(pc.DateEvent, '%d.%m.%Y') >= STR_TO_DATE('{0}', '%d.%m.%Y') AND cs.id IS NULL", Date), MySQL);
MySqlDataReader MyDataReader;
MyDataReader = sql_cmd.ExecuteReader();
int count = 0;
while (MyDataReader.Read())
{
try
{
GetPhoneCallsData phone_call = new GetPhoneCallsData();
if (!String.IsNullOrEmpty(MyDataReader.GetString("CompanyId").ToString()))
{
phone_call.CompanyId = new Guid(MyDataReader.GetString("CompanyId"));
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("CompanyName").ToString()))
{
phone_call.CompanyName = MyDataReader.GetString("CompanyName");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("PhoneCallId").ToString()))
{
phone_call.PhoneCallId = new Guid(MyDataReader.GetString("PhoneCallId"));
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("PhoneCallNr").ToString()))
{
phone_call.PhoneCallNr = MyDataReader.GetString("PhoneCallNr");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("Pin").ToString()))
{
phone_call.Pin = MyDataReader.GetString("Pin");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("CustomerName").ToString()))
{
phone_call.CustomerName = MyDataReader.GetString("CustomerName");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("Inn").ToString()))
{
phone_call.Inn = MyDataReader.GetString("Inn");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("Kpp").ToString()))
{
phone_call.Kpp = MyDataReader.GetString("Kpp");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("Email").ToString()))
{
phone_call.Email = MyDataReader.GetString("Email");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("BitrixId").ToString()))
{
phone_call.BitrixId = MyDataReader.GetString("BitrixId");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("ScheduledStart").ToString().Trim()))
{
phone_call.ScheduledStart = DateTime.Parse(MyDataReader.GetString("ScheduledStart"));
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("Overview").ToString()))
{
phone_call.Overview = MyDataReader.GetString("Overview");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("Priority").ToString()))
{
phone_call.Priority = MyDataReader.GetInt16("Priority");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("EventNr").ToString()))
{
phone_call.EventNr = MyDataReader.GetInt32("EventNr");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("DateEvent").ToString()))
{
phone_call.DateEvent = DateTime.Parse(MyDataReader.GetString("DateEvent").ToString());
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("ProductEvent").ToString()))
{
phone_call.ProductEvent = MyDataReader.GetString("ProductEvent");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("Phone").ToString()))
{
phone_call.Phone = MyDataReader.GetString("Phone");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("EventName").ToString()))
{
phone_call.EventName = MyDataReader.GetString("EventName");
}
if (!String.IsNullOrEmpty(MyDataReader.GetString("TimeDifference").ToString()))
{
phone_call.TimeDifference = MyDataReader.GetInt16("TimeDifference");
}
PhoneCalls.Add(phone_call);
} catch (Exception e)
{
}
count++;
}
MyDataReader.Close();
return(PhoneCalls);
}