private SerialNumberModel checkSerialNumber()
{
SerialNumberModel snm = new SerialNumberModel();
try
{
queryString = "SELECT ID, serialNumber FROM dbspa.tblserialnumber WHERE (ID =" +
"(SELECT MAX(ID) AS Expr1 FROM dbspa.tblserialnumber tblSerialNumber_1))";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
snm.ID1 = reader["ID"].ToString();
snm.SerialNumber = reader["serialNumber"].ToString();
}
conDB.closeConnection();
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
return(snm);
}
public IActionResult Get(SerialNumberModel model)
{
FilterContainer <SerialNumberRule> filter = FilterContainerBuilder.Build <SerialNumberRule>();
if (model.Name.IsNotEmpty())
{
filter.And(n => n.Name == model.Name);
}
if (model.GetAll)
{
model.Page = 1;
model.PageSize = 25000;
}
else if (CurrentUser.UserSettings.PagingLimit > 0)
{
model.PageSize = CurrentUser.UserSettings.PagingLimit;
}
PagedList <SerialNumberRule> result = _serialNumberRuleFinder.QueryPaged(x => x
.Page(model.Page, model.PageSize)
.Where(filter)
.Sort(n => n.OnFile(model.SortBy).ByDirection(model.SortDirection))
, SolutionId.Value, true);
model.Items = result.Items;
model.TotalItems = result.TotalItems;
model.SolutionId = SolutionId.Value;
return(JOk(model));
}
private void datePicker_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
{
SerialNumberModel serialN = checkSerialNumber();
string strD = "";
if (string.IsNullOrEmpty(clientModel.DateServiced))
{
strD = DateTime.Parse(datePicker.Text).ToShortDateString();
}
else
{
strD = DateTime.Parse(clientModel.DateServiced).ToShortDateString();
}
string dteNow = DateTime.Now.ToShortDateString();
string dteSelected = datePicker.Text;
if (string.IsNullOrEmpty(strD))
{
strD = DateTime.Now.ToShortDateString();
}
CODModel codnum = checkCODNumber(dteSelected);
if (!strD.Equals(dteNow))
{
txtCOD.Text = (Convert.ToInt32(codnum.COD1) + 1).ToString();
txtSerialNumber.Text = (Convert.ToInt32(serialN.SerialNumber) + 1).ToString();
}
}
public IActionResult Index(SerialNumberModel model)
{
if (!model.LoadData)
{
return(DynamicResult(model));
}
FilterContainer <SerialNumberRule> filter = FilterContainerBuilder.Build <SerialNumberRule>();
if (model.Name.IsNotEmpty())
{
filter.And(n => n.Name == model.Name);
}
if (model.GetAll)
{
model.Page = 1;
model.PageSize = WebContext.PlatformSettings.MaxFetchRecords;
}
else if (!model.PageSizeBySeted && CurrentUser.UserSettings.PagingLimit > 0)
{
model.PageSize = CurrentUser.UserSettings.PagingLimit;
}
model.PageSize = model.PageSize > WebContext.PlatformSettings.MaxFetchRecords ? WebContext.PlatformSettings.MaxFetchRecords : model.PageSize;
PagedList <SerialNumberRule> result = _serialNumberRuleFinder.QueryPaged(x => x
.Page(model.Page, model.PageSize)
.Where(filter)
.Sort(n => n.OnFile(model.SortBy).ByDirection(model.SortDirection))
, SolutionId.Value, true);
model.Items = result.Items;
model.TotalItems = result.TotalItems;
model.SolutionId = SolutionId.Value;
return(DynamicResult(model));
}
private async Task GetAndAssignDevice(string serialNumber)
{
if (string.IsNullOrEmpty(serialNumber))
{
Notify(ErrorCode.InternalError, "Did not receive serial number");
return;
}
try
{
DeviceResponse baseResponse = await Service.GetDevice(Token, serialNumber);
if (baseResponse == null || baseResponse.Error != ErrorCode.OK)
{
Notify(baseResponse);
MainWindow.Instance.ChangeView(new MenuView());
}
else
{
Device = baseResponse.RecievedDevice;
Document = Device.Document;
SerialNumber = new SerialNumberModel();
SerialNumber.SerialNumber = Device.SerialNumber;
Device.DeviceEvents.OrderByDescending(x => x.Date);
DeviceEvents = new ObservableCollection <DeviceEvent>();
if (Device.DeviceEvents != null)
{
Device.DeviceEvents.ForEach(x => DeviceEvents.Add(x));
}
}
}
catch (ServiceException ex)
{
//TODO: HIGH Add logging
Notify(ex.Message);
}
}
public SerialNumberEngineModelSpec()
{
EngineModelViewModel = new EngineModelModel();
SpecViewModel = new SpecModel();
SerialNumberViewModel = new SerialNumberModel();
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
int serial = 0;
if (!clientModel.IfEditDetails && !clientModel.IfViewDetails)
{
if (!ifAlreadySaved)
{
if (checkFields())
{
//Check user logged if admin or receptionist
if (user != null)
{
SerialNumberModel serialNum = checkSerialNumber();
CODModel codMod = checkCODNumber(datePicker.Text);
int x = Convert.ToInt32(codMod.COD1);
serial = Convert.ToInt32(serialNum.SerialNumber);
int numSerial = 0;
int numCod = 0;
if (user.Type == 1)
{
numSerial = Convert.ToInt32(txtSerialNumber.Text);
numCod = Convert.ToInt32(txtCOD.Text);
if (numSerial > serial)
{
serial = numSerial;
}
}
else
{
serial += 1;
}
//CHECK SERIAL NUMBER
insertSerialNumber((serial), datePicker.Text);
//CHECK COD
if (x == 0)
{
insertCODNumber(numCod);
}
else
{
if (user.Type == 1)
{
if (numCod > x)
{
updateCODNumber(numCod, Convert.ToInt32(codMod.ID1));
}
}
else
{
numCod = x + 1;
updateCODNumber(numCod, Convert.ToInt32(codMod.ID1));
}
}
//serial = serial + 1;
//x = x + 1;
if (insertClientRecord(serial.ToString(), numCod.ToString()))
{
updateClientView();
System.Windows.MessageBox.Show("Client Record Successfully Saved!");
this.Close();
}
}
else
{
//original code insertClientRecord((serial + 1), (x + 1))
if (insertClientRecord(txtSerialNumber.Text, txtCOD.Text))
{
updateClientView();
System.Windows.MessageBox.Show("Client Record Successfully Saved!");
this.Close();
}
}
}
}
else
{
System.Windows.MessageBox.Show("Client already exist!");
this.Close();
}
}
else
{
if (checkFieldsForUpdating())
{
if (user.Type == 1)
{
insertSerialNumber(Convert.ToInt32(txtSerialNumber.Text), txtDate.Text);
}
else
{
SerialNumberModel serialNum = checkSerialNumber();
serial = Convert.ToInt32(serialNum.SerialNumber);
serial += 1;
}
if (updateClientRecord(Convert.ToInt32(clientModel.ID1)))
{
System.Windows.MessageBox.Show("Record updated successfully!");
conDB.writeLogFile("SAVE CLIENT RECORD: UPDATED RECORD ID: " + clientModel.ID1);
updateClientView();
this.Close();
}
}
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
cmbLoyaltycards.Visibility = Visibility.Hidden;
txtDate.Visibility = Visibility.Hidden;
fillComboBoxServiceMode(cmbServiceMode);
timeInPicker.Text = DateTime.Now.ToShortTimeString();
timeOutPicker.IsEnabled = false;
if (user.Type > 1)
{
txtSerialNumber.IsEnabled = false;
txtCOD.IsEnabled = false;
}
else
{
txtSerialNumber.IsEnabled = true;
txtCOD.IsEnabled = true;
SerialNumberModel serialNum = checkSerialNumber();
txtSerialNumber.Text = (Convert.ToInt32(serialNum.SerialNumber) + 1).ToString();
CODModel codNum = checkCODNumber(DateTime.Now.ToShortDateString());
txtCOD.Text = (Convert.ToInt32(codNum.COD1) + 1).ToString();
}
if (clientModel != null)
{
//fillComboBoxServiceMode(cmbServiceMode);
fillLoyaltyCards();
if (clientModel.IfViewDetails)
{
datePicker.Visibility = Visibility.Hidden;
lblDate.Visibility = Visibility.Visible;
txtDate.Visibility = Visibility.Visible;
btnDeleteProduct.IsEnabled = false;
InitializeDetails();
cmbServiceMode.IsEnabled = false;
txtSerialNumber.IsEnabled = false;
txtCOD.IsEnabled = false;
timeInPicker.IsEnabled = false;
timeOutPicker.IsEnabled = false;
if (string.IsNullOrEmpty(clientModel.TimeOut) || string.IsNullOrWhiteSpace(clientModel.TimeOut))
{
timeOutPicker.Visibility = Visibility.Hidden;
}
else
{
timeOutPicker.Text = clientModel.TimeOut;
}
if (Convert.ToInt32(clientModel.LoyaltyID) > 0)
{
cmbLoyaltycards.Visibility = Visibility.Hidden;
chkAvailLoyalty.Visibility = Visibility.Hidden;
}
txtFirstName.IsEnabled = false;
txtLastName.IsEnabled = false;
txtAddress.IsEnabled = false;
txtPhoneNumber.IsEnabled = false;
txtDate.IsEnabled = false;
btnSave.IsEnabled = false;
btnDelete.IsEnabled = false;
btnAdd.IsEnabled = false;
btnEdit.IsEnabled = false;
btnAddProduct.IsEnabled = false;
}
else if (clientModel.IfEditDetails)
{
datePicker.Visibility = Visibility.Visible;
lblDate.Visibility = Visibility.Visible;
txtDate.Visibility = Visibility.Hidden;
txtDate.Visibility = Visibility.Hidden;
InitializeDetails();
txtFirstName.IsEnabled = true;
txtLastName.IsEnabled = true;
txtAddress.IsEnabled = true;
txtPhoneNumber.IsEnabled = true;
timeOutPicker.IsEnabled = true;
if (Convert.ToInt32(clientModel.LoyaltyID) > 0)
{
cmbLoyaltycards.Visibility = Visibility.Hidden;
chkAvailLoyalty.Visibility = Visibility.Hidden;
}
if (string.IsNullOrEmpty(clientModel.TimeOut) || string.IsNullOrWhiteSpace(clientModel.TimeOut))
{
//Initialize Time Out picker
//timeOutPicker.Format = DateTimePickerFormat.Custom;
//timeOutPicker.CustomFormat = "hh:mm tt"; // Only use hours and minutes
//timeOutPicker.ShowUpDown = true;
}
else
{
timeOutPicker.Text = clientModel.TimeOut;
}
btnSave.IsEnabled = true;
btnDelete.IsEnabled = true;
btnAdd.IsEnabled = true;
}
}
}
