/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidatedForCustomerTransactions(object sender, RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Guest_Transaction newRecord = args.RowData as Guest_Transaction;
if (sender == null)
{
return;
}
Guest_Transaction order = context.Guest_Transaction.First(i => i.transactionId == newRecord.transactionId);
if (newRecord != null)
{
order.transactionId = newRecord.transactionId;
order.email = newRecord.email;
order.eventAddress = newRecord.eventAddress;
order.fullName = newRecord.fullName;
order.eventName = newRecord.eventName;
order.totalPrice = newRecord.totalPrice;
order.address = newRecord.address;
}
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidatedForCustomerTickets(object sender, RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Customer_Ticket_Details newRecord = args.RowData as Customer_Ticket_Details;
if (sender == null)
{
return;
}
Guest_Ticket_Details order = context.Guest_Ticket_Details.First(i => i.ticketId == newRecord.ticketId);
if (newRecord != null)
{
order.ticketId = newRecord.ticketId;
order.email = newRecord.email;
order.eventAddress = newRecord.eventAddress;
order.fullName = newRecord.fullName;
order.eventName = newRecord.eventName;
order.placeName = newRecord.placeName;
order.price = newRecord.price;
order.seatLocation = newRecord.seatLocation;
order.timeEnd = newRecord.timeEnd;
order.timeStart = newRecord.timeStart;
}
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
context.Dispose();
}
private void AccesoriesDataGrid_RowValidated(object sender, RowValidatedEventArgs args)
{
var accesory = (args.RowData as Accessory);
var objResult = accesory.Id == 0 ? getManager.Accessory.Add(accesory) : getManager.Accessory.Modify(accesory);
if (objResult.Success)
{
getManager.Provider.SaveChanges();
}
else
{
//Manejar Excepciones
}
}
private void MechanicDataGrid_RowValidated(object sender, RowValidatedEventArgs args)
{
var mechanic = (args.RowData as Mechanic);
var objResult = mechanic.Id == 0 ? getManager.Mechanic.Add(mechanic) : getManager.Mechanic.Modify(mechanic);
if (objResult.Success)
{
getManager.Provider.SaveChanges();
}
else
{
//Manejar Excepciones
}
}
private void ClientsDataGrid_RowValidated(object sender, RowValidatedEventArgs args)
{
var client = (args.RowData as Client);
var objResult = client.Id == 0 ? getManager.Client.Add(client) : getManager.Client.Modify(client);
if (objResult.Success)
{
getManager.Client.SaveChanges();
}
else
{
//Manejar Excepciones
}
}
private void UserDataGrid_RowValidated(object sender, RowValidatedEventArgs args)
{
var user = (args.RowData as User);
var objResult = user.Id == 0 ? getManager.User.Add(user) : getManager.User.Modify(user);
if (objResult.Success)
{
getManager.User.SaveChanges();
}
else
{
//Manejar Excepciones
}
}
private void ServiceDataGrid_RowValidated(object sender, RowValidatedEventArgs args)
{
var service = (args.RowData as Service);
var objResult = service.Id == 0 ? getManager.Service.Add(service) : getManager.Service.Modify(service);
if (objResult.Success)
{
getManager.Service.SaveChanges();
// ServiceDataGrid.ItemsSource=getManager.Service.Get().ToList();
}
else
{
//Manejar Excepciones
}
}
//Event customization.
private void sfdatagrid_RowValidated(object sender, RowValidatedEventArgs e)
{
var addNewRow = this.datagrid.RowGenerator.Items.FirstOrDefault(item => item.RowType == RowType.AddNewRow);
if (datagrid.IsAddNewIndex(e.RowIndex))
{
datagrid.Dispatcher.BeginInvoke(new Action(() =>
{
datagrid.SelectedItem = e.RowData;
//To move the current cell.
datagrid.ScrollInView(datagrid.SelectionController.CurrentCellManager.CurrentRowColumnIndex);
usetransition = true;
//To change the AddNewRow state.
VisualStateManager.GoToState(addNewRow.Element, "Normal", usetransition);
usetransition = false;
}));
}
}
private void ProviderDataGrid_RowValidated(object sender, RowValidatedEventArgs args)
{
var provider = (args.RowData as Provider);
if (provider == null)
{
return;
}
var objResult = provider.Id == 0 ? getManager.Provider.Add(provider) : getManager.Provider.Modify(provider);
if (objResult.Success)
{
getManager.Provider.SaveChanges();
}
else
{
//Manejar Excepciones
}
}
/**
* The grid insertion or adding, we need to move between two states:
* When it gets the event add new row,
* we get the new row event and move the grid operation to insert,
* later when we are in a validation row, we validate the row and that's it.
*/
private static void CurrentDataGrid_RowValidated(object sender, RowValidatedEventArgs e)
{
SfDataGrid dataGrid = sender as SfDataGrid;
DependencyObject dependencyObject = sender as DependencyObject;
var command = dataGrid?.GetValue(ItemChangedCommandProperty) as ICommand;
List <object> value = new List <object>();
if ((command != null) && (dataGrid != null))
{
var dataValue = dataGrid.GetRecordAtRowIndex(e.RowIndex);
var rowState = GetGridOperation(dependencyObject);
if (dataValue != null)
{
BaseDto dto = dataValue as BaseDto;
if (dto != null)
{
dto.LastModification = DateTime.Now.ToLongTimeString();
dto.IsNew = (rowState == GridOp.Insert) ? true : false;
dto.IsDirty = true;
}
}
var collection = dataGrid.View.SourceCollection;
if (collection is IEnumerable <BaseDto> dtoArray)
{
if (dtoArray.Count() == 0)
{
return;
}
}
foreach (var c in collection)
{
BaseDto v = c as BaseDto;
if (v != null)
{
if (v.IsNew)
{
value.Add(c);
}
else if (v.IsDirty)
{
value.Add(c);
}
else if (v.IsDeleted)
{
value.Add(c);
}
}
}
IDictionary <string, object> objectName = new Dictionary <string, object>();
value.Add(dataValue);
objectName["DataObject"] = GetDataSource(dataGrid);
objectName["DataSourcePath"] = GetDataSourcePath(dataGrid);
objectName["ChangedValue"] = value;
objectName["PreviousValue"] = _lastChangedRow;
objectName["Operation"] = rowState;
objectName["DeletedItems"] = false;
objectName["LastRowId"] = dataGrid.GetLastRowIndex();
_lastChangedRow = dataGrid.GetRecordAtRowIndex(e.RowIndex);
command.Execute(objectName);
SwitchToUpdate(dependencyObject, rowState);
}
}
private void gvMain_RowValidated_1(object sender, RowValidatedEventArgs e)
{
CurrentRow = e.RowIndex;
}
private void radGridView1_RowValidated(object sender, RowValidatedEventArgs e)
{
this.radGridView1.Tag = null;
}
