public object NewCustomer(MusteriViewModel model)
{
try
{
var db = new CustomerDatabaseEntities();
db.Customers.Add(new Customer()
{
AdSoyad = model.AdSoyad,
Cinsiyet = model.Cinsiyet,
Adres = model.Adres,
DogumTarihi = model.DogumTarihi,
YasadigiSehir = model.YasadigiSehir,
Email = model.Email,
Meslek = model.Meslek,
Telefon = model.Tel,
ReklamMaili = model.ReklamMaili,
WebSite = model.WebSite,
Notlar = model.Notlar
});
db.SaveChanges();
return(new
{
success = true
});
}
catch (Exception ex)
{
return(new
{
success = false,
message = ex.Message
});
}
}
public object UpdateCustomer(MusteriViewModel model)
{
try
{
var db = new CustomerDatabaseEntities();
var cus = db.Customers.Find(model.Id);
cus.AdSoyad = model.AdSoyad;
cus.Cinsiyet = model.Cinsiyet;
cus.DogumTarihi = model.DogumTarihi;
cus.YasadigiSehir = model.YasadigiSehir;
cus.Email = model.Email;
cus.Meslek = model.Meslek;
cus.Telefon = model.Tel;
cus.ReklamMaili = model.ReklamMaili;
cus.WebSite = model.WebSite;
cus.Notlar = model.Notlar;
db.SaveChanges();
return(new
{
success = true
});
}
catch (Exception ex)
{
return(new
{
success = false,
message = ex.Message
});
}
}
/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Customer_Details newRecord = args.RowData as Customer_Details;
if (sender == null)
{
return;
}
Customer_Details order = context.Customer_Details.First(i => i.customerID == newRecord.customerID);
if (newRecord != null)
{
order.customerID = newRecord.customerID;
order.email = newRecord.email;
order.password = newRecord.password;
order.firstName = newRecord.firstName;
order.lastName = newRecord.lastName;
order.address = newRecord.address;
order.city = newRecord.city;
order.state = newRecord.state;
order.postcode = newRecord.postcode;
order.dateOfBirth = newRecord.dateOfBirth;
order.dateCreated = newRecord.dateCreated;
}
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Saves changes to the database
/// </summary>
/// <returns>Boolean value</returns>
private bool SaveCustomerChanges()
{
//Assign a context value
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//Set the initial value to false
bool output = false;
//Assigns the value of the helper class to the class
bool isNull = ArePropertiesNotNull(CurrentCustomer);
//Checks if helper class returns true or false
if (isNull)
{
CurrentCustomer.email = Email.Trim();
CurrentCustomer.password = Password.Trim();
CurrentCustomer.firstName = FirstName.Trim();
CurrentCustomer.lastName = LastName.Trim();
CurrentCustomer.phoneNumber = PhoneNumber;
CurrentCustomer.address = Address.Trim();
CurrentCustomer.city = City.Trim();
CurrentCustomer.state = State.Trim();
CurrentCustomer.postcode = Postcode;
CurrentCustomer.dateOfBirth = DateOfBirth;
CurrentCustomer.dateCreated = DateTime.Now;
context.Customer_Details.Add(CurrentCustomer);
context.SaveChanges();
output = true;
return(output);
}
return(output);
}
/// <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;
}
Customer_Ticket_Details order = context.Customer_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();
}
/// <summary>
/// Edit rows
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidatedForCustomerTransactions(object sender, RowValidatedEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Customer_Transaction newRecord = args.RowData as Customer_Transaction;
if (sender == null)
{
return;
}
Customer_Transaction order = context.Customer_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>
/// Changes record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
Employee_Details newRecord = args.RowData as Employee_Details;
Employee_Details order = context.Employee_Details.First(i => i.employeeID == newRecord.employeeID);
order.employeeID = newRecord.employeeID;
order.email = newRecord.email;
order.password = newRecord.password;
order.firstName = newRecord.firstName;
order.lastName = newRecord.lastName;
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
/// <summary>
/// Adds record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
Ticket_Details newRecord = args.RowData as Ticket_Details;
Ticket_Details order = context.Ticket_Details.First(i => i.ticketId == newRecord.ticketId);
order.ticketId = newRecord.ticketId;
order.eventTitle = newRecord.eventTitle;
order.eventStart = newRecord.eventStart;
order.eventEnd = newRecord.eventEnd;
order.price = newRecord.price;
order.seatLocation = newRecord.seatLocation;
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeleting(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Employee_Details;
var id = item.employeeID;
var email = item.email;
var password = item.password;
var firstName = item.firstName;
var lastName = item.lastName;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeleting(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Ticket_Details;
var id = item.ticketId;
var title = item.eventTitle;
var start = item.eventStart;
var end = item.eventEnd;
var price = item.price;
var seatLocation = item.seatLocation;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeletingForCustomerTransactions(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Customer_Transaction;
var transactionId = item.transactionId;
var email = item.email;
var eventAddress = item.eventAddress;
var fullname = item.fullname;
var eventName = item.eventName;
var totalPrice = item.totalPrice;
var address = item.address;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// A function which attempts to save values to the database
/// </summary>
/// <returns>Boolean values</returns>
private bool SaveCustomerChanges()
{
//Initialization of bool
bool output = false;
//Assigns the value of the helper class to the class
bool isNull = ArePropertiesNotNull(CurrentEvent);
//Assign a context value
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
//If the check for not null is not true
if (!isNull)
{
//Using the helper function which converts the image to bytes
byte[] imageBytes = ConvertImageToByteArray(ImagePathOfEventImage);
byte[] imageBytes2 = ConvertImageToByteArray(ImagePathOfEventLayout);
#region Saving to the database
CurrentEvent.eventPicture = imageBytes;
CurrentEvent.eventLayout = imageBytes2;
CurrentEvent.eventGenre = EventGenre.Trim();
CurrentEvent.eventTitle = EventTitle.Trim();
CurrentEvent.showOnHomePage = ShowOnHomePage.Value;
CurrentEvent.eventDescription = EventDescription.Trim();
CurrentEvent.eventStart = EventStart;
CurrentEvent.eventEnd = EventEnd;
CurrentEvent.capacity = Capacity;
CurrentEvent.eventLocation = EventLocation.Trim();
CurrentEvent.eventAddress = EventAddress.Trim();
context.Event_Details.Add(CurrentEvent);
//Save changes to the database
context.SaveChanges();
context.Dispose();
#endregion
//Return true if this function succeeds
output = true;
return(output);
}
//Otherwise return false
return(output);
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeletingForTickets(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Guest_Ticket_Details;
var ticketId = item.ticketId;
var email = item.email;
var eventAddress = item.eventAddress;
var fullName = item.fullName;
var eventName = item.eventName;
var placeName = item.placeName;
var price = item.price;
var seatLocation = item.seatLocation;
var timeEnd = item.timeEnd;
var timeStart = item.timeStart;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Adds record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs args)
{
Event_Details newRecord = args.RowData as Event_Details;
Event_Details order = context.Event_Details.First(i => i.eventID == newRecord.eventID);
order.eventID = newRecord.eventID;
order.eventAddress = newRecord.eventAddress;
order.eventDescription = newRecord.eventDescription;
order.capacity = newRecord.capacity;
order.eventStart = newRecord.eventStart;
order.eventEnd = newRecord.eventEnd;
order.eventLocation = newRecord.eventLocation;
order.eventPicture = newRecord.eventPicture;
order.eventTitle = newRecord.eventTitle;
order.eventGenre = newRecord.eventGenre;
order.showOnHomePage = newRecord.showOnHomePage;
context.Entry(order).State = EntityState.Modified;
context.SaveChanges();
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeleting(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Event_Details;
var id = item.eventID;
var address = item.eventAddress;
var description = item.eventDescription;
var capacity = item.capacity;
var eventStart = item.eventStart;
var eventEnd = item.eventEnd;
var eventPic = item.eventPicture;
var eventTitle = item.eventTitle;
var eventGenre = item.eventGenre;
var showOnHomePage = item.showOnHomePage;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
/// <summary>
/// Delete record
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void dataGrid_RecordDeleting(object sender, RecordDeletingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
var item = args.Items[0] as Customer_Details;
var id = item.customerID;
var email = item.email;
var password = item.password;
var firstName = item.firstName;
var lastName = item.lastName;
var address = item.address;
var city = item.city;
var state = item.state;
var postcode = item.postcode;
var dateOfBirth = item.dateOfBirth;
var dateCreated = item.dateCreated;
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
context.Dispose();
}
public void SfDataGrid1_RowValidating(object sender, Syncfusion.UI.Xaml.Grid.RowValidatingEventArgs args)
{
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
Employee_Details newRecord = args.RowData as Employee_Details;
Employee_Details currentEmployee = new Employee_Details();
if (newRecord != null)
{
currentEmployee.employeeID = newRecord.employeeID;
currentEmployee.email = newRecord.email;
currentEmployee.password = newRecord.password;
currentEmployee.firstName = newRecord.firstName;
currentEmployee.lastName = newRecord.lastName;
}
using (context)
{
context.Employee_Details.Add(currentEmployee);
context.SaveChanges();
context.Dispose();
}
}
/// <summary>
/// A function which returns a boolean
/// value if the generation of tickets
/// is correct
/// </summary>
/// <returns>Boolean value</returns>
private bool SaveChanges()
{
//Gets a value for the number of tickets
int numberOfTickets = LevelOneCapacity;
//Set the initial value to false
bool output = false;
//Loop for generating tickets
for (int i = 1; i < numberOfTickets + 1; i++)
{
//Based on the context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
#region Adding tickets to database
CurrentTicket.eventTitle = EventTitle;
CurrentTicket.price = LevelOnePrice;
CurrentTicket.seatLocation = LevelOneChar + i;
CurrentTicket.eventStart = EventStartLevelOne;
CurrentTicket.eventEnd = EventEndLevelOne;
context.Ticket_Details.Add(CurrentTicket);
context.SaveChanges();
context.Dispose();
#endregion
}
//Assigning a value to level 2
string levelTwoChar = LevelTwoChar;
decimal levelTwoPrice = LevelTwoPrice;
int levelTwoCapacity = LevelTwoCapacity;
//Checks if any of these values are zero. If not continue however return true (since level one tickets succeeded )
if (levelTwoChar == null || levelTwoPrice == 0 || levelTwoCapacity == 0)
{
return(true);
}
//If the level two capacity is above zero (ie there are tickets to generate)
if (levelTwoCapacity > 0)
{
//Loop for generating level 2 tickets
for (int i = 1; i < LevelTwoCapacity + 1; i++)
{
//Based on the database context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
#region Adding tickets and saving to database
CurrentTicket.eventTitle = EventTitle;
CurrentTicket.price = LevelTwoPrice;
CurrentTicket.seatLocation = LevelTwoChar + i;
CurrentTicket.eventStart = EventStartLevelOne;
CurrentTicket.eventEnd = EventEndLevelOne;
context.Ticket_Details.Add(CurrentTicket);
context.SaveChanges();
context.Dispose();
#endregion
}
}
//Assigning values to level 3
string levelThreeChar = LevelThreeChar;
int levelThreeCapacity = LevelThreeCapacity;
decimal levelThreePrice = LevelThreePrice;
//Checks if any of these values are zero. If not continue however return true (since level two tickets succeeded )
if (levelThreeChar == null || levelThreePrice == 0 || levelThreeCapacity == 0)
{
return(true);
}
//If the level three capacity is above zero (ie there are tickets to generate)
if (levelThreeCapacity > 0)
{
//Loop for generating tickets
for (int i = 1; i < levelThreeCapacity + 1; i++)
{
//Assign the database context
CustomerDatabaseEntities context = new CustomerDatabaseEntities();
#region Saving to database
CurrentTicket.eventTitle = EventTitle;
CurrentTicket.price = LevelThreePrice;
CurrentTicket.seatLocation = LevelThreeChar + i;
CurrentTicket.eventStart = EventStartLevelOne;
CurrentTicket.eventEnd = EventEndLevelOne;
context.Ticket_Details.Add(CurrentTicket);
context.SaveChanges();
context.Dispose();
#endregion
}
}
//Return true
output = true;
return(output);
}
