public UsedServicesInfoWindow(int Type, UsedService sv = null, int rentRoomID = -1)
{
this.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
InitializeComponent();
this.type = Type;
this.rentRoomID = rentRoomID;
if (sv != null)
{
this.UsedServices = sv;
}
else
{
this.UsedServices = new UsedService();
}
this.DataContext = this.bindingUsedServices;
if (type == EDITACTION)
{
switchToEditAction();
}
else if (type == ADDACTION)
{
switchToAddAction();
}
else
{
switchToInfoAction();
}
//this.DialogResult = false;
}
public void setDataToForm(UsedService UsedServices)
{
tbxID.Text = UsedServices.id.ToString();
tbxRentRoomID.Text = UsedServices.rentRoomID.ToString();
tbxStatus.Text = UsedServices.status.ToString();
var dateString = UsedServices.date.ToString();
dpDate.SelectedDate = UsedServices.date;
}
public UsedService getDataFromForm()
{
UsedService result = new UsedService();
//result.id = 0;// int.Parse( tbxID.Text);
result.rentRoomID = int.Parse(tbxRentRoomID.Text);
result.status = int.Parse(tbxStatus.Text);
result.date = dpDate.SelectedDate.Value;
return(result);
}
private void dgUsedServices_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
UsedService sv = dgUsedServices.SelectedItem as UsedService;
if (sv != null)
{
var screen = new UsedServicesInfoWindow(UsedServicesInfoWindow.INFOACTION, sv);
this.IsEnabled = false;
screen.ShowDialog();
this.IsEnabled = true;
}
LoadDuLieu();
}
public void switchToInfoAction()
{
type = INFOACTION;
lbTitle.Content = "Info Used Services";
spUsedServicesInfo.Visibility = Visibility.Visible;
spUsedServicesAE.Visibility = Visibility.Collapsed;
//data
if (type == INFOACTION)
{
UsedServices = getUsedServicesFromData(UsedServices.id);
tbID.Text = UsedServices.id.ToString();
tbRentRoomID.Text = UsedServices.rentRoomID.ToString();
tbStatus.Text = UsedServices.status.ToString();
tbDate.Text = UsedServices.date.ToString();
LoadUSDDetailsData(currentUSDDetailsPage);
}
}
private void btnDeleteUsedServices_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new RoomManagerEntities2())
{
this.IsEnabled = false;
var screen = new ConfirmWindow($"Ban Co Chac Muon Xoa Used Services {UsedServices.id}");
screen.ShowDialog();
if (screen.DialogResult == true)
{
var deleteItem = new UsedService()
{
id = UsedServices.id
};
var deleteDetailItem = new USDDetail()
{
usID = UsedServices.id
};
db.Entry(deleteDetailItem).State = EntityState.Modified;
db.USDDetails.Attach(deleteDetailItem);
db.USDDetails.Remove(deleteDetailItem);
db.SaveChanges();
switchToInfoAction();
//db.UsedServices.Attach(deleteItem);
//db.UsedServices.Remove(deleteItem);
//db.SaveChanges();
//this.Close();
}
this.IsEnabled = true;
}
}
catch (Exception ex)
{
this.IsEnabled = true;
MessageBox.Show("delete failure");
switchToInfoAction();
}
}
private void btnImportUsedServices_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
var wookbook = new Workbook(openFileDialog.FileName);
var tabs = wookbook.Worksheets;
using (var db = new RoomManagerEntities2())
{
foreach (var tab in tabs)
{
try
{
if (tab.Name == "Services")
{
var col = 'B';
var row = 2;
var cell = tab.Cells[$"{ col}{ row}"];
while (cell.Value != null)
{
var newUService = new UsedService()
{
rentRoomID = tab.Cells[$"B{row}"].IntValue,
date = tab.Cells[$"C{row}"].DateTimeValue,
status = tab.Cells[$"D{row}"].IntValue,
};
db.UsedServices.Add(newUService);
db.SaveChanges();
row++;
cell = tab.Cells[$"{ col}{ row}"];
}
LoadServicesData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
foreach (var tab in tabs)
{
try
{
if (tab.Name == "USDDetails")
{
var col = 'B';
var row = 2;
var cell = tab.Cells[$"{ col}{ row}"];
while (cell.Value != null)
{
var newUSDDetail = new USDDetail()
{
usID = tab.Cells[$"B{row}"].IntValue,
sID = tab.Cells[$"C{row}"].IntValue,
times = tab.Cells[$"D{row}"].IntValue,
price = tab.Cells[$"E{row}"].DoubleValue,
date = tab.Cells[$"F{row}"].DateTimeValue,
};
db.USDDetails
.Add(newUSDDetail);
db.SaveChanges();
row++;
cell = tab.Cells[$"{ col}{ row}"];
}
LoadServicesData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
