protected void Page_PreRender(object sender, EventArgs e)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
if (objAuthorizationBDto.ProgramWriteAccess == true && objAuthorizationBDto.ProgramDeleteAccess == true)
{
btnAssignRightModule.Enabled = true;
btnAssignLeftModule.Enabled = true;
btnSave.Enabled = true;
}
if (objAuthorizationBDto.ProgramWriteAccess == true && objAuthorizationBDto.ProgramDeleteAccess != true)
{
btnAssignRightModule.Enabled = true;
btnAssignLeftModule.Enabled = false;
btnSave.Enabled = true;
}
if (objAuthorizationBDto.ProgramWriteAccess != true && objAuthorizationBDto.ProgramDeleteAccess == true)
{
btnAssignRightModule.Enabled = false;
btnAssignLeftModule.Enabled = true;
btnSave.Enabled = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
string usrid = Session["usersid"].ToString();
if (objAuthorizationBDto != null)
{
_empID = Convert.ToInt32(Session["empid"]);
}
String query = "SELECT TOP 5 TOUR_SHORT_NAME,TOUR_QUOTE_MASTER.QUOTE_ID,TOUR_QUOTE_MASTER.TOUR_ID,CONVERT(varchar(10),TOUR_QUOTE_MASTER.RECONFIRMATION_DATE,103) AS DATE FROM FARE_TOUR_MASTER LEFT OUTER JOIN TOUR_QUOTE_MASTER ON FARE_TOUR_MASTER.TOUR_ID=TOUR_QUOTE_MASTER.TOUR_ID WHERE ORDER_STATUS='4' AND RECONFIRMATION_DATE BETWEEN GETDATE() AND GETDATE()+7";
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
DataSet ds = objfitquote.fetchallData("FETCH_ALL_BOOKING_TO_BE_RECONFIRMED", usrid);
Session["editorderstatus"] = ds.Tables[0].Rows[0]["ORDER_STATUS"].ToString();
//_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + " " + dr["TOUR_SHORT_NAME"].ToString() + " " + dr["DATE"].ToString() + "<a href=\"../../Views/FIT/BookingFit.aspx?TOURID=" + dr["TOUR_ID"].ToString() + ""EID=" + dr["QUOTE_ID"].ToString() + "" + "\"><br/>View</a>");
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + " " + dr["TOUR_SHORT_NAME"].ToString() + "<div align=\"left\" style=\"font-size:11px;color:red;\">" + dr["DATE"].ToString() + "<a href=\"../../Views/FIT/BookingFit.aspx?TOURID=" + dr["TOUR_ID"].ToString() + ""EID=" + dr["QUOTE_ID"].ToString() + "" + "\"><br/>View</a>");
}
_sbi.AppendLine("</ul>");
// _sbi.AppendLine("<a href=\"../../Views/FIT/AllBookingsToBeReconfirmed.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_PreInit(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
_userID = objAuthorizationBDto.UserProfile.UserId;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
acbGeographicLocation.ExportButton.Enabled = false;
BindGridCountry();
BindGridState();
BindGridCity();
}
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
Session["currentevent"] = "GeographicLocation";
}
hdnEditableModeCountry.Value = "false";
hdnEditableModeState.Value = "false";
hdnEditableModeCity.Value = "false";
acbGeographicLocation.AddAttributeToEditButton("onClick", String.Format("javascript:return ValidateEdit('{0}')", radgrdCountry.ClientID));
acbGeographicLocation.AddAttributeToDeleteButton("onClick", String.Format("javascript:return ValidateDelete('{0}')", radgrdCountry.ClientID));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
lblWelcome.Text = "Logged in as: " + objAuthorizationBDto.UserProfile.UserName + "(" + objAuthorizationBDto.UserSelectedRoleName + ")";
lblPreferedCompanyName.Text = objAuthorizationBDto.UserSelectedCompanyName;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
}
if (!IsPostBack)
{
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
if (!objAuthorizationBDto.ProgramWriteAccess)
{
cbxCompany.SaveButton.Enabled = false;
cbxCompany.SaveNewButton.Enabled = false;
cbxCompany.CopyButton.Enabled = false;
}
}
}
/// <summary>
/// Page load event
/// </summary>
/// <param name="sender">The object which raised the event</param>
/// <param name="e">The event listener object</param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
}
hdnEditableMode.Value = "false";
acbOutputCheckList.AddAttributeToEditButton("onClick", String.Format("javascript:return ValidateEdit('{0}')", radgrdOutputCheckList.ClientID));
acbOutputCheckList.AddAttributeToDeleteButton("onClick", String.Format("javascript:return ValidateDelete('{0}')", radgrdOutputCheckList.ClientID));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
}
if (!IsPostBack)
{
BindCompanyRoleGrid();
//Function to select one Radio Button at a time
SetGrdCompanyRoleRadioButtonOnClick();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
Session["currentevent"] = "Role Access Mapping";
}
String sEventArguments = Request.Params["__EVENTARGUMENT"];
if (sEventArguments == "DeleteModule")
DeallocateModule();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
Session["currentevent"] = "Religion";
}
acbReligion.AddAttributeToEditButton("onClick", String.Format("javascript:return ValidateEdit('{0}')", radgrdReligion.ClientID));
acbReligion.AddAttributeToDeleteButton("onClick", String.Format("javascript:return ValidateDelete('{0}')", radgrdReligion.ClientID));
}
protected void Page_Load(object sender, EventArgs e)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (!IsPostBack)
{
BindThemeList();
SetTheme();
GetEmployeeDetails();
}
pnlDisplayInfo.Visible = true;
pnlEditInfo.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
_userID = objAuthorizationBDto.UserProfile.UserId;
string query = "SELECT TOP 5 ANNOUNCEMENT_BODY,CONVERT(varchar(10),DATE_CREATED,101) as DATE,suma.USER_NAME FROM COMMON_ANNOUNCEMENT_MASTER cam join dbo.SYS_USER_MASTER suma on suma.USER_ID=cam.CREATED_BY ORDER BY DATE_CREATED";
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:13px;padding:5px;\">" + dr["ANNOUNCEMENT_BODY"].ToString() + "</br><div align=\"right\" style=\"font-size:9px;\"><b>Added on : " + dr["DATE"].ToString() + " by : " + dr["USER_NAME"].ToString() + "</b></div></li>");
}
_sbi.AppendLine("</ul>");
divanc.InnerHtml = _sbi.ToString();
}
/// <summary>
/// Page load event
/// </summary>
/// <param name="sender">The object which raised the event</param>
/// <param name="e">The event listener object</param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
mvCompany.SetActiveView(vwCompany);
}
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
Session["currentevent"] = "Manage Company";
}
hdnEditableMode.Value = "false";
acbCompany.AddAttributeToEditButton("onClick", String.Format("javascript:return ValidateGridForEdit('{0}')", radgrdCompany.ClientID));
acbCompany.AddAttributeToDeleteButton("onClick", String.Format("javascript:return ValidateDelete('{0}')", radgrdCompany.ClientID));
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
_empID = Convert.ToInt32(Session["empid"]);
}
String query = "SELECT FARE_CRUISE_SCHEDULE_MASTER.CRUISE_NAME ,CONVERT(varchar(10),FARE_TOUR_CRUISE_DETAIL.TIME_LIMIT,101) AS DATE,FARE_TOUR_MASTER.TOUR_SHORT_NAME FROM FARE_TOUR_CRUISE_DETAIL,FARE_CRUISE_SCHEDULE_MASTER ,FARE_TOUR_MASTER WHERE FARE_TOUR_CRUISE_DETAIL.TOUR_ID = FARE_TOUR_MASTER.TOUR_ID AND FARE_TOUR_CRUISE_DETAIL.CRUISE_SCHEDULE_ID = FARE_CRUISE_SCHEDULE_MASTER.CRUISE_ID AND FARE_TOUR_CRUISE_DETAIL.BOOKING_STATUS != 1 AND DATEDIFF(dd,GETDATE(),FARE_TOUR_CRUISE_DETAIL.TIME_LIMIT) <= 15 AND FARE_TOUR_CRUISE_DETAIL.BOOKING_REQUEST_TO =" + _empID;
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:15px;padding:3px;\"> Cruise : " + dr["CRUISE_NAME"].ToString() + "</br><div align=\"left\" style=\"font-size:11px;color:red;\"><b>Time Limit : " + dr["DATE"].ToString() + "</b></br> Tour : " + dr["TOUR_SHORT_NAME"].ToString() + "</div></li>");
}
_sbi.AppendLine("</ul>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
_empID = Convert.ToInt32(Session["empid"]);
}
String query = "SELECT TOP 5 PACKAGE_NAME,PRICE,CURRENCY FROM SPECIAL_OFFER WHERE DISPLAY_ON_DASHBOARD='YES'";
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + dr["PACKAGE_NAME"].ToString() + "</br><div align=\"left\" style=\"font-size:11px;color:red;\"><b>Price : " + dr["PRICE"].ToString()+" "+ dr["CURRENCY"].ToString());
}
_sbi.AppendLine("</ul>");
// _sbi.AppendLine("<a href=\"../../Views/Sales/Tour.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
_empID = Convert.ToInt32(Session["empid"]);
}
String query = "SELECT COALESCE(CHART_OF_ACCOUNTS.CL_BALANCE,0) AS CL_BALANCE,CHART_OF_ACCOUNTS.GL_DESCRIPTION FROM CHART_OF_ACCOUNTS WHERE ACCOUNT_FLAG='A' AND CHART_OF_ACCOUNTS.CL_BALANCE <> 0 ORDER BY GL_DESCRIPTION";
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + dr["GL_DESCRIPTION"].ToString() + "</br><div align=\"left\" style=\"font-size:11px;color:red;\"><b>Amount : " + dr["CL_BALANCE"].ToString()+" "+"THB");
}
_sbi.AppendLine("</ul>");
// _sbi.AppendLine("<a href=\"../../Views/Sales/Tour.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
_empID = Convert.ToInt32(Session["empid"]);
}
String query = "SELECT TITLE,EMP_NAME,CONVERT(varchar(10),START_DATE,101) AS DATE FROM MYTASK_MASTER,EMP_EMPLOYEE_MASTER WHERE MYTASK_MASTER.ASSIGN_BY = EMP_EMPLOYEE_MASTER.EMP_ID AND MYTASK_MASTER.STATUS_ID != 1 AND DATEDIFF(dd,GETDATE(),MYTASK_MASTER.START_DATE) <= 15 AND MYTASK_MASTER.ASSIGN_TO = " + _empID;
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:15px;padding:3px;\">" + dr["TITLE"].ToString() + "</br><div align=\"right\" style=\"font-size:11px;color:red\"><b>Started on : " + dr["DATE"].ToString() + " | By : " + dr["EMP_NAME"].ToString() + "</b></div></li>");
}
_sbi.AppendLine("</ul>");
_sbi.AppendLine("<a href=\"../../Views/Sales/Tour.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
Session["currentevent"] = "Tour Flash";
}
else
{
objAuthorizationBDto = new AuthorizationBDto();
}
if (!IsPostBack)
{
ControlBox1_ResetClick(ControlBox1, new EventArgs());
}
ControlBox1.CancelButton.Text = "Reset";
//ControlBox1.AddAttributeToClearButton("onClick", "javascript:return ControlBox1_ClearClientClick()");
}
protected void Page_PreRender(object sender, EventArgs e)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
if (!objAuthorizationBDto.ProgramWriteAccess)
{
}
}
if (!IsPostBack)
{
objBindCombo = new BindCombo();
DataSet dsCountry = objBindCombo.GetCountryKeyValue();
DataSet dsregion = objBindCombo.GetRegionKeyValue();
BindRegionCombo(radAirline, dsregion);
bindCountryCombo(radCmbDestination, dsCountry);
}
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
_empID = Convert.ToInt32(Session["empid"]);
}
String query = "SELECT SUPPLIER_CONTACT_DETAILS.CHAIN_NAME , HOTEL_DASHBOARD_MASTER.DESCRIPTION FROM HOTEL_DASHBOARD_MASTER LEFT OUTER JOIN SUPPLIER_CONTACT_DETAILS ON SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO = HOTEL_DASHBOARD_MASTER.HOTEL_PRICE_LIST_ID WHERE HOTEL_DASHBOARD_MASTER.CITY_ID='571' AND IS_DASHBOARD='YES'";
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + dr["CHAIN_NAME"].ToString()
+ "</br><div align=\"left\" style=\"font-size:11px;color:red;\"><b>Description : " + dr["DESCRIPTION"].ToString());
}
_sbi.AppendLine("</ul>");
// _sbi.AppendLine("<a href=\"../../Views/Sales/Tour.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
_empID = Convert.ToInt32(Session["empid"]);
}
//String query = "SELECT PURCHASE_PAYMENT_VOUCHER_DETAILS.GL_CODE,SUM(CR_AMOUNT) AS TOTAL_PAYMENT_MADE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS WHERE CONVERT (VARCHAR(10), PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE,103)=CONVERT(VARCHAR(10),GETDATE(),103) GROUP BY GL_CODE";
String query = "SELECT PURCHASE_PAYMENT_VOUCHER_DETAILS.GL_CODE,CR_AMOUNT AS TOTAL_PAYMENT_MADE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS WHERE PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE BETWEEN GETDATE() AND GETDATE()+7 ";
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + dr["GL_CODE"].ToString()+" " + dr["TOTAL_PAYMENT_MADE"].ToString() + " " + "THB");
}
_sbi.AppendLine("</ul>");
_sbi.AppendLine("<a href=\"../../Views/Account/Payment.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString != null && Request.QueryString.Count > 0)
{
switch (Request.QueryString["Action"].ToLower())
{
case "addnewuser":
acbUser_NewClick(new object(), new EventArgs());
break;
}
}
BindGrid();
}
if (Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
Session["currentevent"] = "Manage User";
}
hdnEditableMode.Value = "false";
acbUser.AddAttributeToEditButton("onClick", String.Format("javascript:return ValidateEdit('{0}')", radgrdUser.ClientID));
acbUser.AddAttributeToDeleteButton("onClick", String.Format("javascript:return ValidateDelete('{0}')", radgrdUser.ClientID));
}
public static void CheckUserAuthorizationForProgram(string ProgramName)
{
DataTable dtAccess = new DataTable();
DataSet dsAccess = new DataSet();
AuthorizationBDto objAuthorizationBDto;
AuthorizationDal objAuthorizationDal;
if (HttpContext.Current.Session[PageConstants.ssnUserAuthorization] != null)
{
objAuthorizationBDto = (AuthorizationBDto)HttpContext.Current.Session[PageConstants.ssnUserAuthorization];
int RoleId = objAuthorizationBDto.UserSelectedRoleId;
if (RoleId != 0)
{
objAuthorizationDal = new AuthorizationDal();
dsAccess = objAuthorizationDal.GetProgrameAccessByProgramName(RoleId, ProgramName);
dtAccess = dsAccess.Tables[0];
if (dtAccess.Rows.Count > 0)
{
if (dtAccess.Rows[0]["READ_ACCESS"] != null)
{
if (dtAccess.Rows[0]["READ_ACCESS"].ToString() != "True")
{
int ModuleId = int.Parse(dtAccess.Rows[0]["MODULE_ID"].ToString());
switch (ModuleId)
{
case 1: // Administration
HttpContext.Current.Response.Redirect("~/Views/Administration/AccessDenied.aspx");
break;
case 2: // Customers
HttpContext.Current.Response.Redirect("~/Views/Customers/AccessDenied.aspx");
break;
case 3: // Inquiry
HttpContext.Current.Response.Redirect("~/Views/Inquiry/AccessDenied.aspx");
break;
case 4: // Orders
HttpContext.Current.Response.Redirect("~/Views/Orders/AccessDenied.aspx");
break;
case 5: // Fares
HttpContext.Current.Response.Redirect("~/Views/Fares/AccessDenied.aspx");
break;
case 6: // HR
HttpContext.Current.Response.Redirect("~/Views/HR/AccessDenied.aspx");
break;
default:
break;
}
}
}
else
{
HttpContext.Current.Response.Redirect("~/Default.aspx");
}
objAuthorizationBDto = new AuthorizationBDto();
objAuthorizationBDto = (AuthorizationBDto)HttpContext.Current.Session[PageConstants.ssnUserAuthorization];
if (dtAccess.Rows[0]["READ_ACCESS"] != null)
objAuthorizationBDto.ProgramReadAccess = bool.Parse(dtAccess.Rows[0]["READ_ACCESS"].ToString());
if (dtAccess.Rows[0]["WRITE_ACCESS"] != null)
objAuthorizationBDto.ProgramWriteAccess = bool.Parse(dtAccess.Rows[0]["WRITE_ACCESS"].ToString());
if (dtAccess.Rows[0]["DELETE_ACCESS"] != null)
objAuthorizationBDto.ProgramDeleteAccess = bool.Parse(dtAccess.Rows[0]["DELETE_ACCESS"].ToString());
if (dtAccess.Rows[0]["PRINT_ACCESS"] != null)
objAuthorizationBDto.ProgramPrintAccess = bool.Parse(dtAccess.Rows[0]["PRINT_ACCESS"].ToString());
HttpContext.Current.Session[PageConstants.ssnUserAuthorization] = objAuthorizationBDto;
}
else
{
HttpContext.Current.Response.Redirect("~/Default.aspx");
}
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
_userID = objAuthorizationBDto.UserProfile.UserId;
// Create new data series and set it's visual attributes
Series series = new Series("Pie");
series.ChartType = SeriesChartType.Pie;
series.BorderWidth = 1;
series.ShadowOffset = 2;
//general setting
// set query according to from and to date
// set query according to from and to date
DataSet _Ds = objdeshboardentity.getfilter(_userID);
DataTable _DT = _Ds.Tables[0];
DataTable _DT1 = _Ds.Tables[1];
//GET FILTER DETAILS FROM HERE
string query = string.Empty;
StringBuilder _employee = new StringBuilder();
if (_DT.Rows[0]["EMP_ID"].ToString() == null || _DT.Rows[0]["EMP_ID"].ToString() == "0" || _DT.Rows[0]["EMP_ID"].ToString() == "")
{
foreach (DataRow dr in _DT1.Rows)
{
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
else
{
foreach (DataRow dr in _DT1.Rows)
{
if (dr["RESULT"].ToString() == _DT.Rows[0]["EMP_ID"].ToString())
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
switch (_DT.Rows[0]["FILTER_ID"].ToString())
{
case "12":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),IMH.INQUIRY_DATE, 101)=CONVERT(VARCHAR(10),GETDATE(), 101) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "13":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),IMH.INQUIRY_DATE, 101)=CONVERT(VARCHAR(10),GETDATE()-1, 101) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "14":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) >= CONVERT(VARCHAR(10),GETDATE(), 101) AND CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) <= CONVERT(VARCHAR(10),GETDATE()+7, 101)) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "15":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) >= CONVERT(DATE,GETDATE()) AND CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) <=CONVERT(VARCHAR(10),GETDATE()-7, 101)) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "16":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) >= CONVERT(DATE,GETDATE()) AND CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) <= CONVERT(VARCHAR(10),GETDATE()+14, 101)) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "17":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) >= CONVERT(DATE,GETDATE()) AND CONVERT(VARCHAR(10),imh.INQUIRY_DATE, 101) <= CONVERT(VARCHAR(10),GETDATE()-14, 101)) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "18":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where datepart(MONTH,imh.INQUIRY_DATE)= '" + System.DateTime.Now.AddMonths(1).Month + "' AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "19":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where datepart(MONTH,imh.INQUIRY_DATE)= '" + System.DateTime.Now.AddMonths(-1).Month + "' AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "20":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where datepart(MONTH,imh.INQUIRY_DATE)= '" + System.DateTime.Now.Month + "' AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
case "21":
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),IMH.INQUIRY_DATE, 101)=CONVERT(DATE,GETDATE()+1) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
default:
query = "select COUNT(*) TOTAL,(case IS_REVISED when 1 then 'Revised' else 'New' END) as IS_REVISED from dbo.INQ_INQUIRY_SUB_HEAD iish join INQ_INQUIRY_MAIN_HEAD IMH ON IISH.INQUIRY_ID=IMH.INQUIRY_ID where CONVERT(VARCHAR(10),IMH.INQUIRY_DATE, 101) >=CONVERT(VARCHAR(10),'" + _DT.Rows[0]["FROM_DATE"].ToString() + "', 101) and CONVERT(VARCHAR(10),IMH.INQUIRY_DATE, 101) <=CONVERT(VARCHAR(10),'" + _DT.Rows[0]["TO_DATE"].ToString() + "', 101) AND IMH.SALES_PERSON_ID IN (" + _employee.ToString() + ") group by IS_REVISED ORDER BY TOTAL DESC";
break;
}
//END QUERY
// Add series into the chart's series collection
try
{
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
Chart1.Series.Add(series);
series.XValueMember = "IS_REVISED";
series.YValueMembers = "TOTAL";
series.IsValueShownAsLabel = true;
Chart1.ChartAreas[0].AxisY.Maximum = int.Parse(dt.Rows[0]["TOTAL"].ToString());
Chart1.DataSource = dt;
Chart1.DataBind();
}
catch (Exception ex) { }
//general setting over
}
/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="roleId"></param>
/// <param name="progId"></param>
public void ShowPageAccess()
{
try
{
//bool readAccess = false;
//bool writeAccess = false;
//bool deleteAccess = false;
//bool printAccess = false;
//DataSet dsAccess = null;
//AuthorizationDal objAuthorizationDal = new AuthorizationDal();
//dsAccess = objAuthorizationDal.GetPageOperationAccess(userId, roleId, progId);
//if (dsAccess != null && dsAccess.Tables.Count > 0)
//{
// if (dsAccess.Tables[0] != null && dsAccess.Tables[0].Rows.Count > 0)
// {
// readAccess = Convert.ToBoolean(dsAccess.Tables[0].Rows[0]["READ_ACCESS"].ToString());
// writeAccess = Convert.ToBoolean(dsAccess.Tables[0].Rows[0]["WRITE_ACCESS"].ToString());
// deleteAccess = Convert.ToBoolean(dsAccess.Tables[0].Rows[0]["DELETE_ACCESS"].ToString());
// printAccess = Convert.ToBoolean(dsAccess.Tables[0].Rows[0]["PRINT_ACCESS"].ToString());
// }
//}
//btnSearch.Enabled = readAccess;
//btnNew.Enabled = writeAccess;
//btnEdit.Enabled = writeAccess;
//btnDelete.Enabled = deleteAccess;
//btnExport.Enabled = printAccess;
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
if (!objAuthorizationBDto.ProgramWriteAccess)
{
btnNew.Enabled = false;
btnSave.Enabled = false;
btnSaveNew.Enabled = false;
}
if (!objAuthorizationBDto.ProgramDeleteAccess)
btnDelete.Enabled = false;
if (!objAuthorizationBDto.ProgramPrintAccess)
btnExport.Enabled = false;
}
}
catch (Exception) { }
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
_userID = objAuthorizationBDto.UserProfile.UserId;
Series series = new Series("Spline");
series.ChartType = SeriesChartType.Column;
series.BorderWidth = 3;
series.ShadowOffset = 2;
//general setting
// set query according to from and to date
// set query according to from and to date
DataSet _Ds = objdeshboardentity.getfilter(_userID);
DataTable _DT = _Ds.Tables[0];
DataTable _DT1 = _Ds.Tables[1];
//GET FILTER DETAILS FROM HERE
string query = string.Empty;
StringBuilder _employee = new StringBuilder();
if (_DT.Rows[0]["EMP_ID"].ToString() == null || _DT.Rows[0]["EMP_ID"].ToString() == "0" || _DT.Rows[0]["EMP_ID"].ToString() == "")
{
foreach (DataRow dr in _DT1.Rows)
{
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
else
{
foreach (DataRow dr in _DT1.Rows)
{
if (dr["RESULT"].ToString() == _DT.Rows[0]["EMP_ID"].ToString())
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
switch (_DT.Rows[0]["FILTER_ID"].ToString())
{
case "12":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,CONVERT(VARCHAR(10),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE CONVERT(VARCHAR(15),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) =CONVERT(VARCHAR(15),GETDATE(), 103) AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE";
break;
case "13":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,CONVERT(VARCHAR(10),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE CONVERT(VARCHAR(15),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) =CONVERT(VARCHAR(15),GETDATE()-1, 103) AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE";
break;
case "14":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,CONVERT(VARCHAR(10),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,101) >= CONVERT(VARCHAR(5),getdate(), 101) AND CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE, 101) <= CONVERT(VARCHAR(5),GETDATE()+7, 101) AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE";
break;
case "15":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,CONVERT(VARCHAR(10),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,101) <= CONVERT(VARCHAR(5),getdate(), 101) AND CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE, 101) >= CONVERT(VARCHAR(5),GETDATE()-7, 101) AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE";
break;
case "16":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,CONVERT(VARCHAR(10),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,101) >= CONVERT(VARCHAR(5),getdate(), 101) AND CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE, 101) <= CONVERT(VARCHAR(5),GETDATE()+14, 101) AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE";
break;
case "17":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,CONVERT(VARCHAR(10),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,101) <= CONVERT(VARCHAR(5),getdate(), 101) AND CONVERT(VARCHAR(5),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE, 101) >= CONVERT(VARCHAR(5),GETDATE()-14, 101) AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE";
break;
case "18":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,datename(month,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE ) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE datepart(MONTH,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE)= '" + System.DateTime.Now.AddMonths(1).Month + "' AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY datename(month,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE ) ORDER BY EXPENSE_DATE";
break;
case "19":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,datename(month,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE ) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE datepart(MONTH,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE)= '" + System.DateTime.Now.AddMonths(-1).Month + "' AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY datename(month,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE ) ORDER BY EXPENSE_DATE";
break;
case "20":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,datename(month,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE ) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE datepart(MONTH,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE)= '" + System.DateTime.Now.Month + "' AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY datename(month,SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE ) ORDER BY EXPENSE_DATE ";
break;
case "21":
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT,CONVERT(VARCHAR(10),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS WHERE CONVERT(VARCHAR(15),SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE,103) =CONVERT(VARCHAR(15),GETDATE()+1, 103) AND SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT <>0 GROUP BY SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE";
break;
default:
query = "SELECT SUM (SALES_RECEIPT_VOUCHER_DETAILS.DR_AMOUNT) AS TOTAL_EXPENCE_AMOUNT , CONVERT (VARCHAR(15), YEAR ( SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE)) AS EXPENSE_DATE FROM SALES_RECEIPT_VOUCHER_DETAILS GROUP BY CONVERT (VARCHAR(15), YEAR ( SALES_RECEIPT_VOUCHER_DETAILS.POSTED_DATE)) ORDER BY EXPENSE_DATE";
break;
}
//END QUERY
//END QUERY
DataTable _dttemp = new DataTable();
DataTable dt = new DataTable();
try
{
dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
_dttemp.Columns.Add("CUSTOMER_TYPE", typeof(string));
_dttemp.Columns.Add("TOTAL", typeof(int));
_dttemp.Rows.Add(_dttemp.NewRow());
_dttemp.Rows.Add(_dttemp.NewRow());
_dttemp.Rows[0]["TOTAL"] = 0;
_dttemp.Rows[1]["TOTAL"] = 0;
// Add series into the chart's series collection
foreach (DataRow dr in _dttemp.Rows)
{
try
{
if (dr["TOTAL"].ToString() == "1")
{
_dttemp.Rows[0]["CUSTOMER_TYPE"] = "New";
_dttemp.Rows[0]["TOTAL"] = int.Parse(_dttemp.Rows[0]["TOTAL"].ToString()) + int.Parse(dr["TOTAL"].ToString());
}
else
{
_dttemp.Rows[1]["CUSTOMER_TYPE"] = "Old";
_dttemp.Rows[1]["TOTAL"] = int.Parse(_dttemp.Rows[0]["TOTAL"].ToString()) + int.Parse(dr["TOTAL"].ToString());
}
}
catch (Exception ex)
{
throw ex;
}
}
}
catch (Exception ex) { throw ex; }
try
{
DataTable dt1 = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
//SqlConnection con = new SqlConnection(str);
//con.Open();
//SqlCommand cmd = new SqlCommand("GEDJET_EXPENCE_COMPANRASION", con);
//cmd.CommandType = CommandType.StoredProcedure;
//SqlDataReader rdr = cmd.ExecuteReader();
//DataTable dt1 = new DataTable();
//dt.Load(rdr);
Chart1.Series.Add(series);
series.XValueMember = "EXPENSE_DATE";
series.YValueMembers = "TOTAL_EXPENCE_AMOUNT";
series.IsValueShownAsLabel = true;
// Chart1.ChartAreas[0].AxisY.Maximum = int.Parse(dt.Rows[0]["TOTAL_RECEIPT_AMOUNT"].ToString());
Chart1.DataSource = dt1;
Chart1.DataBind();
}
catch
{
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
_userID = objAuthorizationBDto.UserProfile.UserId;
// Create new data series and set it's visual attributes
Series series = new Series("FastLine");
series.ChartType = SeriesChartType.Line;
//general setting
// set query according to from and to date
// set query according to from and to date
DataSet _Ds = objdeshboardentity.getfilter(_userID);
DataTable _DT = _Ds.Tables[0];
DataTable _DT1 = _Ds.Tables[1];
//GET FILTER DETAILS FROM HERE
string query = string.Empty;
StringBuilder _employee = new StringBuilder();
if (_DT.Rows[0]["EMP_ID"].ToString() == null || _DT.Rows[0]["EMP_ID"].ToString() == "0" || _DT.Rows[0]["EMP_ID"].ToString() == "")
{
foreach (DataRow dr in _DT1.Rows)
{
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
else
{
foreach (DataRow dr in _DT1.Rows)
{
if (dr["RESULT"].ToString() == _DT.Rows[0]["EMP_ID"].ToString())
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
switch (_DT.Rows[0]["FILTER_ID"].ToString())
{
case "12":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH=CONVERT(varchar(6),CAST(GETDATE() AS DATETIME),112) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "13":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH=CONVERT(varchar(6),CAST(GETDATE()-1 AS DATETIME),112) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "14":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH >= CONVERT(varchar(6),CAST(GETDATE() AS DATETIME),112) AND PLAN_YEAR_MONTH <= CONVERT(varchar(6),GETDATE()+7 AS DATETIME),112)) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "15":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH >= CONVERT(varchar(6),CAST(GETDATE() AS DATETIME),112) AND PLAN_YEAR_MONTH <=CONVERT(varchar(6),GETDATE()-7 AS DATETIME),112)) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "16":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH >= CONVERT(varchar(6),CAST(GETDATE() AS DATETIME),112) AND PLAN_YEAR_MONTH <= CONVERT(varchar(6),GETDATE()+14 AS DATETIME),112)) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "17":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH >= CONVERT(varchar(6),CAST(GETDATE() AS DATETIME),112) AND PLAN_YEAR_MONTH <= CONVERT(varchar(6),GETDATE()+14 AS DATETIME),112)) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "18":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH= '" + System.DateTime.Now.Year + System.DateTime.Now.AddMonths(1).Month + "' AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "19":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH= '" + System.DateTime.Now.Year + System.DateTime.Now.AddMonths(-1).Month + "' AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "20":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH= '" + System.DateTime.Now.Year + System.DateTime.Now.Month + "' AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
case "21":
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH=CONVERT(varchar(6),CAST(GETDATE()+1 AS DATETIME),112) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
default:
query = "select COUNT(*) TOTAL,PLAN_YEAR_MONTH as DATE from dbo.CUST_NEXT_TRAVEL_PLAN where PLAN_YEAR_MONTH >=CONVERT(varchar(6),CAST('" + _DT.Rows[0]["FROM_DATE"].ToString() + "' AS DATETIME),112) and PLAN_YEAR_MONTH <=CONVERT(varchar(6),CAST('" + _DT.Rows[0]["TO_DATE"].ToString() + "' AS DATETIME),112) AND CREATED_BY IN (" + _employee.ToString() + ") group by PLAN_YEAR_MONTH ORDER BY TOTAL DESC";
break;
}
//END QUERY
// Add series into the chart's series collection
Chart1.Series.Add(series);
try
{
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
series.XValueMember = "DATE";
series.YValueMembers = "TOTAL";
series.IsValueShownAsLabel = true;
Chart1.ChartAreas[0].AxisY.Maximum = int.Parse(dt.Rows[0]["TOTAL"].ToString());
Chart1.DataSource = dt;
Chart1.DataBind();
}
catch (Exception ex) { }
//general setting over
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
{
_userID = objAuthorizationBDto.UserProfile.UserId;
_empID = Convert.ToInt32(Session["empid"]);
}
DataSet _Ds = objdeshboardentity.getfilter(_userID);
DataTable _DT = _Ds.Tables[0];
DataTable _DT1 = _Ds.Tables[1];
string query = string.Empty;
switch (_DT.Rows[0]["FILTER_ID"].ToString())
{
case "12":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,103) = CONVERT(VARCHAR(15),getdate(), 103) AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "13":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,103) = CONVERT(VARCHAR(15),getdate()-1, 103) AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "14":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) >= CONVERT(VARCHAR(15),getdate(), 101) AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) <= CONVERT(VARCHAR(15),getdate()+7, 101) AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "15":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) <= CONVERT(VARCHAR(15),getdate(), 101) AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) >= CONVERT(VARCHAR(15),getdate()-7, 101) AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "16":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) >= CONVERT(VARCHAR(15),getdate(), 101) AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) <= CONVERT(VARCHAR(15),getdate()+14, 101) AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "17":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) <= CONVERT(VARCHAR(15),getdate(), 101) AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,101) >= CONVERT(VARCHAR(15),getdate()-14, 101) AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "18":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND datepart(MONTH, HOTEL_CART_DETAIL.CREATED_DATE) ='" + System.DateTime.Now.AddMonths(1).Month + "' AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "19":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND datepart(MONTH, HOTEL_CART_DETAIL.CREATED_DATE) ='" + System.DateTime.Now.AddMonths(-1).Month + "' AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "20":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND datepart(MONTH, HOTEL_CART_DETAIL.CREATED_DATE) ='" + System.DateTime.Now.Month + "' AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
case "21":
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND CONVERT(VARCHAR(15), HOTEL_CART_DETAIL.CREATED_DATE,103) = CONVERT(VARCHAR(15),getdate()+1, 103) AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' GROUP BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
default:
query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL AND HOTEL_CART_DETAIL.CREATED_BY = '" + _userID + "' AND HOTEL_CART_DETAIL.PACKAGE_FLAG='True' ORDER BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
break;
}
// String query = "SELECT DISTINCT TOP 5 dbo.SUPPLIER_CONTACT_DETAILS.CHAIN_NAME FROM dbo.HOTEL_CART_DETAIL LEFT OUTER JOIN dbo.SUPPLIER_HOTEL_PRICE_LIST ON dbo.HOTEL_CART_DETAIL.SUPPLIER_HOTEL_PRICE_LIST_ID = dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_HOTEL_PRICE_LIST_ID LEFT OUTER JOIN dbo.SUPPLIER_CONTACT_DETAILS ON dbo.SUPPLIER_HOTEL_PRICE_LIST.SUPPLIER_SR_NO = dbo.SUPPLIER_CONTACT_DETAILS.SUPPLIER_SR_NO WHERE SUPPLIER_CONTACT_DETAILS.CHAIN_NAME IS NOT NULL ORDER BY SUPPLIER_CONTACT_DETAILS.CHAIN_NAME";
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + dr["CHAIN_NAME"].ToString());
}
_sbi.AppendLine("</ul>");
// _sbi.AppendLine("<a href=\"../../Views/Sales/Tour.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
WebHelper.WebManager.CheckSessionIsActive();
objAuthorizationBDto = (AuthorizationBDto)Session[PageConstants.ssnUserAuthorization];
if (objAuthorizationBDto != null)
_userID = objAuthorizationBDto.UserProfile.UserId;
// Create new data series and set it's visual attributes
//Series series = new Series("Spline");
//series.ChartType = SeriesChartType.Column;
//series.BorderWidth = 3;
//series.ShadowOffset = 2;
//general setting
// set query according to from and to date
DataSet _Ds = objdeshboardentity.getfilter(_userID);
DataTable _DT = _Ds.Tables[0];
DataTable _DT1 = _Ds.Tables[1];
//GET FILTER DETAILS FROM HERE
string query = string.Empty;
StringBuilder _employee = new StringBuilder();
if (_DT.Rows[0]["EMP_ID"].ToString() == null || _DT.Rows[0]["EMP_ID"].ToString() == "0" || _DT.Rows[0]["EMP_ID"].ToString() == "")
{
foreach (DataRow dr in _DT1.Rows)
{
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
else
{
foreach (DataRow dr in _DT1.Rows)
{
if (dr["RESULT"].ToString() == _DT.Rows[0]["EMP_ID"].ToString())
_employee.Append(dr["EMP_ID"].ToString() + ",");
}
_employee.Append("0");
}
switch (_DT.Rows[0]["FILTER_ID"].ToString())
{
case "12":
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) = CONVERT(VARCHAR(5),getdate(), 101)";
break;
case "13":
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) = CONVERT(VARCHAR(5),dateadd(DAY,-1,getdate()), 101) ";
break;
case "14":
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) >= CONVERT(VARCHAR(5),getdate()+ 7, 101)";
break;
case "15":
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) <= CONVERT(VARCHAR(5),getdate()-7, 101)";
break;
case "16":
query= "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) >= CONVERT(VARCHAR(5),getdate()+14, 101)";
break;
case "17":
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) <= CONVERT(VARCHAR(5),getdate()-14, 101)";
break;
case "18":
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) >= CONVERT(VARCHAR(5),DATEADD(MONTH,+1,GETDATE()),101)";
break;
case "19":
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) <= CONVERT(VARCHAR(5),DATEADD(MONTH,-1,GETDATE()),101)";
break;
case "20":
//query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where datepart(month,PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE) = datepart(month,getdate())"; /*Running */
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),MONTH(PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE), 101) = CONVERT(VARCHAR(5),MONTH(getdate()), 101)";
break;
case "21":
query = "SELECT SUM(CR_AMOUNT) AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) = CONVERT(VARCHAR(5),GETDATE()+1, 101) GROUP BY GL_CODE";
break;
default:
query = "SELECT CR_AMOUNT AS TOTAL_PAYMENT_MADE,GL_CODE FROM PURCHASE_PAYMENT_VOUCHER_DETAILS where CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) >=CONVERT(VARCHAR(5),'" + _DT.Rows[0]["FROM_DATE"].ToString() + "', 101) and CONVERT(VARCHAR(5),PURCHASE_PAYMENT_VOUCHER_DETAILS.POSTED_DATE, 101) <=CONVERT(VARCHAR(5),'" + _DT.Rows[0]["TO_DATE"].ToString() + "', 101)";
break;
}
try
{
DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
StringBuilder _sbi = new StringBuilder();
_sbi.AppendLine("<ul>");
foreach (DataRow dr in dt.Rows)
{
_sbi.AppendLine("<li style=\"list-style-type:square;font-size:12px;padding:3px;\">" + dr["GL_CODE"].ToString() + " " + dr["TOTAL_PAYMENT_MADE"].ToString() + " " + "THB");
}
_sbi.AppendLine("</ul>");
_sbi.AppendLine("<a href=\"../../Views/Account/Payment.aspx\">View All</a>");
divanc.InnerHtml = _sbi.ToString();
}
catch (Exception ex)
{ }
//END QUERY
// Add series into the chart's series collection
//Chart1.Series.Add(series);
//try
//{
// DataTable dt = objdeshboardentity.ExecuteQuery(query.ToString().Trim()).Tables[0];
// Chart1.Series.Add(series);
// series.XValueMember = "DATE";
// series.YValueMembers = "TOTAL";
// series.IsValueShownAsLabel = true;
// Chart1.ChartAreas[0].AxisY.Maximum = int.Parse(dt.Rows[0]["TOTAL"].ToString());
// Chart1.DataSource = dt;
// Chart1.DataBind();
//}
//catch (Exception ex) { }
//general setting over
}
