private void LoadCallHistoryGrid(ePageIndex ePageIndex)
{
DataTable dtCallHistory = GetCallHistoryDt(ePageIndex);
if (dtCallHistory.Rows.Count > 0)
{
lblCount.Text = dtCallHistory.Rows[0][CS.TotalRecord].ToString();
}
else
{
lblCount.Text = "0";
}
divPaging.Visible = (dtCallHistory.Rows.Count > 0);
txtGotoPageNo.Text = PageIndex.ToString();
ltrTotalContent.Text = CU.PageRecordString(lblCount.zToInt().Value, ddlRecordPerPage.zToInt().Value, lnkFirst, lnkPrev, txtGotoPageNo, lnkNext, lnkLast);
grdCallHistory.DataSource = dtCallHistory;
grdCallHistory.DataBind();
try { grdCallHistory.HeaderRow.TableSection = TableRowSection.TableHeader; }
catch { }
}
private DataTable GetPortalDt(ePageIndex ePageIndex)
{
int?status = null;
if (chkActive.Checked && !chkDeactive.Checked)
{
status = (int)eStatus.Active;
}
else if (!chkActive.Checked && chkDeactive.Checked)
{
status = (int)eStatus.Deactive;
}
var ObjQuery = new Query()
{
OrganizationId = lblOrganizationId.zToInt(),
MasterSearch = txtSearch.Text,
ePortal = ddlSearchPortal.zIsSelect() ? ddlSearchPortal.zToInt() : (int?)null,
eStatus = status,
eStatusNot = (int)eStatus.Delete
};
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref ObjQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
return(ObjQuery.Select(eSP.qry_Portal));
}
private DataTable GetOrganizationDt(ePageIndex ePageIndex)
{
int?Status = null;
if (chkActive.Checked && !chkDeactive.Checked)
{
Status = (int)eStatus.Active;
}
else if (!chkActive.Checked && chkDeactive.Checked)
{
Status = (int)eStatus.Deactive;
}
var objQuery = new Query()
{
MasterSearch = txtSearch.Text,
eStatus = Status,
eStatusNot = (int)eStatus.Delete,
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
return(objQuery.Select(eSP.qry_Organization));
}
private DataTable GetOrderPaymentDt(ePageIndex ePageIndex)
{
var objQuery = new Query()
{
OrganizationId = lblOrganizationId.zToInt(),
FirmId = ddlFirm.zToInt() > 0 ? ddlFirm.zToInt() : (int?)null,
UsersId = ddlUser.zToInt() > 0 ? ddlUser.zToInt() : (int?)null,
OrdersId = txtSearchOrderId.zToInt(),
FromDate = txtFromDate.zToDate().HasValue ? txtFromDate.zToDate() : (DateTime?)null,
ToDate = txtToDate.zToDate().HasValue ? txtToDate.zToDate().Value.AddDays(1).AddSeconds(-1) : (DateTime?)null,
MasterSearch = txtSearch.Text,
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
return(objQuery.Select(eSP.qry_OrderPayment));
}
private void LoadUserGrid(ePageIndex ePageIndex)
{
eDesignation Designation = CU.GeteDesignationId(CU.GetUsersId());
int? Status = null;
if (chkActive.Checked && !chkDeactive.Checked)
{
Status = (int)eStatus.Active;
}
else if (!chkActive.Checked && chkDeactive.Checked)
{
Status = (int)eStatus.Deactive;
}
var objQuery = new Query()
{
OrganizationId = ddlOrganization.zIsSelect() ? ddlOrganization.zToInt() : null,
FirmId = ddlFirm.zIsSelect() ? ddlFirm.zToInt() : (Designation == eDesignation.SystemAdmin ? (int?)null : lblFirmId.zToInt()),
MasterSearch = txtSearch.Text,
eStatus = Status,
eStatusNot = (int)eStatus.Delete,
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
DataTable dtUser = objQuery.Select(eSP.qry_User);
#region Count Total
lblCount.Text = dtUser.Rows.Count.ToString();
divPaging.Visible = (dtUser.Rows.Count > 0);
txtGotoPageNo.Text = PageIndex.ToString();
ltrTotalContent.Text = CU.PageRecordString(lblCount.zToInt().Value, ddlRecordPerPage.zToInt().Value, lnkFirst, lnkPrev, txtGotoPageNo, lnkNext, lnkLast);
#endregion
dtContact = new Query()
{
eParentType = (int)eParentType.User,
}.Select(eSP.qry_Contacts);
grdUser.DataSource = dtUser;
grdUser.DataBind();
try { grdUser.HeaderRow.TableSection = TableRowSection.TableHeader; }
catch { }
}
private void LoadCustomerGrid(ePageIndex ePageIndex)
{
int?Status = null;
if (chkActive.Checked && !chkDeactive.Checked)
{
Status = (int)eStatus.Active;
}
else if (!chkActive.Checked && chkDeactive.Checked)
{
Status = (int)eStatus.Deactive;
}
var objQuery = new Query()
{
MasterSearch = txtSearch.Text,
eStatus = Status,
eStatusNot = (int)eStatus.Delete,
UsersId = lblUsersId.zToInt(),
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
DataTable dtCustomer = objQuery.Select(eSP.qry_Customer);
#region Count Total
lblCount.Text = dtCustomer.Rows.Count.ToString();
divPaging.Visible = (dtCustomer.Rows.Count > 0);
txtGotoPageNo.Text = PageIndex.ToString();
ltrTotalContent.Text = CU.PageRecordString(lblCount.zToInt().Value, ddlRecordPerPage.zToInt().Value, lnkFirst, lnkPrev, txtGotoPageNo, lnkNext, lnkLast);
#endregion
grdCustomer.DataSource = dtCustomer;
grdCustomer.DataBind();
try { grdCustomer.HeaderRow.TableSection = TableRowSection.TableHeader; }
catch { }
}
private DataTable GetCallHistoryDt(ePageIndex ePageIndex)
{
int?Status = null;
if (chkActive.Checked && !chkDeactive.Checked)
{
Status = (int)eStatus.Active;
}
else if (!chkActive.Checked && chkDeactive.Checked)
{
Status = (int)eStatus.Deactive;
}
int?CallDirection = null;
if (chkSearchIncoming.Checked && !chkSearchOutgoing.Checked)
{
CallDirection = (int)eCallDirection.Incoming;
}
else if (!chkSearchIncoming.Checked && chkSearchOutgoing.Checked)
{
CallDirection = (int)eCallDirection.Outgoing;
}
var objQuery = new Query()
{
MasterSearch = txtSearch.Text,
FirmId = lblFirmId.zToInt(),
UsersId = ddlSearchUser.zIsSelect() ? ddlSearchUser.zToInt() : (int?)null,
CallTypeId = ddlSearchCallType.zIsSelect() ? ddlSearchCallType.zToInt() : (int?)null,
eCallDirection = CallDirection,
FromDate = txtFromDate.zToDate().HasValue ? txtFromDate.zToDate() : (DateTime?)null,
ToDate = txtToDate.zToDate().HasValue ? txtToDate.zToDate().Value.AddDays(1).AddSeconds(-1) : (DateTime?)null,
eStatus = Status,
eStatusNot = (int)eStatus.Delete,
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
return(objQuery.Select(eSP.qry_CallHistory));
}
private DataTable GetDesignationDt(ePageIndex ePageIndex)
{
int?Status = null;
if (chkActive.Checked && !chkDeactive.Checked)
{
Status = (int)eStatus.Active;
}
else if (!chkActive.Checked && chkDeactive.Checked)
{
Status = (int)eStatus.Deactive;
}
var lstDesignationId = CU.GetlstAuthoDesignation();
if (lstDesignationId.Count == 0)
{
lstDesignationId.Add(0);
}
var objQuery = new Query()
{
MasterSearch = txtSearch.Text,
eStatus = Status,
eStatusNot = (int)eStatus.Delete,
OrganizationId = lblOrganizationId.zToInt(),
eDesignationIn = CU.GetParaIn(lstDesignationId, false),
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
return(objQuery.Select(eSP.qry_Designation));
}
private DataTable GetCartDt(ePageIndex ePageIndex)
{
var objQuery = new Query()
{
MasterSearch = txtSearch.Text,
OrganizationId = CU.GetOrganizationId(),
eStatusNot = (int)eStatus.Delete,
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
return(objQuery.Select(eSP.qry_Cart));
}
private DataTable GetItemAdjustmentDt(ePageIndex ePageIndex)
{
var objQuery = new Query()
{
MasterSearch = txtSearch.Text,
OrganizationId = lblOrganizationId.zToInt(),
FromDate = txtFromDate.zToDate().HasValue ? txtFromDate.zToDate() : (DateTime?)null,
ToDate = txtToDate.zToDate().HasValue ? txtToDate.zToDate().Value.AddDays(1).AddSeconds(-1) : (DateTime?)null,
eStatusNot = (int)eStatus.Delete,
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
return(objQuery.Select(eSP.qry_ItemAdjustment));
}
private DataTable GetServiceDt(ePageIndex ePageIndex)
{
int?Status = null;
if (chkActive.Checked && !chkDeactive.Checked)
{
Status = (int)eStatus.Active;
}
else if (!chkActive.Checked && chkDeactive.Checked)
{
Status = (int)eStatus.Deactive;
}
var objQuery = new Query()
{
CourierId = ddlSearchCourier.zToInt(),
CountryId = ddlSearchCountry.zToInt() != 0 ? ddlSearchCountry.zToInt() : (int?)null,
StateId = ddlSearchState.zToInt() != 0 ? ddlSearchState.zToInt() : (int?)null,
CityId = ddlSearchCity.zToInt() != 0 ? ddlSearchCity.zToInt() : (int?)null,
MasterSearch = txtSearch.Text,
eStatus = Status,
eStatusNot = (int)eStatus.Delete,
};
#region Page Index
int RecordPerPage = ddlRecordPerPage.zToInt().Value;
int PageIndexTemp = PageIndex;
CU.GetPageIndex(ePageIndex, RecordPerPage, ref PageIndexTemp, ref objQuery, ref txtGotoPageNo, ref lblCount);
PageIndex = PageIndexTemp;
#endregion Page Index
return(objQuery.Select(eSP.qry_ServiceAvailability));
}