protected virtual void BackupOrRestore()
{
MessageBoxs msg = new MessageBoxs();
IvsMessage message = null;
if (isBackup)
{
message = new IvsMessage("SYBK00_008");
}
else
{
message = new IvsMessage("SYRT00_002");
}
msg.Add(message);
CommonData.MessageTypeResult result = msg.Display(CommonData.MessageType.YesNo);
if (result == CommonData.MessageTypeResult.Yes)
{
//this.service = new Ivs.Core.Services.Services();
//this.service.Credentials = System.Net.CredentialCache.DefaultCredentials;
//this.service.BackupOrRestoreCompleted += new Ivs.Core.Services.BackupOrRestoreCompletedEventHandler(service_BackupOrRestoreCompleted);
//this.service.BackupOrRestoreAsync(this.isBackup, this.txtPath.Text);
//backupService.BackupOrRestore(this.isBackup, this.txtPath.Text);
this.btnOK.Enabled = false;
}
}
/// <summary>
/// Cancel document
/// </summary>
protected virtual void Cancel()
{
if (btnCancel.Visibility == DevExpress.XtraBars.BarItemVisibility.Never || btnCancel.Enabled == false)
{
return;
}
this.MessageBox = new MessageBoxs();
IvsMessage message = new IvsMessage(CommonConstantMessage.COM_MSG_CONFIRM_CANCEL);
this.MessageBox.Add(message);
CommonData.MessageTypeResult result = this.MessageBox.Display(CommonData.MessageType.YesNo);
if (result == CommonData.MessageTypeResult.Yes)
{
this.MessageBox = new MessageBoxs();
StockTransactionBl stockTransactionBl = new StockTransactionBl();
StockResult stockResult = stockTransactionBl.Cancel((ST_StockTransactionMasterDto)this.Dto);
if (stockResult.ReturnCode == CommonData.StockReturnCode.Succeed)
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_CANCEL_SUCCESSFULLY);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
this.CloseForm();
}
else
{
lblErrorMessage.Text = ProcessStockException(stockResult);
}
}
}
private void IsValidFocusedRow(ST_StockTransactionDetailDto detailDto)
{
#region Set validate
/// <summary>
/// Item Code must be fill in
///</summary>
if (string.IsNullOrEmpty(detailDto.ItemCode))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, bandItemCode.Caption);
dgcAdjustment.SetColumnErrorBandedGridView(colItemCode.FieldName, msg.MessageText);
_isValid = false;
}
/// <summary>
/// Item Code must be fill in
///</summary>
if (string.IsNullOrEmpty(detailDto.QualityStatus))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, BandQuality.Caption);
dgcAdjustment.SetColumnErrorBandedGridView(colQuality.FieldName, msg.MessageText);
_isValid = false;
}
/// <summary>
/// Quantity must be greater than 0
///</summary>
if (detailDto.InputQuantity == null || detailDto.InputQuantity <= 0)
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, bandQty.Caption);
dgcAdjustment.SetColumnErrorBandedGridView(colQuatity.FieldName, msg.MessageText);
_isValid = false;
}
/// <summary>
/// Item Code must be fill in
///</summary>
if (string.IsNullOrEmpty(detailDto.Remark))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, bandReason.Caption);
dgcAdjustment.SetColumnErrorBandedGridView(colReason.FieldName, msg.MessageText);
_isValid = false;
}
/// <summary>
/// ProductLine must be fill in when Type is WIP
///</summary>
if (CommonMethod.ParseString(detailDto.ProcessType).Equals(CommonData.ProcessType.WIP) && CommonMethod.IsNullOrEmpty(detailDto.ProductionLine))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, BandProductionLine.Caption);
dgcAdjustment.SetColumnErrorBandedGridView(colProductionLine.FieldName, msg.MessageText);
_isValid = false;
}
#endregion Set validate
}
protected virtual ActionResult BaseCopy(IModel model)
{
this.Model = model;
if (ModelState.IsValid)
{
IvsMessage message = null;
int returnCode = Bl.InsertData(this.Model);
if (returnCode == CommonData.DbReturnCode.Succeed)
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_UPDATE_SUCCESSFULLY);
TempData[CommonData.MessageArea.MsgContent] = message.MessageText;
return(RedirectToAction("Index", this.CurrentController));
}
else
{
ProcessDbExcetion(returnCode);
//ModelState.AddModelError(CommonData.MessageArea.MsgContent, CommonMethod.ProcessDbExcetion(returnCode));
//TempData[CommonData.MessageArea.MsgContent] = CommonMethod.ProcessDbExcetion(returnCode);
}
}
SetEditControlData();
return(View("Edit", this.Layout, this.Model));
}
public ValidationResult(int rowIndex, string fieldName, CommonData.IsValid isValid, string messageId)
{
this._rowIndex = rowIndex;
this._fieldName = fieldName;
this._isValid = isValid;
this._message = new IvsMessage(messageId);
}
protected virtual string ProcessDbExcetion(int returnCode)
{
IvsMessage message = null;
switch (returnCode)
{
case CommonData.DbReturnCode.AccessDenied:
message = new IvsMessage(CommonConstantMessage.COM_MSG_ACCESS_DENIED);
break;
case CommonData.DbReturnCode.InvalidHost:
message = new IvsMessage(CommonConstantMessage.COM_MSG_INVALID_HOST);
break;
case CommonData.DbReturnCode.InvalidDatabase:
message = new IvsMessage(CommonConstantMessage.COM_MSG_INVALID_DATABASE);
break;
case CommonData.DbReturnCode.LostConnection:
message = new IvsMessage(CommonConstantMessage.COM_MSG_CONNECTION_LOST);
break;
case CommonData.DbReturnCode.DuplicateKey:
message = new IvsMessage(CommonConstantMessage.COM_MSG_DUPPLICATE_KEY);
break;
case CommonData.DbReturnCode.ForgeignKeyNotExist:
message = new IvsMessage(CommonConstantMessage.COM_MSG_FOREIGN_KEY_NOT_EXIST);
break;
case CommonData.DbReturnCode.ForeignKeyViolation:
message = new IvsMessage(CommonConstantMessage.COM_MSG_FOREIGN_KEY_VIOLATION);
break;
case CommonData.DbReturnCode.DataNotFound:
message = new IvsMessage(CommonConstantMessage.COM_MSG_DATA_NOT_FOUND);
break;
case CommonData.DbReturnCode.DeadlockFound:
message = new IvsMessage(CommonConstantMessage.COM_MSG_DEADLOCK_FOUND);
break;
case CommonData.DbReturnCode.LockWaitTimeoutExceeded:
message = new IvsMessage(CommonConstantMessage.COM_MSG_LOCK_WAIT_TIMEOUT_EXCEEDED);
break;
case CommonData.DbReturnCode.ExceptionOccured:
message = new IvsMessage(CommonConstantMessage.COM_MSG_GENERAL_EXCEPTION);
break;
case CommonData.DbReturnCode.ConcurrencyViolation:
message = new IvsMessage(CommonConstantMessage.COM_MSG_CONCURRENCY_VIOLATION);
break;
}
ModelState.AddModelError(CommonData.MessageArea.MsgContent, message.MessageText);
return(message.MessageText);
}
protected virtual bool Exit()
{
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "Exit Start");
#endregion Logger Start
bool isExit = false;
//Check Logout state
bool isLogout = ApplicationState.GetValue <bool>("Logout");
if (!isLogout)
{
if (IsChanged)
{
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
message = new IvsMessage(CommonConstantMessage.COM_MSG_CONFIRM_EXIT);
this.MessageBox.Add(message);
CommonData.MessageTypeResult result = this.MessageBox.Display(CommonData.MessageType.YesNoCancel);
if (result == CommonData.MessageTypeResult.Yes)
{
if (this.ValidateData() == CommonData.IsValid.Successful)
{
this.SaveData();
this.CloseForm();
isExit = true;
}
}
else if (result == CommonData.MessageTypeResult.No)
{
this.CloseForm();
isExit = true;
}
}
else
{
this.CloseForm();
isExit = true;
}
}
else
{
this.CloseForm();
isExit = true;
}
return(isExit);
#region Logger End
log.Write(Logger.Level.Debug, "Exit End");
#endregion Logger End
}
/// <summary>
/// Processing when click btnExportCSV
/// </summary>
protected virtual void ExportToCsv()
{
if (this.displayGrid.ExportToCsv() == CommonData.IOReturnCode.AccessDenied)
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_ACCESS_DENIED);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
}
}
/// <summary>
/// Processing when click btnEdit
/// </summary>
protected virtual void EditData()
{
if (this.btnEdit.Visibility == DevExpress.XtraBars.BarItemVisibility.Never || this.btnEdit.Enabled == false)
{
return;
}
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "EditData Start");
#endregion Logger Start
this.lblErrorMessage.Text = CommonData.StringEmpty;
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
ListDto = GetSelectedRows();
if (ListDto.Count <= 0)
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_NO_ROW_SELECTED);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
this.lblErrorMessage.Text = this.MessageBox.DisplayMessage;
return;
}
if (IsSystemData(ListDto))
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_NOT_PERMISSION_EDIT);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
this.lblErrorMessage.Text = this.MessageBox.DisplayMessage;
return;
}
EditForm.ListDto = ListDto;
EditForm.ViewMode = CommonData.Mode.Edit;
EditForm.Open();
EditForm = null;
// Resarch data after edit
isResearch = true;
this.SearchData();
log.GetLogger(this.Name.ToString());
isResearch = false;
#region Logger End
log.Write(Logger.Level.Debug, "EditData End");
#endregion Logger End
}
/// <summary>
/// Processing when click btnSearch or btnRefresh
/// </summary>
protected virtual void SearchData()
{
this.ShowProgressBar();
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "SearchData Start");
#endregion Logger Start
this.displayGrid.DataSource = null;
DataTable dtResult = new DataTable();
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
int iReturnCode = Bl.SearchData(this.Dto, out dtResult);
/// Succeed: search successful, don't show message error
/// AccessDenied: Access denied, login to database fail(invalid username, invalid password), show message error
/// InvalidHost: Invalid host, cannot find server(host) that set in app config file, show message error
/// InvalidDatabase: Invalid database, cannot find database that set in DbConfig file, show message error
/// LostConnection: Lost connection, cannot connect to database because lost connection, show message error
/// DuplicateKey: Duplicate key: insert Primary Key or Unique Key that already exist in database, show message error
/// ForgeignKeyNotExist: Forgeign key not exist: insert a foreign key that not exist in primary key, show message error
/// ForeignKeyViolation: Foreign Key Violation: Foreign Key Violation (delete primary key that is foreign key in other table), show message error
/// DataNotFound: Data not found: Delete or Update data that not exist in database, show message error
/// ExceptionOccured: Exception occured: other exception
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
this.displayGrid.DataSource = dtResult;
message = new IvsMessage(CommonConstantMessage.COM_MSG_ROW_FOUND, dtResult.Rows.Count.ToString());
this.MessageBox.Add(message);
this.lblErrorMessage.Text = this.MessageBox.DisplayMessage;
if (!isResearch)
{
this.MessageBox.Display(CommonData.MessageType.Ok);
}
}
else
{
ProcessDbExcetion(iReturnCode);
}
#region Logger End
log.Write(Logger.Level.Debug, "SearchData End");
#endregion Logger End
this.HideProgressBar();
}
/// <summary>
/// Processing when click btnViewLog
/// </summary>
private void btnViewLog_Click(object sender, EventArgs e)
{
try
{
string[] logContent = null;
string logFile = CommonData.StringEmpty;
//this.service = new Ivs.Core.Services.Services();
//if (DbConfig.UsingProxy.Equals("true"))
//{
// string address = "http://" + DbConfig.ServerName + ":" + DbConfig.WebServicePort;
// WebProxy proxyObject = new WebProxy(address, true);
// service.Proxy = proxyObject;
//}
//service.Credentials = CredentialCache.DefaultCredentials;
//bool result = this.service.GetLogFile(out logFile, out logContent);
//if (!result)
//{
// if (Directory.Exists(logFile))
// {
// MessageBoxs msg = new MessageBoxs();
// IvsMessage message = null;
// message = new IvsMessage("CMN025");
// msg.Add(message);
// msg.Display(CommonData.MessageType.Ok);
// }
// else
// {
// MessageBoxs msg = new MessageBoxs();
// IvsMessage message = null;
// message = new IvsMessage("CMN071");
// msg.Add(message);
// msg.Display(CommonData.MessageType.Ok);
// }
//}
//else
//{
// File.WriteAllLines(logFile, logContent);
// System.Diagnostics.Process.Start(logFile);
//}
}
catch
{
MessageBoxs msg = new MessageBoxs();
IvsMessage message = null;
message = new IvsMessage("SYBK00_006");
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
}
}
/// <summary>
/// Print delivery sheet
/// </summary>
protected virtual void PrintSheet(IvsUserControl masterControl)
{
if (this.btnPrintSheet.Visibility == DevExpress.XtraBars.BarItemVisibility.Never || this.btnPrintSheet.Enabled == false)
{
return;
}
StockTransactionBl stocktransactionBl = new StockTransactionBl();
stockMasterDto = (ST_StockTransactionMasterDto)this.Dto;
transactionMasterControl = masterControl;
DataTable stockMasterDt = new DataTable();
int rows = 0;
int returnCode = stocktransactionBl.SearchMaster(stockMasterDto, out stockMasterDt, out rows);
if (!CommonMethod.IsNullOrEmpty(stockMasterDt))
{
printedCount = CommonMethod.ParseInt32(stockMasterDt.Rows[0][CommonKey.DeliverySheetPrintCount]);
stockMasterDto.DeliverySheetPrintCount = printedCount;
if (printedCount == 0)
{
printedCount = printedCount + 1;
this.ShowReport(printedCount);
this.UpdateStockTransactionMasterForCountingPrint(printedCount, string.Empty);
var collection = masterControl.Controls.Find("txtPrintCount", true);
if (collection.Length > 0)
{
Ivs.Controls.CustomControls.WinForm.IvsTextEdit chk = (Ivs.Controls.CustomControls.WinForm.IvsTextEdit)collection[0];
chk.Text = printedCount.ToString();
}
}
else
{
if (printedCount <= CommonData.PrintSheetDelivery.DeliverySheet)
{
ReasonPrintForm.ShowDialog();
}
else
{
//Display message can not print more than four times.
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
message = new IvsMessage(CommonConstantMessage.COM_MSG_CAN_NOT_PRINT, "4");
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
}
}
}
}
/// <summary>
/// Confirm want to clear all data
/// </summary>
protected override void ClearOrReset()
{
if (this.IsFormChanged())
{
this.MessageBox = new MessageBoxs();
IvsMessage message = new IvsMessage(CommonConstantMessage.COM_MSG_CONFIRM_CLEAR);
this.MessageBox.Add(message);
CommonData.MessageTypeResult result = this.MessageBox.Display(CommonData.MessageType.YesNo);
if (result == CommonData.MessageTypeResult.No)
{
return;
}
}
base.ClearOrReset();
}
protected virtual bool Exit()
{
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "Exit Start");
#endregion Logger Start
bool isExit = false;
if (IsChanged)
{
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
message = new IvsMessage("CMN010");
this.MessageBox.Add(message);
CommonData.MessageTypeResult result = this.MessageBox.Display(CommonData.MessageType.YesNoCancel);
if (result == CommonData.MessageTypeResult.Yes)
{
if (this.ValidateData() == CommonData.IsValid.Successful)
{
this.SaveData();
this.CloseForm();
isExit = true;
}
}
if (result == CommonData.MessageTypeResult.No)
{
this.CloseForm();
isExit = true;
}
}
else
{
this.CloseForm();
isExit = true;
}
return(isExit);
#region Logger End
log.Write(Logger.Level.Debug, "Exit End");
#endregion Logger End
}
/// <summary>
/// Insert or update data to database
/// </summary>
protected virtual int SaveData()
{
this.ShowProgressBar();
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
int iReturnCode = -1;
//This is case ViewMode is Edit, system will update data to database
if (this.ViewMode == CommonData.Mode.Edit)
{
ReturnCode = iReturnCode = Bl.UpdateData(this.Dto);
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
object dto = Activator.CreateInstance(this.CurrentDto.GetType());
CommonMethod.Clone(this.Dto, out dto);
this.ListDto[currentPosition] = (IDto)dto;
message = new IvsMessage(CommonConstantMessage.COM_MSG_UPDATE_SUCCESSFULLY);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
}
else
{
this.ProcessDbExcetion(iReturnCode);
}
}
//This is case ViewMode is New, system will insert data to databas
else if (this.ViewMode == CommonData.Mode.New)
{
ReturnCode = iReturnCode = Bl.InsertData(this.Dto);
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_INSERT_SUCCESSFULLY);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
}
else
{
this.ProcessDbExcetion(iReturnCode);
}
}
this.HideProgressBar();
return(iReturnCode);
}
/// <summary>
/// Check validated data
/// </summary>
protected bool ValidateData()
{
MessageBoxs msg = new MessageBoxs();
IvsMessage message = null;
this.txtPath.ClearErrors();
if (!this.IsValidatePath(this.txtPath.Text))
{
message = new IvsMessage("SYBK00_004");
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
this.txtPath.SetError(message.MessageText);
this.txtPath.Focus();
return(false);
}
return(true);
}
protected void GridDoubleClick()
{
if (EditForm == null || EditForm.IsDisposed)
{
return;
}
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "GridDoubleClick Start");
#endregion Logger Start
this.lblErrorMessage.Text = CommonData.StringEmpty;
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
ListDto = GetSelectedRows();
if (ListDto.Count <= 0)
{
message = new IvsMessage("CMN008");
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
this.lblErrorMessage.Text = this.MessageBox.DisplayMessage;
return;
}
this.movingMode = CommonData.Mode.View;
EditForm.ListDto = ListDto;
EditForm.ViewMode = CommonData.Mode.View;
EditForm.Open();
EditForm = null;
// Resarch data after edit
isResearch = true;
this.SearchData();
log.GetLogger(this.Name.ToString());
isResearch = false;
#region Logger End
log.Write(Logger.Level.Debug, "GridDoubleClick End");
#endregion Logger End
}
protected override CommonData.IsValid ValidateData()
{
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
this.txtReason.ClearErrors();
if (CommonMethod.IsNullOrEmpty(this.txtReason.Text))
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, this.lblReason.Text);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
this.txtReason.SetError(message.MessageText);
this.txtReason.Focus();
this.lblErrorMessage.Text = this.MessageBox.DisplayMessage;
return(CommonData.IsValid.Failed);
}
return(CommonData.IsValid.Successful);
}
private void dgvInventory_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
ST_StockTransactionDetailDto detailDto = dgcInventory.GetFocusedRow <ST_StockTransactionDetailDto>();
//Set auto value for column No
dgcInventory.SetRowCellValue(CommonKey.LineNumber, CommonMethod.ParseString(e.RowHandle + 1));
#region Set validate
dgcInventory.ClearErrors();
/// <summary>
/// Item Code must be fill in
///</summary>
if (string.IsNullOrEmpty(detailDto.ItemCode))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colItemCode.Caption);
dgcInventory.SetColumnError(colItemCode.FieldName, msg.MessageText);
return;
}
/// <summary>
/// Quantity must be greater than 0
///</summary>
if (detailDto.Quantity == null || detailDto.Quantity <= 0)
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colQuantity.Caption);
dgcInventory.SetColumnError(colQuantity.FieldName, msg.MessageText);
return;
}
#endregion Set validate
#region Add new row if focus to last row
if (dgcInventory.IsFocusedLastRow())
{
dgcInventory.AddNewRow();
}
#endregion Add new row if focus to last row
}
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
{
IvsMessage message = null;
if (CommonMethod.IsNullOrEmpty(Code))
{
message = new IvsMessage("COM_MSG_MS_DEPARTMENT_CODE");
yield return(new ValidationResult(message.MessageText, new[] { CommonKey.Code }));
}
if (CommonMethod.IsNullOrEmpty(Name1))
{
message = new IvsMessage("COM_MSG_MS_DEPARTMENT_NAME1");
yield return(new ValidationResult(message.MessageText, new[] { CommonKey.Name1 }));
}
if (CommonMethod.IsNullOrEmpty(Name2))
{
message = new IvsMessage("COM_MSG_MS_DEPARTMENT_NAME2");
yield return(new ValidationResult(message.MessageText, new[] { CommonKey.Name2 }));
}
}
/// <summary>
/// Insert or update data to database
/// </summary>
protected virtual int SaveData()
{
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
int iReturnCode = -1;
//This is case ViewMode is Edit, system will update data to database
if (this.ViewMode == CommonData.Mode.Edit)
{
iReturnCode = Bl.UpdateData(this.Dto);
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
object dto = Activator.CreateInstance(this.CurrentDto.GetType());
CommonMethod.Clone(this.Dto, out dto);
this.ListDto[currentPosition] = (IDto)dto;
message = new IvsMessage("CMN004");
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
}
else
{
ProcessDbExcetion(iReturnCode);
}
}
////This is case ViewMode is New, system will insert data to databas
else if (this.ViewMode == CommonData.Mode.New)
{
iReturnCode = Bl.InsertData(this.Dto);
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
message = new IvsMessage("CMN003");
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
}
else
{
ProcessDbExcetion(iReturnCode);
}
}
return(iReturnCode);
}
/// <summary>
/// Processing when click btnCopy
/// </summary>
protected void CopyAndNewData()
{
if (this.btnCopy.Visibility == DevExpress.XtraBars.BarItemVisibility.Never || this.btnCopy.Enabled == false)
{
return;
}
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "CopyAndNewData Start");
#endregion Logger Start
this.lblErrorMessage.Text = CommonData.StringEmpty;
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
ListDto = GetSelectedRows();
if (ListDto.Count <= 0)
{
message = new IvsMessage("CMN008");
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
this.lblErrorMessage.Text = this.MessageBox.DisplayMessage;
return;
}
this.movingMode = CommonData.Mode.New;
EditForm.ListDto = ListDto;
EditForm.ViewMode = CommonData.Mode.New;
EditForm.Open();
EditForm = null;
#region Logger End
log.Write(Logger.Level.Debug, "CopyAndNewData End");
#endregion Logger End
}
protected virtual ActionResult BaseIndex(int?page, string sortColumn, string sortOrder, IModel model)
{
IvsMessage message = null;
List <IModel> lstModels = new List <IModel>();
int returnCode = CommonData.DbReturnCode.Succeed;
int pageNumber = (page ?? 1);
//this.Model = Model;
this.SetSearchModel <IModel>(page, ref model);
//reload condition to show again
this.SetSearchControlData();
returnCode = Bl.SearchData(model, out lstModels);
if (returnCode == CommonData.DbReturnCode.Succeed)
{
if (Request.Form["btnSearch"] != null || Request.Form["btnRefresh"] != null)
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_ROW_FOUND, lstModels.Count.ToString());
TempData[CommonData.MessageArea.MsgContent] = message.MessageText;
}
}
else
{
TempData[CommonData.MessageArea.MsgContent] = CommonMethod.ProcessDbExcetion(returnCode);
}
Session[SEARCH_RESULT] = lstModels;
//Sorting
ViewBag.SortOrder = sortOrder;
ViewBag.SortColumn = sortColumn;
GridSetting setting = new GridSetting(pageNumber, recordsPerPage, sortColumn, sortOrder);
lstModels = setting.LoadGridData <IModel>(lstModels, true).ToList();
return(PartialView(this.PartialViewName, ConvertToPageList(lstModels, recordsPerPage, pageNumber)));
}
/// <summary>
/// Processing when click btnExportXlsx
/// </summary>
protected virtual void ExportToXlsx()
{
if (this.ctrlDetail != null)
{
if (this.ctrlDetail.dgcInventory.ExportToXlsx() == CommonData.IOReturnCode.AccessDenied)
{
IvsMessage message = new IvsMessage(CommonConstantMessage.COM_MSG_ACCESS_DENIED);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
return;
}
}
if (this.ctrlDetail1 != null)
{
if (this.ctrlDetail1.dgcInventory.ExportToXlsx() == CommonData.IOReturnCode.AccessDenied)
{
IvsMessage message = new IvsMessage(CommonConstantMessage.COM_MSG_ACCESS_DENIED);
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
return;
}
}
}
protected virtual ActionResult BaseDelete(List <int> listId)
{
string message = null;
int returnCode = CommonData.DbReturnCode.Succeed;
if (listId != null && listId.Count > 0)
{
returnCode = Bl.DeleteData(listId);
if (returnCode == 0)
{
message = new IvsMessage(CommonConstantMessage.COM_MSG_DELETE_SUCCESSFULLY).MessageText;
}
else
{
message = CommonMethod.ProcessDbExcetion(returnCode);
}
}
else
{
message = CommonMethod.ProcessDbExcetion(CommonData.DbReturnCode.DataNotFound);
}
return(Json(new { ReturnCode = returnCode, Message = message }));
}
/// <summary>
/// This method is called when click SaveAndClose button
/// ViewMode is Edit: update data and not close form
/// ViewMode is New: insert data and not close form
/// </summary>
protected virtual int SaveAndNotClose()
{
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "SaveAndClose Start");
#endregion Logger Start
if (btnSaveAndClose.Visibility == DevExpress.XtraBars.BarItemVisibility.Never || btnSaveAndClose.Enabled == false)
{
return(CommonData.DbReturnCode.AccessDenied);
}
int iReturnCode = CommonData.DbReturnCode.Succeed;
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
switch (this.ViewMode)
{
case CommonData.Mode.Edit:
{
if (this.ValidateData() == CommonData.IsValid.Successful)
{
this.lblErrorMessage.Text = CommonData.StringEmpty;
message = new IvsMessage(CommonConstantMessage.COM_MSG_CONFIRM_SAVE);
this.MessageBox.Add(message);
MsgTypeResult = this.MessageBox.Display(CommonData.MessageType.YesNo);
if (MsgTypeResult == CommonData.MessageTypeResult.Yes)
{
iReturnCode = this.SaveData();
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
//do nothing
//this.CloseForm();
}
}
}
else
{
iReturnCode = CommonData.DbReturnCode.ExceptionOccured;
}
}
break;
case CommonData.Mode.New:
{
if (this.ValidateData() == CommonData.IsValid.Successful)
{
this.lblErrorMessage.Text = CommonData.StringEmpty;
message = new IvsMessage(CommonConstantMessage.COM_MSG_CONFIRM_SAVE);
this.MessageBox.Add(message);
MsgTypeResult = this.MessageBox.Display(CommonData.MessageType.YesNo);
if (MsgTypeResult == CommonData.MessageTypeResult.Yes)
{
iReturnCode = this.SaveData();
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
//do nothing
//this.CloseForm();
}
this.SetControl();
}
}
else
{
iReturnCode = CommonData.DbReturnCode.ExceptionOccured;
}
}
break;
case CommonData.Mode.View:
{
this.CloseForm();
}
break;
}
#region Logger End
log.Write(Logger.Level.Debug, "SaveAndClose End");
#endregion Logger End
return(iReturnCode);
}
/// <summary>
/// This method is called when click SaveAndNext button
/// </summary>
protected virtual void SaveAndNext()
{
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "SaveAndNext Start");
#endregion Logger Start
int iReturnCode = CommonData.DbReturnCode.Succeed;
if (btnSaveAndNext.Visibility == DevExpress.XtraBars.BarItemVisibility.Never || btnSaveAndNext.Enabled == false)
{
return;
}
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
switch (this.ViewMode)
{
case CommonData.Mode.Edit:
{
if (this.ValidateData() == CommonData.IsValid.Successful)
{
this.lblErrorMessage.Text = CommonData.StringEmpty;
message = new IvsMessage(CommonConstantMessage.COM_MSG_CONFIRM_SAVE);
this.MessageBox.Add(message);
CommonData.MessageTypeResult result = this.MessageBox.Display(CommonData.MessageType.YesNo);
if (result == CommonData.MessageTypeResult.Yes)
{
iReturnCode = this.SaveData();
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
this.LoadNextData();
}
this.SetControl();
}
}
}
break;
case CommonData.Mode.New:
{
if (this.ValidateData() == CommonData.IsValid.Successful)
{
this.lblErrorMessage.Text = CommonData.StringEmpty;
message = new IvsMessage(CommonConstantMessage.COM_MSG_CONFIRM_SAVE);
this.MessageBox.Add(message);
CommonData.MessageTypeResult result = this.MessageBox.Display(CommonData.MessageType.YesNo);
if (result == CommonData.MessageTypeResult.Yes)
{
iReturnCode = this.SaveData();
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
this.LoadNextData();
}
this.SetControl();
}
}
}
break;
case CommonData.Mode.View:
{
this.LoadNextData();
this.SetControl();
}
break;
}
#region Logger End
log.Write(Logger.Level.Debug, "SaveAndNext End");
#endregion Logger End
}
public virtual void btnOK_Click(object sender, EventArgs e)
{
MessageBoxs msg = new MessageBoxs();
IvsMessage message = null;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
int returnCode = 0;
returnCode = this.GetImportData();
switch (returnCode)
{
case CommonData.ImportReturnCode.PathIsEmpty:
message = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, lblPath_Import.Text);
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
this.importData = null;
this.IsImportErr = true;
break;
case CommonData.ImportReturnCode.PathNotExist:
message = new IvsMessage(CommonConstantMessage.COM_MSG_DATA_OR_FILE_NOT_FOUND, txtPath.Text);
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
this.importData = null;
this.IsImportErr = true;
break;
case CommonData.ImportReturnCode.FileFormatInvalid:
message = new IvsMessage(CommonConstantMessage.COM_MSG_FILE_FORMAT_INVALID);
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
this.importData = null;
this.IsImportErr = true;
break;
case CommonData.ImportReturnCode.NumRowInvalid:
message = new IvsMessage(CommonConstantMessage.COM_MSG_FILE_NUM_OF_ROW_INVALID);
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
this.importData = null;
this.IsImportErr = true;
break;
case CommonData.ImportReturnCode.NumFieldInvalid:
message = new IvsMessage(CommonConstantMessage.COM_MSG_FILE_NUM_OF_COLUMN_INVALID);
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
this.importData = null;
this.IsImportErr = true;
break;
case CommonData.ImportReturnCode.SystemError:
message = new IvsMessage(CommonConstantMessage.COM_MSG_GENERAL_EXCEPTION);
msg.Add(message);
msg.Display(CommonData.MessageType.Ok);
this.importData = null;
this.IsImportErr = true;
break;
case CommonData.ImportReturnCode.Succeed:
this.IsImportErr = false;
this.Hide();
break;
}
}
/// <summary>
/// Processing when click btnDelete
/// </summary>
protected virtual void DeleteData()
{
if (this.btnDelete.Visibility == DevExpress.XtraBars.BarItemVisibility.Never || this.btnDelete.Enabled == false)
{
return;
}
#region Logger Start
log.GetLogger(this.Name.ToString());
log.Write(Logger.Level.Debug, "DeleteData Start");
#endregion Logger Start
this.lblErrorMessage.Text = CommonData.StringEmpty;
this.MessageBox = new MessageBoxs();
IvsMessage message = null;
ListDto = GetSelectedRows();
if (ListDto.Count <= 0)
{
message = new IvsMessage("CMN008");
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
this.lblErrorMessage.Text = this.MessageBox.DisplayMessage;
return;
}
message = new IvsMessage("CMN011");
this.MessageBox.Add(message);
CommonData.MessageTypeResult result = this.MessageBox.Display(CommonData.MessageType.YesNo);
if (result == CommonData.MessageTypeResult.Yes)
{
int iReturnCode = Bl.DeleteData(ListDto);
/// Succeed: Delete successful, don't show message error, refresh Gird
/// AccessDenied: Access denied, login to database fail(invalid username, invalid password), show message error
/// InvalidHost: Invalid host, cannot find server(host) that set in app config file, show message error
/// InvalidDatabase: Invalid database, cannot find database that set in DbConfig file, show message error
/// LostConnection: Lost connection, cannot connect to database because lost connection, show message error
/// DuplicateKey: Duplicate key: insert Primary Key or Unique Key that already exist in database, show message error
/// ForgeignKeyNotExist: Forgeign key not exist: insert a foreign key that not exist in primary key, show message error
/// ForeignKeyViolation: Foreign Key Violation: Foreign Key Violation (delete primary key that is foreign key in other table), show message error
/// DataNotFound: Data not found: Delete or Update data that not exist in database, show message error
/// ExceptionOccured: Exception occured: other exception
if (iReturnCode == CommonData.DbReturnCode.Succeed)
{
message = new IvsMessage("CMN005");
this.MessageBox.Add(message);
this.MessageBox.Display(CommonData.MessageType.Ok);
// Resarch data after delete
isResearch = true;
this.SearchData();
isResearch = false;
}
else
{
ProcessDbExcetion(iReturnCode);
}
}
#region Logger End
log.Write(Logger.Level.Debug, "DeleteData End");
#endregion Logger End
}
//void dgvInventory_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
//{
// //If exist error on grid
// //if (!this.isValid)
// //{
// // //Disable Focused to other row
// // this.dgvInventory.FocusedRowHandle = this.selectedRowIndex;
// // return;
// //}
//}
void dgvInventory_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.RowHandle < 0)
{
return;
}
//Set selected row index on grid
this.selectedRowIndex = e.RowHandle;
dgcInventory.SetRowCellValue(CommonKey.LineNumber, CommonMethod.ParseString(e.RowHandle + 1));
ST_StockTransactionDetailDto detailDto = dgcInventory.GetFocusedRow <ST_StockTransactionDetailDto>();
#region Set validate
dgcInventory.ClearErrors();
this.isValid = true;
if (!this.ShowSelect || detailDto.Select)
{
/// <summary>
/// TransferType must be fill in
///</summary>
if (this.ShowTransferType && CommonMethod.IsNullOrEmpty(detailDto.TransferType))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colTransferType.Caption);
dgcInventory.SetColumnError(colTransferType.FieldName, msg.MessageText);
isValid = false;
}
/// <summary>
/// Item Code must be fill in
///</summary>
if (string.IsNullOrEmpty(detailDto.ItemCode))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colItemCode.Caption);
dgcInventory.SetColumnError(colItemCode.FieldName, msg.MessageText);
isValid = false;
}
/// <summary>
/// Quantity must be fill in.
///</summary>
if (detailDto.InputQuantity == null)
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colQuantity.Caption);
dgcInventory.SetColumnError(colQuantity.FieldName, msg.MessageText);
isValid = false;
}
else
{
/// <summary>
/// Quantity must be greater than 0
///</summary>
if (detailDto.InputQuantity <= 0)
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_GREATER_THAN, colQuantity.Caption, 0);
dgcInventory.SetColumnError(colQuantity.FieldName, msg.MessageText);
isValid = false;
}
}
/// <summary>
/// QualityStatus must be fill in
///</summary>
if (this.ShowQuanlityStatus && CommonMethod.IsNullOrEmpty(detailDto.QualityStatus))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colQualityStatus.Caption);
dgcInventory.SetColumnError(colQualityStatus.FieldName, msg.MessageText);
isValid = false;
}
/// <summary>
/// ProductLine must be fill in when Type is WIP
///</summary>
if (this.ShowProcessType && CommonMethod.ParseString(detailDto.ProcessType).Equals(CommonData.ProcessType.WIP) && ShowProductionLine && CommonMethod.IsNullOrEmpty(detailDto.ProductionLine))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colPruductionLine.Caption);
dgcInventory.SetColumnError(colPruductionLine.FieldName, msg.MessageText);
isValid = false;
}
/// <summary>
/// Error reason must be fill in
///</summary>
if (this.ShowErrorReason && CommonMethod.IsNullOrEmpty(detailDto.ErrorReason))
{
IvsMessage msg = new IvsMessage(CommonConstantMessage.COM_MSG_REQUIRED, colErrorReason.Caption);
dgcInventory.SetColumnError(colErrorReason.FieldName, msg.MessageText);
isValid = false;
}
}
#endregion Set validate
#region Add new row if focus to last row
if (this.AllowAddNewRow && isValid && dgcInventory.IsFocusedLastRow())
{
dgcInventory.AddNewRow();
}
#endregion Add new row if focus to last row
}
