public static Hashtable Resources(string subSystem, string cultureID, string labelResourceIDs, string clientMessagesResourceIDs, string serverMessageResourceIDs)
{
cultureID = MappedCultureID(cultureID);
Hashtable localizedResources = new Hashtable();
string sqlQuery = string.Format("exec GetLocalizedStrings '{0}','{1}','{2}','{3}', '{4}'", subSystem, cultureID, labelResourceIDs, clientMessagesResourceIDs, serverMessageResourceIDs);
DataSet dsLocalizedResources = null;
using (Database database = new Database())
{
DbCommand dbCommand = database.GetSqlStringCommand(sqlQuery);
dsLocalizedResources = database.ExecuteDataSet(dbCommand);
}
if (dsLocalizedResources != null && dsLocalizedResources.Tables.Count == 3)
{
string spliter = ",";
string[] arrLabelResourceIDs = labelResourceIDs.Split(spliter.ToCharArray());
string[] arrClientMessagesResourceIDs = clientMessagesResourceIDs.Split(spliter.ToCharArray());
string[] arrServerMessageResourceIDs = serverMessageResourceIDs.Split(spliter.ToCharArray());
if (arrLabelResourceIDs.Length > 0)
{
foreach (string resourceID in arrLabelResourceIDs)
{
DataRow[] resourceRow = dsLocalizedResources.Tables[0].Select("RESX_ID = '" + resourceID + "'");
string resourceValue = cultureID + ":" + resourceID;
if (resourceRow != null && resourceRow.Length == 1)
{
resourceValue = resourceRow[0]["RESX_VALUE"].ToString();
resourceValue = resourceValue.Replace("'", "'"); // ' == '
if (string.IsNullOrEmpty(resourceValue))
{
resourceValue = cultureID + ":?????:" + resourceID;
}
}
localizedResources.Add("L_" + resourceID, resourceValue);
}
}
if (arrClientMessagesResourceIDs.Length > 0)
{
foreach (string resourceID in arrClientMessagesResourceIDs)
{
DataRow[] resourceRow = dsLocalizedResources.Tables[1].Select("RESX_ID = '" + resourceID + "'");
string resourceValue = cultureID + ":" + resourceID;
if (resourceRow != null && resourceRow.Length == 1)
{
resourceValue = resourceRow[0]["RESX_VALUE"].ToString();
resourceValue = resourceValue.Replace("'", "'");
if (string.IsNullOrEmpty(resourceValue))
{
resourceValue = cultureID + ":?????:" + resourceID;
}
}
localizedResources.Add("C_" + resourceID, resourceValue);
}
}
if (arrServerMessageResourceIDs.Length > 0)
{
foreach (string resourceID in arrServerMessageResourceIDs)
{
DataRow[] resourceRow = dsLocalizedResources.Tables[2].Select("RESX_ID = '" + resourceID + "'");
string resourceValue = cultureID + ":" + resourceID;
if (resourceRow != null && resourceRow.Length == 1)
{
resourceValue = resourceRow[0]["RESX_VALUE"].ToString();
resourceValue = resourceValue.Replace("'", "'");
if (string.IsNullOrEmpty(resourceValue))
{
resourceValue = cultureID + ":?????:" + resourceID;
}
}
localizedResources.Add("S_" + resourceID, resourceValue);
}
}
}
return(localizedResources);
}
protected void Page_Load(object sender, EventArgs e)
{
AppCode.ApplicationHelper.ClearSqlPools();
if (string.IsNullOrEmpty(Session["UserID"] as string))
{
Response.Redirect("AccountingLogOn.aspx?AutoLogOff=Y", true);
}
if (!IsPostBack)
{
//Displays the Balance of the User for each job type.
string userID = Session["UserSystemID"] as string;
string userName = Session["UserID"] as string;
string userSource = Session["UserSource"] as string;
string domainName = Session["DomainName"] as string;
deviceModel = Session["OSAModel"] as string;
ApplyThemes();
#region deviceModel == "Wide-SVGA"
if (deviceModel == Constants.DEVICE_MODEL_DEFAULT) //|| deviceModel == "Wide-SVGA"
{
ImageButtonPrintColor.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Print_Icon_Color.png";
ImageButtonPrintColor.Width = 56;
ImageButtonPrintColor.Height = 53;
ImageButtonPrintBW.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Print_Icon_BW.png";
ImageButtonPrintBW.Width = 56;
ImageButtonPrintBW.Height = 53;
ImageButtonCopyColor.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Copy_Icon_Color.png";
ImageButtonCopyColor.Width = 55;
ImageButtonCopyColor.Height = 54;
ImageButtonCopyBW.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Copy_Icon_BW.png";
ImageButtonCopyBW.Width = 55;
ImageButtonCopyBW.Height = 54;
ImageButtonScanColor.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Scan_Icon_Color.png";
ImageButtonScanColor.Width = 68;
ImageButtonScanColor.Height = 44;
ImageButtonScanBW.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Scan_Icon_BW.png";
ImageButtonScanBW.Width = 68;
ImageButtonScanBW.Height = 44;
ImageButtonFaxColor.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Fax_Icon_Color.png";
ImageButtonFaxColor.Width = 61;
ImageButtonFaxColor.Height = 55;
ImageButtonFaxBW.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Fax_Icon_BW.png";
ImageButtonFaxBW.Width = 61;
ImageButtonFaxBW.Height = 55;
ImageButtonMiniStatement.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Ministatement_Icon.png";
ImageButtonMiniStatement.Width = 52;
ImageButtonMiniStatement.Height = 47;
ImageButtonRecharge.ImageUrl = "../App_Themes/Blue/Wide-SVGA/Images/Recharge_Icon.png";
ImageButtonRecharge.Width = 59;
ImageButtonRecharge.Height = 40;
}
#endregion
#region deviceModel == "Wide-XGA"
else if (deviceModel == Constants.DEVICE_MODEL_WIDE_XGA) //|| deviceModel == "Wide-XGA"
{
ImageButtonPrintColor.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Print_Icon_Color.png";
ImageButtonPrintColor.Width = 76;
ImageButtonPrintColor.Height = 72;
ImageButtonPrintBW.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Print_Icon_BW.png";
ImageButtonPrintBW.Width = 76;
ImageButtonPrintBW.Height = 72;
ImageButtonCopyColor.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Copy_Icon_Color.png";
ImageButtonCopyColor.Width = 74;
ImageButtonCopyColor.Height = 74;
ImageButtonCopyBW.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Copy_Icon_BW.png";
ImageButtonCopyBW.Width = 74;
ImageButtonCopyBW.Height = 74;
ImageButtonScanColor.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Scan_Icon_Color.png";
ImageButtonScanColor.Width = 85;
ImageButtonScanColor.Height = 55;
ImageButtonScanBW.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Scan_Icon_BW.png";
ImageButtonScanBW.Width = 85;
ImageButtonScanBW.Height = 55;
ImageButtonFaxColor.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Fax_Icon_Color.png";
ImageButtonFaxColor.Width = 80;
ImageButtonFaxColor.Height = 71;
ImageButtonFaxBW.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Fax_Icon_BW.png";
ImageButtonFaxBW.Width = 80;
ImageButtonFaxBW.Height = 71;
ImageButtonMiniStatement.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Ministatement_Icon.png";
ImageButtonMiniStatement.Width = 72;
ImageButtonMiniStatement.Height = 69;
ImageButtonRecharge.ImageUrl = "../App_Themes/Blue/Wide-XGA/Images/Recharge_Icon.png";
ImageButtonRecharge.Width = 75;
ImageButtonRecharge.Height = 49;
}
#endregion
#region deviceModel == "Wide-VGA"
else if (deviceModel == Constants.DEVICE_MODEL_OSA) //deviceModel == "Wide-VGA"
{
ImageButtonPrintColor.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Print_Icon_Color.png";
ImageButtonPrintColor.Width = 44;
ImageButtonPrintColor.Height = 41;
ImageButtonPrintBW.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Print_Icon_BW.png";
ImageButtonPrintBW.Width = 44;
ImageButtonPrintBW.Height = 41;
ImageButtonCopyColor.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Copy_Icon_Color.png";
ImageButtonCopyColor.Width = 37;
ImageButtonCopyColor.Height = 38;
ImageButtonCopyBW.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Copy_Icon_BW.png";
ImageButtonCopyBW.Width = 37;
ImageButtonCopyBW.Height = 38;
ImageButtonScanColor.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Scan_Icon_Color.png";
ImageButtonScanColor.Width = 46;
ImageButtonScanColor.Height = 30;
ImageButtonScanBW.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Scan_Icon_BW.png";
ImageButtonScanBW.Width = 46;
ImageButtonScanBW.Height = 30;
ImageButtonFaxColor.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Fax_Icon_Color.png";
ImageButtonFaxColor.Width = 43;
ImageButtonFaxColor.Height = 38;
ImageButtonFaxBW.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Fax_Icon_BW.png";
ImageButtonFaxBW.Width = 43;
ImageButtonFaxBW.Height = 38;
ImageButtonMiniStatement.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Ministatement_Icon.png";
ImageButtonMiniStatement.Width = 37;
ImageButtonMiniStatement.Height = 38;
ImageButtonRecharge.ImageUrl = "../App_Themes/Blue/Wide-VGA/Images/Recharge_Icon.png";
ImageButtonRecharge.Width = 43;
ImageButtonRecharge.Height = 29;
}
#endregion
else
{
Response.Redirect("../PSPModel/JobList.aspx");
}
// Add Details in to Database
string mfpaddress = Request.Params["REMOTE_ADDR"] as string;
string miniBalance = DataManagerDevice.ProviderDevice.ApplicationSettings.ProvideSetting("Minimum Balance");
if (!string.IsNullOrEmpty(miniBalance))
{
minimumBalance = decimal.Parse(miniBalance);
}
accBalance = Helper.UserAccount.GetBalance(userID);
string updateLoginDetails = DataManagerDevice.Controller.Device.UpdateTimeOutDetails(Session["UserSystemID"] as string, mfpaddress);
string applicationTimeOut = string.Empty;
if (Session["ApplicationTimeOut"] == null)
{
applicationTimeOut = DataManagerDevice.ProviderDevice.ApplicationSettings.ProvideSetting("Time out");
Session["ApplicationTimeOut"] = applicationTimeOut;
}
else
{
applicationTimeOut = Session["ApplicationTimeOut"] as string;
}
HiddenFieldIntervalTime.Value = applicationTimeOut;
if (!string.IsNullOrEmpty(userID))
{
AccUser.Text = "" + userName;
string path = Server.MapPath("~/");
string currencySetting = DataManagerDevice.ProviderDevice.ApplicationSettings.currencySettings(path);
AccBal.Text = currencySetting + " " + Helper.UserAccount.GetBalance(userID).ToString("0.00");
AccBalBW.Text = currencySetting + " " + Helper.UserAccount.GetBalance(userID).ToString("0.00");
}
//Check the balance of the user and then display for each job type, how many pages the user can execute
string mfpIP = Request.Params["REMOTE_ADDR"] as string;
string costProfId = string.Empty;
//string mfpGrpId = string.Empty;
//string getMfpGroupId = "select GRUP_ID from T_GROUP_MFPS where MFP_IP='" + mfpIP + "'";
//using (AppLibrary.Database dbGrpDet = new AppLibrary.Database())
//{
// try
// {
// DbCommand cmdGrpDetails = dbGrpDet.GetSqlStringCommand(getMfpGroupId);
// DataSet grpId = dbGrpDet.ExecuteDataSet(cmdGrpDetails);
// mfpGrpId = Convert.ToString(grpId.Tables[0].Rows[0].ItemArray[0]);
// }
// catch { }
//}
string getCostProfId = "SELECT COST_PROFILE_ID FROM T_ASSGIN_COST_PROFILE_MFPGROUPS WHERE MFP_GROUP_ID = '" + mfpIP + "'";
using (AppLibrary.Database dbCostProfDetails = new AppLibrary.Database())
{
try
{
DbCommand cmdCostDetails = dbCostProfDetails.GetSqlStringCommand(getCostProfId);
grpId = dbCostProfDetails.ExecuteDataSet(cmdCostDetails);
if (grpId != null && grpId.Tables[0].Rows.Count > 0)
{
costProfId = Convert.ToString(grpId.Tables[0].Rows[0].ItemArray[0]);
string getPrintPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Print' and PAPER_SIZE in('A4','A3','A4R','LETTER','LEGAL','LEDGER')";
string getCopyPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Copy' and PAPER_SIZE in('A4','A3','A4R','LETTER','LEGAL','LEDGER')";
string getScanPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Scan' and PAPER_SIZE in('A4','A3','A4R','LETTER','LEGAL','LEDGER')";
string getFaxPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Fax' and PAPER_SIZE in('A4','A3','A4R','LETTER','LEGAL','LEDGER')";
//string getPrintPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Print' and PAPER_SIZE = 'A4'";
//string getScanPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Scan' and PAPER_SIZE = 'A4'";
//string getCopyPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Copy' and PAPER_SIZE = 'A4'";
//string getFaxPriceCmd = "select PRICE_PERUNIT_COLOR, PRICE_PERUNIT_BLACK from T_PRICES where PRICE_PROFILE_ID = '" + costProfId + "' and JOB_TYPE = 'Fax' and PAPER_SIZE = 'A4'";
DbCommand cmdPrintPrice = dbCostProfDetails.GetSqlStringCommand(getPrintPriceCmd);
DataSet PrintPriceDet = dbCostProfDetails.ExecuteDataSet(cmdPrintPrice);
if (PrintPriceDet != null && PrintPriceDet.Tables[0].Rows.Count > 0)
{
colorPrintPrice = Convert.ToInt32(PrintPriceDet.Tables[0].Rows[0].ItemArray[0]);
bwPrintPrice = Convert.ToInt32(PrintPriceDet.Tables[0].Rows[0].ItemArray[1]);
}
DbCommand cmdScanPrice = dbCostProfDetails.GetSqlStringCommand(getScanPriceCmd);
DataSet scanPriceDet = dbCostProfDetails.ExecuteDataSet(cmdScanPrice);
if (scanPriceDet != null && scanPriceDet.Tables[0].Rows.Count > 0)
{
colorScanPrice = Convert.ToInt32(scanPriceDet.Tables[0].Rows[0].ItemArray[0]);
bwScanPrice = Convert.ToInt32(scanPriceDet.Tables[0].Rows[0].ItemArray[1]);
}
DbCommand cmdCopyPrice = dbCostProfDetails.GetSqlStringCommand(getCopyPriceCmd);
DataSet copyPriceDet = dbCostProfDetails.ExecuteDataSet(cmdCopyPrice);
if (copyPriceDet != null && copyPriceDet.Tables[0].Rows.Count > 0)
{
colorCopyPrice = Convert.ToInt32(copyPriceDet.Tables[0].Rows[0].ItemArray[0]);
bwCopyPrice = Convert.ToInt32(copyPriceDet.Tables[0].Rows[0].ItemArray[1]);
}
DbCommand cmdFaxPrice = dbCostProfDetails.GetSqlStringCommand(getFaxPriceCmd);
DataSet FaxPriceDet = dbCostProfDetails.ExecuteDataSet(cmdFaxPrice);
if (FaxPriceDet != null && FaxPriceDet.Tables[0].Rows.Count > 0)
{
colorFaxPrice = Convert.ToInt32(FaxPriceDet.Tables[0].Rows[0].ItemArray[0]);
bwFaxPrice = Convert.ToInt32(FaxPriceDet.Tables[0].Rows[0].ItemArray[1]);
}
string UserId = Session["UserSystemID"] as string;
string path = Server.MapPath("~/");
accBalance = Helper.UserAccount.GetBalance(UserId);
if (accBalance <= 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "ShowMessage(0);", true);
LabelErrorMessage.Text = "You have low balance";
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "ShowMessage(0);", true);
if (grpId.Tables[0].Rows.Count <= 0 && AccBal.Text == "0")
{
LabelErrorMessage.Text = "Please assign Cost Profile to MFP and Add Balance ";
}
else if (grpId.Tables[0].Rows.Count <= 0)
{
LabelErrorMessage.Text = "This MFP is not assigned to Cost Profile";
}
else if (AccBal.Text == "0")
{
LabelErrorMessage.Text = "You have low balance.";
}
}
}
catch (Exception ex)
{
}
}
}
string printFileCount = string.Empty;
string printfileCountBW = string.Empty;
ProvideNumberOfFiles(out printFileCount, out printfileCountBW);
hiddenfieldPrintFileCount.Value = printFileCount;
hiddenfieldPrintFileCountBW.Value = printfileCountBW;
//LabelFileCount.Text = printfileCountBW;
GetUIControlsDetails(printFileCount);
try
{
sessionTimeOut = DataManagerDevice.ProviderDevice.ApplicationSettings.ProvideSetting("Time out");
}
catch
{ }
CheckUserMinimiumBalance(minimumBalance, accBalance);
}