private void LockerCabinetPage() { _cabinetStatus = "<> 'Disabled'"; string condition = "status {0} AND locker_type_id {1}"; condition = String.Format(condition, _cabinetStatus, _cabinetSize); _lockerCabinetPage.FinalIndex = Cabinet.Count(condition); _lockerCabinetPage.LastPage = Convert.ToInt32(Math.Ceiling(_lockerCabinetPage.FinalIndex / _lockerCabinetPage.MaxItems)); _lockerCabinetPage.PageSetting(); if (_lockerCabinetPage.FinalIndex == 0) { _lockerCabinetPage.PageReset(); } if (_lockerCabinetPage.PageNumber == _lockerCabinetPage.LastPage) { _lockerCabinetPage.LastIndex = (int)_lockerCabinetPage.FinalIndex; } toolStripLabelPageNoLockerCabinet.Text = String.Format("Page {0} / {1}", _lockerCabinetPage.PageNumber, _lockerCabinetPage.LastPage); ReloadLockerCabinetList(_lockerCabinetPage.IndexLimit, _lockerCabinetPage.MaxItems, condition); }
// Function to verify cabinet code public void CheckCabinet() { if (Cabinet.Count(String.Format("code = '{0}'", _cabinetCode)) <= 0) { throw new InvalidCabinetException("Invalid Cabinet", _cabinetCode); } }
public void DeleteLockerTypeData(int id) { // Check if any cabinet exists for this locker type. If yes, show error. if (Cabinet.Count(String.Format("locker_type_id = {0} AND status <> 'Disabled'", id)) > 0) { throw new InvalidUserInputException("Delete Error - Locker Type Cabinet"); } // Delete the locker type LockerType deletedLockerType = LockerType.Get(id); deletedLockerType.TempDelete(); }
public void ExportLockerTypeData(int id) { var delType = LockerType.Where(String.Format("id = {0}", id), 0, 1); string defaultFileName = String.Format("EXPORT_LOCKER_TYPE_{0}_{1}", id, DateTime.Now.ToString("ddMMyyyy_HHmmss")); int noOfCabinet = Cabinet.Count(String.Format("locker_type_id = {0}", id)); if (noOfCabinet > 0) { throw new InvalidUserInputException("Export Fail - Cabinet"); } var workbook = new XLWorkbook(); var ws = workbook.AddWorksheet("DeletedCabinet"); ws.Cell(1, 1).Value = "Locker Type"; ws.Cell(2, 1).InsertTable(delType); SaveFileDialog sf = new SaveFileDialog { FileName = defaultFileName, Filter = "Excel Workbook (.xlsx) |*.xlsx", Title = "Export Locker Type as", FilterIndex = 1 }; if (sf.ShowDialog() == DialogResult.OK) { string savePath = Path.GetDirectoryName(sf.FileName); string fileName = Path.GetFileName(sf.FileName); string saveFile = Path.Combine(savePath, fileName); try { workbook.SaveAs(saveFile); //Save the file delType[0].Delete(); } catch (Exception exception) { MessageBox.Show(exception.Message); throw new InvalidUserInputException("Export Fail", "", "", "locker type"); } } else { throw new InvalidUserInputException("Export Fail", "", "", "locker type"); } }