public static int DeleteExEvent(ExEvent eventToDelete)
{
int rowsAffected = 0;
var conn = DatabaseConnection.GetExEventDatabaseConnection();
var cmdText = "spDeleteEvent";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@original_event_id", eventToDelete.eventID);
try
{
conn.Open();
rowsAffected = (int)cmd.ExecuteScalar();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(rowsAffected);
}
public static List <ExEvent> SelectEventsByAgent(int employeeID, string statusName, DateTime startDate, DateTime endDate)
{
var myList = new List <ExEvent>();
var conn = DatabaseConnection.GetExEventDatabaseConnection();
var query = "SELECT event_id, ex_event.employee_id, employee.employee_id, event_date, submission_date, activity_name, start_time, end_time, status_name, activity_note, completed_date, completed_by, first_name, last_name FROM ex_event, employee WHERE ex_event.employee_id = @employeeID AND status_name = @statusName AND event_date >= @startDate AND event_date < @endDate AND ex_event.employee_id = employee.employee_id";
var cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@employeeID", employeeID);
cmd.Parameters.AddWithValue("@statusName", statusName);
cmd.Parameters.AddWithValue("@startDate", startDate);
cmd.Parameters.AddWithValue("@endDate", endDate);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
throw new ApplicationException("No events found!");
}
while (reader.Read())
{
var item = new ExEvent();
item.eventID = reader.GetInt32(0);
item.employeeID = reader.GetInt32(2);
item.eventDate = reader.GetDateTime(3);
item.submissionDate = reader.GetDateTime(4);
item.activityName = reader.GetString(5);
item.startTime = reader.GetString(6);
item.endTime = reader.GetString(7);
item.duration = (Convert.ToDateTime(item.endTime) - Convert.ToDateTime(item.startTime)).ToString("hh\\:mm");
item.statusName = reader.GetString(8);
item.activityNote = reader.GetString(9);
if (!reader.IsDBNull(10))
{
item.completedDate = reader.GetDateTime(10);
}
if (!reader.IsDBNull(11))
{
item.completedBy = reader.GetString(11);
}
item.agentName = reader.GetString(13) + ", " + reader.GetString(12);
myList.Add(item);
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(myList);
}
// Запуск каждый кадр
void Update()
{
second -= Time.deltaTime;
if (second <= 0)
{
double offset = rand.Next(0, 10);
Progress += (speed * Shop.ad_mp + offset / 100); //генерация рандома в мозгах покупателя
second = 1;
}
if (Progress >= 1.0)
{
if (requestCount < MaxRequestCount)
{
if (selCustomer == 5)
{
selCustomer = 0;
}
Customers[selCustomer].transform.position = target.transform.position;
cashSecond -= Time.deltaTime;
if (cashSecond <= 0)
{
cashProgress += speed * Shop.cashier_mp;
}
if (cashProgress >= 1.0)
{
Customers[selCustomer].transform.position = target2.transform.position;
requestCount += 1;
requestHandler.requestQueue.Enqueue(genRequest());
Progress = 0;
cashProgress = 0;
}
}
else
{
Progress = 0;
}
// Debug.Log(requestCount);
}
daySecond -= Time.deltaTime;
if (daySecond <= 0)
{
daySecCounter--;
daySecond = 1;
Debug.Log(daySecCounter);
}
if (daySecCounter <= 0)
{
Shop.balance -= Shop.expenses;
daySecCounter = 120;
ExEvent?.Invoke();
Debug.Log(Shop.balance);
}
}
protected override void OnFormClosed(FormClosedEventArgs e)
{
ExCommand.FormToShow.IsFormOpen = false;
ExCommand.FormToShow = null;
ExEvent.Dispose();
ExEvent = null;
ExHandler = null;
base.OnFormClosed(e);
}
public static ExEvent SelectSingleEvent(int eventID)
{
var conn = DatabaseConnection.GetExEventDatabaseConnection();
var query = "SELECT employee_id, event_date, submission_date, activity_name, start_time, end_time, status_name, activity_note, completed_date, completed_by FROM ex_event WHERE event_id = @eventID";
var cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@eventID", eventID);
ExEvent myExEvent = new ExEvent();
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
myExEvent.eventID = eventID;
myExEvent.employeeID = reader.GetInt32(0);
myExEvent.eventDate = reader.GetDateTime(1);
myExEvent.submissionDate = reader.GetDateTime(2);
myExEvent.activityName = reader.GetString(3);
myExEvent.startTime = reader.GetString(4);
myExEvent.endTime = reader.GetString(5);
myExEvent.duration = (Convert.ToDateTime(myExEvent.endTime) - Convert.ToDateTime(myExEvent.startTime)).ToString("hh\\:mm");
myExEvent.statusName = reader.GetString(6);
myExEvent.activityNote = reader.GetString(7);
if (!reader.IsDBNull(8))
{
myExEvent.completedDate = reader.GetDateTime(8);
}
if (!reader.IsDBNull(9))
{
myExEvent.completedBy = reader.GetString(9);
}
}
else
{
var ax = new ApplicationException("Event not found!");
throw ax;
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(myExEvent);
}
public void UpdateExEventToPending(ExEvent oldE, ExEvent newE)
{
try
{
ExEventAccessor.UpdateSubmissionToPending(oldE, newE);
}
catch (Exception)
{
throw;
}
}
public static int UpdateSubmission(ExEvent oldE, ExEvent newE)
{
int rowsAffected = 0;
var conn = DatabaseConnection.GetExEventDatabaseConnection();
var cmdText = "spUpdateSubmission";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@event_id", newE.eventID);
cmd.Parameters.AddWithValue("@event_date", newE.eventDate);
cmd.Parameters.AddWithValue("@submission_date", newE.submissionDate);
cmd.Parameters.AddWithValue("@activity_name", newE.activityName);
cmd.Parameters.AddWithValue("@start_time", newE.startTime);
cmd.Parameters.AddWithValue("@end_time", newE.endTime);
cmd.Parameters.AddWithValue("@status_name", newE.statusName);
cmd.Parameters.AddWithValue("@activity_note", newE.activityNote);
cmd.Parameters.AddWithValue("@completed_date", newE.completedDate);
cmd.Parameters.AddWithValue("@completed_by", newE.completedBy);
cmd.Parameters.AddWithValue("@original_event_id", oldE.eventID);
cmd.Parameters.AddWithValue("@original_event_date", oldE.eventDate);
cmd.Parameters.AddWithValue("@original_submission_date", oldE.submissionDate);
cmd.Parameters.AddWithValue("@original_activity_name", oldE.activityName);
cmd.Parameters.AddWithValue("@original_start_time", oldE.startTime);
cmd.Parameters.AddWithValue("@original_end_time", oldE.endTime);
cmd.Parameters.AddWithValue("@original_status_name", oldE.statusName);
cmd.Parameters.AddWithValue("@original_activity_note", oldE.activityNote);
try
{
conn.Open();
rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new ApplicationException("Concurrency Exception:\\nYour record has been changed by another user.\nPlease refresh and try again.");
}
}
catch (Exception)
{
throw;
}
return(rowsAffected);
}
private void Click_b_Apply(object sender, RoutedEventArgs e)
{
try
{
if (ExEvent == null || EventHandler == null)
{
TaskDialog.Show("Error", "Click_b_Apply - ExEvent or EventHandler is null");
return;
}
SpatialElementBoundaryOptions option = new SpatialElementBoundaryOptions();
switch (cbb_BoundaryType.SelectedIndex)
{
case 0:
option.SpatialElementBoundaryLocation = SpatialElementBoundaryLocation.Finish;
break;
case 1:
option.SpatialElementBoundaryLocation = SpatialElementBoundaryLocation.Center;
break;
case 2:
option.SpatialElementBoundaryLocation = SpatialElementBoundaryLocation.CoreBoundary;
break;
case 3:
option.SpatialElementBoundaryLocation = SpatialElementBoundaryLocation.CoreCenter;
break;
}
float offset = 0.0f;
float.TryParse(tb_Offset.Text, out offset);
EventHandler.Rooms = m_rooms;
EventHandler.FloorType = cbb_FloorType.SelectedItem as Element;
EventHandler.Level = cbb_Level.SelectedItem as Element;
EventHandler.Option = option;
EventHandler.Offset = offset;
EventHandler.IsStructural = rb_IsStructural1.IsChecked.Value;
ExEvent.Raise();
}
catch (Exception ex)
{
TaskDialog.Show("CLICK_B_APPLY_ERROR", ex.Message);
}
}
public bool DeleteExEvent(ExEvent oldE)
{
try
{
if (ExEventAccessor.DeleteExEvent(oldE) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new ApplicationException("Update failed.", ex);
}
}
public static int InsertExEvent(ExEvent e)
{
var rowsAffected = 0;
var conn = DatabaseConnection.GetExEventDatabaseConnection();
string commandText = "INSERT INTO ex_event (event_date, employee_id, submission_date, activity_name, start_time, end_time, status_name, activity_note) VALUES (@event_date, @employee_id, @submission_date, @activity_name, @start_time, @end_time, @status_name, @activity_note)";
var cmd = new SqlCommand(commandText, conn);
cmd.Parameters.AddWithValue("@event_date", e.eventDate);
cmd.Parameters.AddWithValue("@employee_id", e.employeeID);
cmd.Parameters.AddWithValue("@submission_date", e.submissionDate);
cmd.Parameters.AddWithValue("@activity_name", e.activityName);
cmd.Parameters.AddWithValue("@start_time", e.startTime);
cmd.Parameters.AddWithValue("@end_time", e.endTime);
cmd.Parameters.AddWithValue("@status_name", e.statusName);
cmd.Parameters.AddWithValue("@activity_note", e.activityNote);
try
{
conn.Open();
rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
var up = new ApplicationException("Exception could not be submitted.");
throw up;
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(rowsAffected);
}
public bool AddExEvent(ExEvent newEvent)
{
int rows;
try
{
rows = ExEventAccessor.InsertExEvent(newEvent);
}
catch (Exception)
{
throw;
}
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}
private void Click_b_Cancel(object sender, RoutedEventArgs e)
{
ExEvent.Dispose();
this.Close();
}
