protected void Page_Load(object sender, EventArgs e)
{
//string SearchText = string.Empty;
if (!string.IsNullOrEmpty(Request.QueryString["IsNewSearch"]))
{
IsNewSearch.Value = Request.QueryString["IsNewSearch"].ToString();
}
divError.Visible = false;
divResult.Visible = false;
int departmentId = 0;
List <Department> departmentList = IDepartmentService.GetData(0, 0, false);
DepartmentId.DataSource = departmentList;
DepartmentId.DataTextField = "Name";
DepartmentId.DataValueField = "Id";
DepartmentId.DataBind();
DepartmentId.Items.Insert(0, new ListItem()
{
Text = "Select Department", Value = ""
});
DocType.Items.Insert(0, new ListItem()
{
Text = "Select Doc Type", Value = ""
});
if (!string.IsNullOrEmpty(Request.QueryString["DepartmentId"]) && int.TryParse(Request.QueryString["DepartmentId"], out int n))
{
DepartmentId.SelectedValue = Request.QueryString["DepartmentId"];
departmentId = Convert.ToInt32(Request.QueryString["DepartmentId"]);
List <DocTypeModel> docTypes = IDepartmentService.GetDocTypesByDepartmentId(departmentId);
DocType.DataSource = docTypes;
DocType.DataTextField = "DocType";
DocType.DataValueField = "DocType";
DocType.DataBind();
if (!string.IsNullOrEmpty(Request.QueryString["DocType"]))
{
DocType.SelectedValue = Request.QueryString["DocType"];
}
}
else
{
}
//if (!string.IsNullOrEmpty(Request.QueryString["DocType"]))
// DocType.SelectedValue = Request.QueryString["DocType"];
if (departmentId != 0 || !string.IsNullOrEmpty(Request.QueryString["DocType"]) || !string.IsNullOrEmpty(Request.QueryString["Search"]))
{
if (!string.IsNullOrEmpty(Request.QueryString["Search"]))
{
Search.Value = Request.QueryString["Search"];
}
if (!string.IsNullOrEmpty(Request.QueryString["hdnNumberPerPage"]))
{
hdnNumberPerPage.Value = Request.QueryString["hdnNumberPerPage"].ToString();
}
if (!string.IsNullOrEmpty(Request.QueryString["hdnCurrentPageNo"]))
{
hdnCurrentPageNo.Value = Request.QueryString["hdnCurrentPageNo"].ToString();
}
if (!string.IsNullOrEmpty(Request.QueryString["hdnTotalRecordsCount"]))
{
hdnTotalRecordsCount.Value = Request.QueryString["hdnTotalRecordsCount"].ToString();
}
int skip = 0, take = 10;
if (IsNewSearch.Value != "0")
{
skip = 0;
take = 10;
hdnNumberPerPage.Value = "10";
hdnCurrentPageNo.Value = "1";
hdnTotalRecordsCount.Value = ISetService.GetSetsForMfilesAccountCount(departmentId, Request.QueryString["DocType"], Request.QueryString["Search"]).ToString();
}
else
{
skip = (Convert.ToInt32(hdnCurrentPageNo.Value) - 1) * 10;
take = 10;
}
List <DocTypeSetModel> list = new List <DocTypeSetModel>();
if (departmentId != 0 || !string.IsNullOrEmpty(Request.QueryString["DocType"]) || !string.IsNullOrEmpty(Request.QueryString["Search"]))
{
list = ISetService.GetSetsForMfilesAccount(departmentId, Request.QueryString["DocType"], Request.QueryString["Search"], skip, take);
}
StringBuilder asb = new StringBuilder();
int index = 1;
foreach (DocTypeSetModel set in list)
{
Branch branch = IBranchService.GetSingle(set.BranchId);
Department department = departmentList.FirstOrDefault(a => a.Id == set.DepartmentId);
string departmentCode = department.Code;
string deptCode = departmentCode.Split('-')[0];
string jobCode = departmentCode.Split('-')[1];
string columnData = "";
if (departmentCode == "E-LIBRARY")
{
//AA NUMBER
//ACCOUNT NUMBER
columnData = "AA No: " + set.AANO;
columnData += "<br/>Account No: " + set.AccountNo;
}
else if (deptCode == "ETP")
{
if (jobCode == "LN")
{
columnData = "AA No: " + set.AANO;
columnData += "<br/>Account No: " + set.AccountNo;
}
else if (jobCode == "LL")
{
columnData = "AA No: " + set.AANO;
}
else if (jobCode == "PR")
{
columnData = "Project Code: " + set.AANO;
}
else if (jobCode == "WF")
{
columnData = "Welfare Code: " + set.AANO;
}
}
else if (deptCode == "LOS")
{
columnData = "AA No: " + set.AANO;
}
asb.Append(@"<tr>
<td class=''>
" + index + @"
</td>
<td>" + branch.Code + @"</td>
<td>" + department.Code + @"</td>
<td class='text-center mb-5'>
" + set.BatchNo + @"
</td>
<td>
<div><strong>" + columnData + @"</strong><div>
</td>
<td><div style='min-width: 150px;'><a href='#' data-original-title='Click to view' data-trigger='hover' data-placement='bottom' class='popovers text-info'><strong>" + set.DocType + @"</strong></a> ( <small> pages: <strong>" + set.PageCount + @"</strong></small> )</div></td>
<td>" + MfileStatus(set.IsReleased) + @"</td>
<td><a data-original-title='Click to view' data-trigger='hover' data-placement='bottom' class='popovers text-info' href='SetView.aspx?setId=" + set.SetId + @"' target='_blank'><i class='fa fa-eye'></i></a></td>
<td>" + set.CreatedDate.ToString("dd/MM/yyyy HH:mm:ss") + @"</td>
</tr>");
// }
index++;
}
string result = @"<button data-dismiss='alert' class='close close-sm' type='button'>
<i class='fa fa-times'></i></button>
<strong>Done!</strong> Found the " + hdnTotalRecordsCount.Value + " records with .";
if (departmentId != 0)
{
result += DepartmentId.SelectedItem.Text + " Department &";
}
if (!string.IsNullOrEmpty(Request.QueryString["DocType"]))
{
result += Request.QueryString["DocType"] + " Doc Type &";
}
if (!string.IsNullOrEmpty(Request.QueryString["Search"]))
{
result += "this " + Request.QueryString["Search"] + " text.";
}
divResult.Visible = true;
divResult.InnerHtml = result;
setsTbody.InnerHtml = asb.ToString();
}
else
{
if (IsNewSearch.Value == "1")
{
divError.Visible = true;
}
divError.InnerHtml = @"<button data-dismiss='alert' class='close close-sm' type='button'>
<i class='fa fa-times'></i></button>
<strong>Oh snap!</strong> Please select at lest one select option.";
}
}