protected IEnumerable <PanCard> GetAllPanCardDetails()
{
var query = ConfigurationManager.AppSettings["qryGetAllPanCardDetails"];
if (CurrentUser.UserRole.Role.ToLower() != "admin")
{
query = SqlHandler.AddConditionToQuery(query, new List <string> {
"p.CreatedById=" + CurrentUser.Id + " OR clientId=" + CurrentUser.Id
});
}
return(PanCardRepository.GetAllPanCards(query, ConfigurationManager.AppSettings["rmapGetAllPanCardDetails"]));
}
protected IEnumerable <PanCard> GetPanCardDetailsBySearchTerms()
{
var query = ConfigurationManager.AppSettings["qryGetAllPanCardDetails"];
var conditions = new List <string> ();
if (chkApplicationNumber.Checked && txtApplicationNumber.Text.Trim() != "")
{
conditions.Add("ApplicationNumber='" + txtApplicationNumber.Text + "'");
}
if (chkName.Checked && txtName.Text.Trim() != "")
{
conditions.Add("CustomerName like '%" + txtName.Text + "%'");
}
if (chkDateOfBirth.Checked && dtDateOfBirth.Text.Trim() != "")
{
var dateOfBirth = DateTime.ParseExact(dtDateOfBirth.Text.Trim(), "dd/mm/yyyy", CultureInfo.InvariantCulture);
conditions.Add("DateOfBirth=#" + dateOfBirth.ToString("yyyy/mm/dd") + "#");
}
if (chkFatherName.Checked && txtFatherName.Text.Trim() != "")
{
conditions.Add("FatherName like '%" + txtFatherName.Text + "%'");
}
if (chkPanEntryDate.Checked && dtPanEntryDate.Text.Trim() != "")
{
var panEntryDate = DateTime.ParseExact(dtPanEntryDate.Text.Trim(), "dd/mm/yyyy", CultureInfo.InvariantCulture);
conditions.Add("datevalue(PanEntryDate)=#" + panEntryDate.ToString("yyyy/mm/dd") + "#");
}
if (CurrentUser.UserRole.Role.ToLower() == "admin" && chkClient.Checked)
{
conditions.Add("p.ClientId=" + ddlClient.SelectedItem.Value);
}
if (CurrentUser.UserRole.Role.ToLower() != "admin")
{
conditions.Add("(p.CreatedById=" + CurrentUser.Id + "OR clientId=" + CurrentUser.Id + ")");
}
query = SqlHandler.AddConditionToQuery(query, conditions);
return(PanCardRepository.GetAllPanCards(query, ConfigurationManager.AppSettings["rmapGetAllPanCardDetails"]));
}