/// <summary>
/// Gets the employee break categories by activity names.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private EntityDataServiceResponse <EmployeeActivity> GetEmployeeBreakCategoriesByActivity(GetEmployeeBreakCategoriesByActivityDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
var result = dataManager.GetEmployeeBreakCategoriesByActivity(request.ActivityNames);
return(new EntityDataServiceResponse <EmployeeActivity>(result));
}
/// <summary>
/// Validates the employee password.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private SingleEntityDataServiceResponse <bool> ValidateEmployeePassword(ValidateEmployeePasswordDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
bool result = dataManager.ValidateEmployeePassword(request.ChannelId, request.StaffId, request.PasswordHash, request.QueryResultSettings.ColumnSet);
return(new SingleEntityDataServiceResponse <bool>(result));
}
/// <summary>
/// Gets the employee stores from address book.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private EntityDataServiceResponse <OrgUnit> GetEmployeeStoresFromAddressBook(GetEmployeeStoresFromAddressBookDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
var result = dataManager.GetEmployeeStoresFromAddressBook(request.RequestContext.GetPrincipal().UserId, request.QueryResultSettings);
return(new EntityDataServiceResponse <OrgUnit>(result));
}
/// <summary>
/// Gets the employee.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private SingleEntityDataServiceResponse <Employee> GetEmployee(GetEmployeeDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
Employee result = dataManager.GetEmployee(request.StaffId, request.QueryResultSettings);
return(new SingleEntityDataServiceResponse <Employee>(result));
}
/// <summary>
/// Gets the salt for hashing password.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The salt and the algorithm to hash password.</returns>
private SingleEntityDataServiceResponse <EmployeePasswordCryptoInfo> GetEmployeePasswordCryptoInfo(GetEmployeePasswordCryptoInfoDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
var passwordCryptoInfo = dataManager.GetEmployeePasswordCryptoInfo(request.StaffId, request.ChannelId);
return(new SingleEntityDataServiceResponse <EmployeePasswordCryptoInfo>(passwordCryptoInfo));
}
/// <summary>
/// Gets the employee permission group for the staff identifier.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private SingleEntityDataServiceResponse <EmployeePermissions> GetEmployeePermissions(GetEmployeePermissionsDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
var result = dataManager.GetEmployeePermissions(request.StaffId, request.ColumnSet);
return(new SingleEntityDataServiceResponse <EmployeePermissions>(result));
}
/// <summary>
/// Gets Operation Permissions for the operation.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private EntityDataServiceResponse <OperationPermission> GetOperationPermissions(GetOperationPermissionsDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
var result = dataManager.GetOperationPermissions(request.OperationId, request.QueryResultSettings);
return(new EntityDataServiceResponse <OperationPermission>(result));
}
/// <summary>
/// Gets employee authorized to current store.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private SingleEntityDataServiceResponse <Employee> GetAuthorizedEmployee(GetEmployeeAuthorizedOnStoreDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
Employee employee = dataManager.GetAuthorizedEmployeeOnStore(request.RequestContext.GetPrincipal().ChannelId, request.StaffId);
return(new SingleEntityDataServiceResponse <Employee>(employee));
}
/// <summary>
/// Logs On the user in the local store database.
/// </summary>
/// <param name="request">The data service request.</param>
/// <returns>The data service response.</returns>
private SingleEntityDataServiceResponse <Employee> EmployeeLogOnStore(EmployeeLogOnStoreDataRequest request)
{
EmployeeDataManager dataManager = this.GetDataManagerInstance(request.RequestContext);
var result = dataManager.EmployeeLogOnStore(request.ChannelId, request.StaffId, request.PasswordHash, request.ColumnSet);
// Clear the cache for the staff at logon.
DataStoreManager.InstantiateDataStoreManager(request.RequestContext);
EmployeeL2CacheDataStoreAccessor accessor = new EmployeeL2CacheDataStoreAccessor(DataStoreManager.DataStores[DataStoreType.L2Cache], request.RequestContext);
accessor.ClearCacheAuthorizedEmployeeOnStore(request.ChannelId, request.StaffId);
return(new SingleEntityDataServiceResponse <Employee>(result));
}
public EmployeePopup(EmployeeModel.EmployeeType employeeType = EmployeeModel.EmployeeType.All, params IListParameter[] defaultParam)
{
InitializeComponent();
DataManager = new EmployeeDataManager();
DataManager.DefaultParameters = defaultParam;
DataManager.DefaultParameters = new IListParameter[]
{
WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals)
};
PagingForm = new Paging {
Direction = "ASC", Limit = PageLimit, SortColumn = "name"
};
EmployeeType = employeeType;
ObjNavigator.ButtonClick += NavigatorClick;
}
public IActionResult Index(IFormFile?file)
{
List <ReturnData> returnedData = new List <ReturnData>();
if (file != null)
{
EmployeeDataManager employeeDataStorage = EmployeeDataManager.Instance;
employeeDataStorage.clearData();
using var reader = new StreamReader(file.OpenReadStream());
while (reader.Peek() >= 0)
{
var line = reader.ReadLine().Split(',');
if (line.Count() != 4)
{
ViewBag.Error = "Seems like the data is not in the correct format. Make sure sure the format is EmpID, ProjectID, DateFrom, DateTo";
break;
}
var formats = new[] { "yyyy-M-d", "yyyy/M/d", "d/M/yyyy", "d.M.yyyy" }.Union(CultureInfo.InvariantCulture.DateTimeFormat.GetAllDateTimePatterns()).ToArray();
DateTime startDate;
if (!DateTime.TryParseExact(line[2].Trim(), formats, CultureInfo.InvariantCulture, DateTimeStyles.None, out startDate))
{
ViewBag.Error = "Unsupported DateFrom format. Allowed formats: yyyy-M-d, yyyy/M/d, d/M/yyyy, d.M.yyyy";
break;
}
DateTime endDate;
if (line[3].Trim().ToLower() == "null")
{
endDate = DateTime.Now;
}
else if (!DateTime.TryParseExact(line[3].Trim(), formats, CultureInfo.InvariantCulture, DateTimeStyles.None, out endDate))
{
ViewBag.Error = "Unsupported DateTo format. Allowed formats: yyyy-M-d, yyyy/M/d, d/M/yyyy, d.M.yyyy";
break;
}
employeeDataStorage.AddData(new EmployeeData(Int32.Parse(line[0].Trim()), Int32.Parse(line[1].Trim()), startDate, endDate));
}
returnedData = employeeDataStorage.ReturnData();
}
return(View(returnedData));
}
protected override void LoadForm(object sender, EventArgs e)
{
base.LoadForm(sender, e);
EnableBtnSearch = true;
SearchPopup = new ShipmentPopup();
BranchDataManager = new BranchDataManager();
TrackingStatusDataManager = new TrackingStatusDataManager();
MissDeliveryReasonDataManager = new MissDeliveryReasonDataManager();
EmployeeDataManager = new EmployeeDataManager();
Statuses = new BindingList <ShipmentStatusDataRow>();
grid.DataSource = Statuses;
gridColumn2.DisplayFormat.FormatType = FormatType.DateTime;
gridColumn2.DisplayFormat.FormatString = "dd-MM-yyyy";
btnExport.Click += (o, args) => ExportGridToExcel(gridView, string.Format("CustomerService_TrackingView_{0}", ((ShipmentModel)CurrentModel).Code));
rbLayout_Print.Visibility = BarItemVisibility.Never;
rbLayout_PrintPreview.Visibility = BarItemVisibility.Never;
}
private void Print(object sender, EventArgs e)
{
int hal = 1;
string print = HeaderDotMetrix(hal);
var reg = new Regex(@"#(.+?)#");
var result = reg.Match(print).Groups[0].Value;
if (result != "")
{
var table = string.Empty;
var pattern = result.Replace("#", "");
var patterns = pattern.Split(' ');
var no = 1;
var row = 1;
var grandPcs = 0;
decimal grandGw = 0;
decimal grandTtl = 0;
var dataSource = GridShipment.DataSource as List <SISCO.Models.ShipmentModel.ShipmentReportRow>;
for (var i = 0; i < dataSource.Count(); i++)
{
table += string.Format("{0} ", no.ToString("#").PadLeft(patterns[0].Length, ' '));
table += string.Format("{0} ", dataSource[i].Code != null ? dataSource[i].Code.PadRight(patterns[1].Length, ' ').Substring(0, patterns[1].Length) : " ".PadRight(patterns[1].Length, ' '));
table += string.Format("{0} ", dataSource[i].DateProcess.ToString("dd-MM-yyyy").PadRight(patterns[2].Length, ' ').Substring(0, patterns[2].Length));
table += string.Format("{0} ", dataSource[i].ShipperName != null ? dataSource[i].ShipperName.PadRight(patterns[3].Length, ' ').Substring(0, patterns[3].Length) : " ".PadRight(patterns[3].Length, ' '));
table += string.Format("{0} ", dataSource[i].ConsigneeName != null ? dataSource[i].ConsigneeName.PadRight(patterns[4].Length, ' ').Substring(0, patterns[4].Length) : " ".PadRight(patterns[4].Length, ' '));
table += string.Format("{0} ", dataSource[i].DestCity != null ? dataSource[i].DestCity.PadRight(patterns[5].Length, ' ').Substring(0, patterns[5].Length) : " ".PadRight(patterns[5].Length, ' '));
table += string.Format("{0} ", dataSource[i].PaymentMethod != null ? dataSource[i].PaymentMethod.PadRight(patterns[6].Length, ' ').Substring(0, patterns[6].Length) : " ".PadRight(patterns[6].Length, ' '));
table += string.Format("{0} ", dataSource[i].PackageType != null ? dataSource[i].PackageType.PadRight(patterns[7].Length, ' ').Substring(0, patterns[7].Length) : " ".PadRight(patterns[7].Length, ' '));
table += string.Format("{0} ", dataSource[i].TtlPiece.ToString("#0").PadLeft(patterns[8].Length, ' '));
table += string.Format("{0} ", dataSource[i].TtlGrossWeight.ToString("#0").PadLeft(patterns[9].Length, ' '));
table += string.Format("{0} ", dataSource[i].Total > 0 ? dataSource[i].Total.ToString("#,#0").PadLeft(patterns[10].Length, ' ').Substring(0, patterns[10].Length) : " ".PadRight(patterns[10].Length, ' '));
table += "\n";
no++;
row++;
grandPcs += dataSource[i].TtlPiece;
grandGw += dataSource[i].TtlGrossWeight;
grandTtl += dataSource[i].Total;
if (row == 55)
{
print = print.Replace(result, table);
var regPcs = new Regex(@"<(.+?)>");
var gPcs = regPcs.Match(print).Groups[0].Value;
var regGw = new Regex(@"{(.+?)}");
var gGw = regGw.Match(print).Groups[0].Value;
var regTtl = new Regex(@"\|(.+?)\|");
var gTtl = regTtl.Match(print).Groups[0].Value;
print = print.Replace(gPcs, grandPcs.ToString("#0").PadLeft(gPcs.Length, ' '));
print = print.Replace(gGw, grandGw.ToString("#0").PadLeft(gGw.Length, ' '));
print = print.Replace(gTtl, grandTtl.ToString("#,#0").PadLeft(gTtl.Length, ' '));
if (BaseControl.UserId > 0)
{
var user = new EmployeeDataManager().GetFirst <EmployeeModel>(WhereTerm.Default((int)BaseControl.UserId, "user_id", EnumSqlOperator.Equals));
print = print.Replace("{PRINTED}",
string.Format("{0} ({1}) {2}", user.Name, user.Code, DateTime.Now.ToString("d-M-yyyy HH:mm")) +
string.Format("{0}", (char)18));
}
table = string.Empty;
hal++;
row = 1;
grandPcs = 0;
grandGw = 0;
grandTtl = 0;
print += string.Format("{0}", (char)12);
print += HeaderDotMetrix(hal);
}
}
print = print.Replace(result, table);
var rPcs = new Regex(@"<(.+?)>");
var grnPcs = rPcs.Match(print).Groups[0].Value;
var rGw = new Regex(@"{(.+?)}");
var grdGw = rGw.Match(print).Groups[0].Value;
var rTtl = new Regex(@"\|(.+?)\|");
var grdTtl = rTtl.Match(print).Groups[0].Value;
print = print.Replace(grnPcs, grandPcs.ToString("#0").PadLeft(grnPcs.Length, ' '));
print = print.Replace(grdGw, grandGw.ToString("#0").PadLeft(grdGw.Length, ' '));
print = print.Replace(grdTtl, grandTtl.ToString("#,#0").PadLeft(grdTtl.Length, ' '));
}
if (BaseControl.UserId > 0)
{
var user = new EmployeeDataManager().GetFirst <EmployeeModel>(WhereTerm.Default((int)BaseControl.UserId, "user_id", EnumSqlOperator.Equals));
print = print.Replace("{PRINTED}",
string.Format("{0} ({1}) {2}", user.Name, user.Code, DateTime.Now.ToString("d-M-yyyy HH:mm")) +
string.Format("{0}", (char)18));
}
var printDialog = new PrintDialog();
printDialog.PrinterSettings = new PrinterSettings();
printDialog.PrinterSettings.PrinterName = BaseControl.PrinterSetting.DotMatrix;
RawPrinterHelper.SendStringToPrinter(printDialog.PrinterSettings.PrinterName, print);
}
private IEnumerable <ShipmentModel.ShipmentReportRow> GetPrintDataSource()
{
var model = ConvertModel <ShipmentModel, ShipmentModel.ShipmentReportRow>(CurrentModel as ShipmentModel);
if (model == null)
{
return(null);
}
using (var customerDm = new CustomerDataManager())
{
var customer = customerDm.GetFirst <CustomerModel>(WhereTerm.Default(model.CustomerId ?? 0, "id"));
if (customer != null)
{
model.CustomerCode = customer.Code;
}
}
using (var serviceTypeDm = new ServiceTypeDataManager())
{
var serviceType = serviceTypeDm.GetFirst <ServiceTypeModel>(WhereTerm.Default(model.ServiceTypeId, "id"));
if (serviceType != null)
{
model.ServiceType = serviceType.Name;
}
}
using (var employeeDm = new EmployeeDataManager())
{
var employee = employeeDm.GetFirst <EmployeeModel>(WhereTerm.Default(model.MessengerId ?? 0, "id"));
if (employee != null)
{
model.MessengerCode = employee.Code;
}
}
using (var paymentMethodDm = new PaymentMethodDataManager())
{
var paymentMethod = paymentMethodDm.GetFirst <PaymentMethodModel>(WhereTerm.Default(model.PaymentMethodId, "id"));
if (paymentMethod != null)
{
model.PaymentMethod = paymentMethod.Name;
}
}
using (var branchDm = new BranchDataManager())
{
var branch = branchDm.GetFirst <BranchModel>(WhereTerm.Default(model.BranchId, "id"));
if (branch != null)
{
model.ShipmentHeader = branch.HeaderShipment;
}
}
using (var packageDm = new PackageTypeDataManager())
{
var package = packageDm.GetFirst <PackageTypeModel>(WhereTerm.Default(model.PackageTypeId, "id"));
if (package != null)
{
model.PackageType = package.Name;
}
}
return(new List <ShipmentModel.ShipmentReportRow>
{
model
});
}
public EmployeeServiceManager()
{
employeeDataManager = new EmployeeDataManager();
}
