private static bool ValidateParameters(NpgsqlCommand command)
{
Collection <string> commandTextParameters = GetCommandTextParameterCollection(command.CommandText);
foreach (NpgsqlParameter npgsqlParameter in command.Parameters)
{
bool match = false;
foreach (string commandTextParameter in commandTextParameters)
{
if (npgsqlParameter.ParameterName.Equals(commandTextParameter))
{
match = true;
}
}
if (!match)
{
throw new InvalidOperationException(string.Format(CultureManager.GetCurrentUICulture(),
Warnings.InvalidParameterName, npgsqlParameter.ParameterName));
}
}
return(true);
}
public static string GetLocalDateTimeString(string timeZone, DateTime utc)
{
TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(timeZone);
DateTime time = TimeZoneInfo.ConvertTimeFromUtc(utc, zone);
return(String.Format(CultureManager.GetCurrentUICulture(), "{0} {1} {2}", time.ToLongDateString(), time.ToLongTimeString(), zone.DisplayName));
}
public static string ParseExpression(string expression, Collection <DataTable> dataTableCollection)
{
if (string.IsNullOrWhiteSpace(expression))
{
return(string.Empty);
}
string logo = GetLogo();
expression = expression.Replace("{LogoPath}",
PageUtility.GetCurrentDomainName() + PageUtility.ResolveUrl(logo));
//Or else logo will not be exported into excel.
expression = expression.Replace("{PrintDate}", DateTime.Now.ToString(CultureManager.GetCurrentUICulture()));
foreach (var match in Regex.Matches(expression, "{.*?}"))
{
string word = match.ToString();
if (word.StartsWith("{CurrentOffice.", StringComparison.OrdinalIgnoreCase))
{
string sessionKey = RemoveBraces(word);
sessionKey = sessionKey.Replace("CurrentOffice.", "");
sessionKey = sessionKey.Trim();
string value = GetDictionaryValue(sessionKey);
expression = expression.Replace(word, value);
}
else if (word.StartsWith("{Resources.", StringComparison.OrdinalIgnoreCase))
{
string res = RemoveBraces(word);
string[] resource = res.Split('.');
string key = resource[2];
expression = expression.Replace(word, ResourceManager.GetString(resource[1], key));
}
else if (word.StartsWith("{DataSource", StringComparison.OrdinalIgnoreCase) &&
word.ToLower(CultureInfo.InvariantCulture).Contains("runningtotalfieldvalue"))
{
string res = RemoveBraces(word);
string[] resource = res.Split('.');
int dataSourceIndex =
Conversion.TryCastInteger(
resource[0].ToLower(CultureInfo.InvariantCulture)
.Replace("datasource", "")
.Replace("[", "")
.Replace("]", ""));
int index =
Conversion.TryCastInteger(
resource[1].ToLower(CultureInfo.InvariantCulture)
.Replace("runningtotalfieldvalue", "")
.Replace("[", "")
.Replace("]", ""));
if (dataSourceIndex >= 0 && index >= 0)
{
if (dataTableCollection != null && dataTableCollection[dataSourceIndex] != null)
{
expression = expression.Replace(word,
GetSum(dataTableCollection[dataSourceIndex], index)
.ToString(CultureInfo.InvariantCulture));
}
}
}
else if (word.StartsWith("{Barcode", StringComparison.OrdinalIgnoreCase))
{
string res = RemoveBraces(word).Replace("Barcode(", "").Replace(")", "");
string barCodeValue = res;
if (res.StartsWith("DataSource"))
{
barCodeValue = ParseDataSource("{" + res + "}", dataTableCollection);
}
string barCodeFormat = ConfigurationHelper.GetReportParameter("BarCodeFormat");
string barCodeDisplayValue = ConfigurationHelper.GetReportParameter("BarCodeDisplayValue");
string barCodeFontSize = ConfigurationHelper.GetReportParameter("BarCodeFontSize");
string barCodeWidth = ConfigurationHelper.GetReportParameter("BarCodeWidth");
string barCodeHeight = ConfigurationHelper.GetReportParameter("BarCodeHeight");
string barCodeQuite = ConfigurationHelper.GetReportParameter("BarCodeQuite");
string barCodeFont = ConfigurationHelper.GetReportParameter("BarCodeFont");
string barCodeTextAlign = ConfigurationHelper.GetReportParameter("BarCodeTextAlign");
string barCodeBackgroundColor = ConfigurationHelper.GetReportParameter("BarCodeBackgroundColor");
string barCodeLineColor = ConfigurationHelper.GetReportParameter("BarCodeLineColor");
string imageSource =
"<img class='reportEngineBarCode' data-barcodevalue='{0}' alt='{0}' value='{0}' data-barcodeformat='{1}' data-barcodedisplayvalue='{2}' data-barcodefontsize='{3}' data-barcodewidth='{4}' data-barcodeheight='{5}' data-barcodefont='{6}' data-barcodetextalign='{7}' data-barcodebackgroundcolor='{8}' data-barcodelinecolor='{9}' data-barcodequite={10} />";
imageSource = string.Format(CultureInfo.InvariantCulture, imageSource, barCodeValue,
barCodeFormat, barCodeDisplayValue, barCodeFontSize, barCodeWidth, barCodeHeight,
barCodeFont, barCodeTextAlign, barCodeBackgroundColor, barCodeLineColor, barCodeQuite);
expression = expression.Replace(word, imageSource).ToString(CultureInfo.InvariantCulture);
}
else if (word.StartsWith("{QRCode", StringComparison.OrdinalIgnoreCase))
{
string res = RemoveBraces(word).Replace("QRCode(", "").Replace(")", "");
string qrCodeValue = res;
if (res.StartsWith("DataSource"))
{
qrCodeValue = ParseDataSource("{" + res + "}", dataTableCollection);
}
string qrCodeRender = ConfigurationHelper.GetReportParameter("QRCodeRender");
string qrCodeBackgroundColor = ConfigurationHelper.GetReportParameter("QRCodeBackgroundColor");
string qrCodeForegroundColor = ConfigurationHelper.GetReportParameter("QRCodeForegroundColor");
string qrCodeWidth = ConfigurationHelper.GetReportParameter("QRCodeWidth");
string qrCodeHeight = ConfigurationHelper.GetReportParameter("QRCodeHeight");
string qrCodeTypeNumber = ConfigurationHelper.GetReportParameter("QRCodeTypeNumber");
string qrCodeDiv =
"<div class='reportEngineQRCode' data-qrcodevalue={0} data-qrcoderender='{1}' data-qrcodebackgroundcolor='{2}' data-qrcodeforegroundcolor='{3}' data-qrcodewidth='{4}' data-qrcodeheight='{5}' data-qrcodetypenumber='{6}'></div>";
qrCodeDiv = string.Format(CultureInfo.InvariantCulture, qrCodeDiv, qrCodeValue, qrCodeRender,
qrCodeBackgroundColor, qrCodeForegroundColor, qrCodeWidth, qrCodeHeight, qrCodeTypeNumber);
expression = expression.Replace(word, qrCodeDiv).ToString(CultureInfo.InvariantCulture);
}
}
return(expression);
}
public static int GetWeekStartDay()
{
return((int)CultureManager.GetCurrentUICulture().DateTimeFormat.FirstDayOfWeek);
}
public static string GetDatePickerLocale()
{
return(CultureManager.GetCurrentUICulture().TwoLetterISOLanguageName);
}
public static string GetDatePickerFormat()
{
string datePattern = CultureManager.GetCurrentUICulture().DateTimeFormat.ShortDatePattern;
return(ConvertDateFormat(datePattern));
}
private void ShowVerificationStatus(string tranId, Label label)
{
if (this.HideVerificationMessage)
{
return;
}
if (this.IsNonGlTransaction)
{
return;
}
long transactionMasterId = Conversion.TryCastLong(tranId);
if (transactionMasterId <= 0)
{
return;
}
Entities.Transactions.Models.VerificationModel model = Status.GetVerificationStatus(this.Catalog, transactionMasterId, this.IsStockTransferRequest);
if (model == null)
{
return;
}
switch (model.VerificationStatusId)
{
case -3:
label.CssClass = "ui block message red";
label.Text = string.Format(CultureManager.GetCurrent(), Labels.TransactionRejectedDetails, model.VerifierName, model.VerifiedDate.ToString(CultureManager.GetCurrentUICulture()), model.VerificationReason);
break;
case -2:
label.CssClass = "ui block message yellow";
label.Text = string.Format(CultureManager.GetCurrent(), Labels.TransactionClosedDetails, model.VerifierName, model.VerifiedDate.ToString(CultureManager.GetCurrentUICulture()), model.VerificationReason);
break;
case -1:
label.Text = string.Format(CultureManager.GetCurrent(), Labels.TransactionWithdrawnDetails, model.VerifierName, model.VerifiedDate.ToString(CultureManager.GetCurrentUICulture()), model.VerificationReason);
label.CssClass = "ui block message yellow";
break;
case 0:
label.Text = Labels.TransactionAwaitingVerification;
label.CssClass = "ui block message blue";
break;
case 1:
label.Text = string.Format(CultureManager.GetCurrent(), Labels.TransactionAutoApprovedDetails, model.VerifierName, model.VerifiedDate.ToString(CultureManager.GetCurrentUICulture()));
label.CssClass = "ui block message green";
break;
case 2:
label.Text = string.Format(CultureManager.GetCurrent(), Labels.TransactionApprovedDetails, model.VerifierName, model.VerifiedDate.ToString(CultureManager.GetCurrentUICulture()));
label.CssClass = "ui block message green";
break;
}
}