public DataTable LoadReport()
{
try
{
string Query =
string.Format(@"EXECUTE sp_rptFinancialParcelOfFirstState
@FirstState={0},@FirstCity={1},@FirstPostNode={2}
,@LastState={3},@LastCity={4},@LastPostNode={5}
,@FirstDate='{6}',@LastDate='{7}',@PayType={8},@BarcodeStatus={9}",
_host.ddlState.SelectedValue
, _host.ddlCity.SelectedValue
, _host.ddlPostNode.SelectedValue
, _host.ddlLastState.SelectedValue
, _host.ddlLastCity.SelectedValue
, _host.ddlLastPostNode.SelectedValue
, _host.Fdate
, _host.Ldate
, _host.ddlCredit.SelectedValue
, _host.ddlBarcodeStatus.SelectedValue);
return(exe.SqlDataTable(Query));
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptBarcodeDetail ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
return(exe.SqlDataTable(Query));
}
}
public DataSet LoadReport()
{
try
{
string Query =
string.Format(@"EXECUTE sp_rptCountDebitForState
@FirstState={0},@FirstCity={1},@FirstPostNode={2}
,@LastState={3},@Date1='{4}',@Date2='{5}',@StatusID='{6}',@IsReceipt={7}
,@LastCity={8},@LastPostNode={9}",
_host.ddlState.SelectedValue
, _host.ddlCity.SelectedValue
, _host.ddlPostNode.SelectedValue
, _host.ddlLastState.SelectedValue
, _host.Fdate
, _host.Ldate
, _host.hfStateList.Value
, _host.ddlIsReceipt.SelectedValue
, _host.ddlLastCity.SelectedValue
, _host.ddlLastPostNode.SelectedValue);
return(exe.SqlDataSet(Query));
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptCountDebitForState ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
return(exe.SqlDataSet(Query));
}
}
public void SaveLogError(Exception e, string ctlName, HttpServerUtility Server)
{
try
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, e.Message.Replace("'", "")
, DateAndTime.GetDateTime16Digit_Latin()
, ctlName
, "", "");
db.SqlExecute(Query);
}
catch
{
string strErrorMessage =
string.Format
(
"{0} Time: {1:yyyy/MM/dd - HH:mm:ss}, Path: {2}, User IP: {3}",
e.Message,
System.DateTime.Now,
ctlName,
""
);
System.IO.StreamWriter oStream = null;
try
{
string strApplicationLogRootRelativePathName =
"~/App_Data/Logs/Application.log";
string strApplicationLogPathName =
Server.MapPath(strApplicationLogRootRelativePathName);
lock (this)
{
oStream =
new System.IO.StreamWriter
(strApplicationLogPathName, true, System.Text.Encoding.UTF8);
oStream.WriteLine(strErrorMessage);
}
}
catch
{
}
finally
{
if (oStream != null)
{
oStream.Dispose();
oStream = null;
}
}
}
}
public DataTable LoadReport()
{
DataTable dt = new DataTable();
try
{
string Query =
string.Format(@"EXECUTE sp_rptStateIncomingParcels
@fDate='{0}' ,@lDate='{1}' ,@LastStateCode={2} ,@LastCityCode={3}
,@LastPostNode={4},@FirstStateCode={5} ,@ReceiptState='{6}' ,@ExchangeState={7}
,@ServiceType={8} ,@IsContract='{9}' ,@GContractID={10} ,@RoleID={11}",
_host.Fdate, _host.Ldate, _host.ddlLastState.SelectedValue, _host.ddlLastCity.SelectedValue
, _host.ddlLastPostNode.SelectedValue, _host.ddlFirstState.SelectedValue, _host.ddlReceiptState.SelectedValue
, _host.ddlExchangeState.SelectedValue
, _host.ddlServiceType.SelectedValue, _host.ddlContractType.SelectedValue, _host.ddlGC.SelectedValue, UserInfo.RoleID);
dt = exe.SqlDataTable(Query);
return(dt);
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptCountDebitForState ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
exe.SqlDataSet(Query);
return(dt);
}
}
private void LoadReport()
{
try
{
string Query =
string.Format(@"EXECUTE sp_rptBarcodeDetail
@UserID={0},@fDate='{1}',@lDate='{2}',@StateCode={3}
,@CityCode={4},@PostNode={5},@StatusID={6}"
, param.UserID, param.FirstDate, param.LastDate, param.StateCode
, param.CityCode, param.PostNodeCode, param.BarcodeStatusID);
dtReport = _host.SqlDataTable(Query);
//Label16.Text = "(از تاریخ : " + param.FirstDate + " تا تاریخ:" +param.LastDate + ")";
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptBarcodeDetail ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}
private void LoadReport()
{
try
{
string Query =
string.Format(@"EXECUTE sp_rptReceiptDetail
@Fdate='{0}'
,@Ldate='{1}'
,@StateCode={2}
,@CityCode={3}
,@PostNode={4}
,@UserID={5}
,@ReceiptTypeValue={6}
,@FinancialMoodValue={7}
,@ApproveFlag='{8}'
,@IsPhish={9}"
, param.FirstDate
, param.LastDate
, param.StateCode
, param.CityCode
, param.PostNodeCode
, param.UserID
, param.ReceiptTypeValue
, param.FinancialMoodValue
, param.ApproveFlag
, param.PayType);
dtReport = _host.SqlDataTable(Query);
//_StimReport["UserName"] = UserName;
//_StimReport["PostNodeName"] = _LoginDetails.CityName + "-" + _LoginDetails.PostNodeName;
//_StimReport["ReportDate"] = ReportDate;
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptBarcodeDetail ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}
private void LoadReport()
{
try
{
string Query =
string.Format(@"EXEC sp_Udate_GhaboolAndMobadeleh_New
@Date1 = '{0}',
@Date2 = '{1}',
@FirstState = {2},
@FirstCity = {3},
@FirstPostNode = {4},
@LastState = {5},
@UserId = '{6}',
@IsInitialize = {7}
"
, param.FirstDate
, param.LastDate
, param.StateCode
, param.CityCode
, param.PostNodeCode
, param.LastStateCode
, _LoginDetails.ID
, 1);
dtReport = _host.SqlDataTable(Query);
FindName(out StateName, out CityName, out PostNode_Name);
//_StimReport["UserName"] = UserName;
//_StimReport["PostNodeName"] = _LoginDetails.CityName + "-" + _LoginDetails.PostNodeName;
//_StimReport["ReportDate"] = ReportDate;
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : sp_Udate_GhaboolAndMobadeleh in Total Segment ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
UserValidate();
ReportObject(ANP.Data.BaseData.Library.Encryption.Decrypt(Request.QueryString["pra"].ToString()));
string ConnectionString = _host.ConnectionString;
Stimulsoft.Report.StiReport _report = new StiReport();
_report.Load(Resources.mrtFinancialParcelOfFirstState);
_report.Dictionary.Databases.Clear();
_report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("PofficeCOD186", ConnectionString));
_report.Compile();
_report["FirstState"] = (ddlState == string.Empty ? 0 : Convert.ToInt32(ddlState));
_report["FirstCity"] = (ddlCity == string.Empty ? 0 : Convert.ToInt32(ddlCity));
_report["FirstPostNode"] = (ddlPostNode == string.Empty ? 0 : Convert.ToInt32(ddlPostNode));
_report["LastState"] = (ddlLastState == string.Empty ? 0 : Convert.ToInt32(ddlLastState));
_report["LastCity"] = (ddlLastCity == string.Empty ? 0 : Convert.ToInt32(ddlLastCity));
_report["LastPostNode"] = (ddlLastPostNode == string.Empty ? 0 : Convert.ToInt32(ddlLastPostNode));
_report["FirstDate"] = Fdate;
_report["LastDate"] = Ldate;
_report["PayType"] = (ddlCredit == string.Empty ? 0 : Convert.ToInt32(ddlCredit));
_report["BarcodeStatus"] = (ddlBarcodeStatus == string.Empty ? 0 : Convert.ToInt32(ddlBarcodeStatus));
_report["BarcodeSubStatus"] = (ddlBarcodeSubStatus == string.Empty ? 0 : Convert.ToInt32(ddlBarcodeSubStatus));
_report["UserName"] = _LoginDetails.Pname + " " + _LoginDetails.RolePname + " از " + _LoginDetails.StateName;
_report["ReportDate"] = DateAndTime.GetSQLDate10DigitShamsi() + " -- " + DateAndTime.GetSQLTime8Digit();
StiWebViewer1.Report = _report;
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptFinancialParcelOfFirstState ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}
private DataTable LoadReportDetail()
{
try
{
string Query =
string.Format(@"EXEC sp_Udate_GhaboolAndMobadeleh_New
@Date1 = '{0}',
@Date2 = '{1}',
@FirstState = {2},
@FirstCity = {3},
@FirstPostNode = {4},
@LastState = {5},
@UserId = '{6}',
@IsInitialize = {7}
"
, param.FirstDate
, param.LastDate
, param.StateCode
, param.CityCode
, param.PostNodeCode
, param.LastStateCode
, _LoginDetails.ID
, 2);
return(_host.SqlDataTable(Query));
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : sp_Udate_GhaboolAndMobadeleh in Detail Segment ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
return(new DataTable());
}
}
private void LoadReport()
{
try
{
string Query =
string.Format(@"EXECUTE sp_rptOneBarCodeDetail
@RoleID={0}
,@StateCode={1}
,@CityCode={2}
,@PostNode={3}
,@BarCode='{4}'
,@UserID={5}",
_LoginDetails.RoleID,
_LoginDetails.StateCode,
_LoginDetails.CityCode,
_LoginDetails.PostNodeCode,
param.BarCode,
_LoginDetails.UserId);
dtReport = _host.SqlDataTable(Query);
IsDeleted = dtReport.Rows[0]["IsDeleted"].ToString();
//_StimReport["UserName"] = UserName;
//_StimReport["PostNodeName"] = _LoginDetails.CityName + "-" + _LoginDetails.PostNodeName;
//_StimReport["ReportDate"] = ReportDate;
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptBarcodeDetail ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}
protected void btn_login_Click(object sender, EventArgs e)
{
lbl_msg.Text = string.Empty;
string Query = "";
string Message = string.Format("userName= {0} , Pass= {1} , Date= {2} , IP= {3} , Browser= {4}", txt_UserName.Text, txt_Password.Text
, DateAndTime.GetDateTime16Digit(), Request.UserHostAddress, Request.Browser.Browser);
Query = string.Format(@"insert INTO tblLog ( Title,Detail ) VALUES (N'{0}',N'{1}')", "صفحه ورود ", Message.Replace("'", ""));
Utility.RunQuery(Query);
if (Request.UserHostAddress.Replace("'", "") == "10.1.1.52" || Request.UserHostAddress == "10.1.1.52")
{
Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, string.Format("userName= {0} , Pass= {1}", txt_UserName.Text, txt_Password.Text)
, DateAndTime.GetDateTime16Digit_Latin()
, "صفحه ورود . کاربر مشکوک سعی در ورود به نرم افزار کرد ."
, Request.UserHostAddress.Replace("'", "")
, Request.Browser.Browser.Replace("'", ""));
Utility.RunQuery(Query);
Response.Redirect("~/Wrongdoer.aspx", true);
}
object UserData = Logins.chkUser();
if (UserData != null)
{
Session["UserInfo"] = UserData;
lbl_msg.Text = "";
FillCookie(UserData);
Response.Redirect("~/Default.aspx?action=b4c96ed1-30a8-4766-9c07-80172e0cd1dd", true);
}
lbl_msg.Text = "کاربر مورد نظر یافت نشد";
}
private void LoadReport()
{
try
{
string ConnectionString = _host.ConnectionString;
Stimulsoft.Report.StiReport _report = new StiReport();
_report.Load(Resources.mrtBarcodeDetailes);
_report.Dictionary.Databases.Clear();
_report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("PofficeCOD186", ConnectionString));
_report.Compile();
_report["UserID"] = (param.UserID.Trim() == string.Empty ? "0" : param.UserID.Trim());
_report["fDate"] = (param.FirstDate.Trim() == string.Empty ? "1500/01/01" : param.FirstDate.Trim());
_report["lDate"] = (param.LastDate.Trim() == string.Empty ? "1500/01/01" : param.LastDate.Trim());
_report["StateCode"] = (param.StateCode.Trim() == string.Empty ? 0 : Convert.ToInt32(param.LastStateCode));
_report["CityCode"] = (param.CityCode.Trim() == string.Empty ? 0 : Convert.ToInt32(param.CityCode));
_report["PostNode"] = (param.PostNodeCode.Trim() == string.Empty ? 0 : Convert.ToInt32(param.PostNodeCode));
_report["StatusID"] = (param.BarcodeStatusID.Trim() == string.Empty ? 0 :Convert.ToInt32(param.BarcodeStatusID));
_report["UserName"] = _LoginDetails.Pname + " " + _LoginDetails.RolePname + " از " + _LoginDetails.StateName;
_report["ReportDate"] = DateAndTime.GetSQLDate10DigitShamsi() + " -- " + DateAndTime.GetSQLTime8Digit();
StiWebViewer1.Report = _report;
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptBarcodeDetail ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}
void Application_Error(object sender, EventArgs e)
{
if ((Server != null) &&
(Server.GetLastError() != null) &&
(Server.GetLastError().GetBaseException() != null))
{
System.Exception ex =
Server.GetLastError().GetBaseException();
try
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, ex.Message.Replace("'", "")
, DateAndTime.GetDateTime16Digit_Latin()
, Request.PhysicalPath.Replace("'", "")
, Request.UserHostAddress.Replace("'", "")
, Request.Browser.Browser.Replace("'", ""));
Utility.RunQuery(Query);
}
catch
{
string strErrorMessage =
string.Format
(
"{0} Time: {1:yyyy/MM/dd - HH:mm:ss}, Path: {2}, User IP: {3}",
ex.Message,
System.DateTime.Now,
Request.PhysicalPath,
Request.UserHostAddress
);
Application.Lock();
System.IO.StreamWriter oStream = null;
try
{
string strApplicationLogRootRelativePathName =
"~/App_Data/Logs/Application.log";
string strApplicationLogPathName =
Server.MapPath(strApplicationLogRootRelativePathName);
oStream =
new System.IO.StreamWriter
(strApplicationLogPathName, true, System.Text.Encoding.UTF8);
oStream.WriteLine(strErrorMessage);
}
catch
{
}
finally
{
if (oStream != null)
{
oStream.Dispose();
oStream = null;
}
}
Application.UnLock();
}
}
Response.Redirect("~/erorr.aspx", true);
}