private void BindGridWithFilterContractor()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetContractorData objReq = new GetContractorData();
string WhereClause = ReturnWhereContractor();
if (!string.IsNullOrEmpty(txtID1.Text))
{
objReq.NRICno = txtID1.Text;
}
if (!string.IsNullOrEmpty(txtName1.Text))
{
objReq.NRICno = txtName1.Text;
}
if (!string.IsNullOrEmpty(WhereClause))
{
objReq.WhereClause = WhereClause;
}
GetContractorDataResponse ret = ws.GetContractorData1(objReq);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvContractorTable.PageSize = pageSize;
gvContractorTable.DataSource = ret.Contractor;
gvContractorTable.DataBind();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void BindGrid()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetContractorData _req = new GetContractorData();
// GetContractorDataResponse _resp = ws.GetContractorData(_req);
DataTable _resp = ws.GetContractorData(_req);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvItemTable.PageSize = pageSize;
// gvItemTable.DataSource = _resp.Contractor;
gvItemTable.DataSource = _resp;
if (_resp.Rows.Count == 0)
{
// contracter1.Visible = false;
// contractor2.Visible = false;
}
gvItemTable.DataBind();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void gvItem_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
if (e.NewPageIndex >= 0)
{
AdminBLL ws = new AdminBLL();
GetContractorData _req = new GetContractorData();
gvItemTable.PageIndex = e.NewPageIndex;
string WhereClause = ReturnWhere();
if (!string.IsNullOrEmpty(WhereClause))
{
_req.WhereClause = WhereClause;
}
// GetContractorDataResponse _resp = ws.GetContractorData(_req);
DataTable _resp = ws.GetContractorData(_req);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvItemTable.PageSize = pageSize;
gvItemTable.DataSource = _resp;
gvItemTable.DataBind();
}
}
//catch (System.Threading.ThreadAbortException)
//{
//}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
public DataTable GetCheckInData(GetContractorData objReq)
{
try
{
AdminDAL objAdminDAL = new AdminDAL();
GetContractorDataResponse ret = new GetContractorDataResponse();
DataTable lst = objAdminDAL.GetCheckInData(objReq);
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public GetContractorDataResponse GetContractorData2(GetContractorData objGetContractorDataRequest)
{
try
{
AdminDAL objAdminDAL = new AdminDAL();
GetContractorDataResponse ret = new GetContractorDataResponse();
List <Contractor> lst = objAdminDAL.GetContractorData2(objGetContractorDataRequest);
ret.Contractor = lst;
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetContractorData(GetContractorData objGetContractorDataRequest)
{
try
{
AdminDAL objAdminDAL = new AdminDAL();
GetContractorDataResponse ret = new GetContractorDataResponse();
DataTable lst = objAdminDAL.GetContractorData(objGetContractorDataRequest);
// ret.Contractor = lst;
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
private void PopulatePageCntrls(String argsBGID)
{
Int32 iCount = 0;
GetContractorDataResponse ret = null;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL objAdminBLL = new AdminBLL();
DateTime dt;
GetContractorData objGetBillingTableRequest = new GetContractorData();
objGetBillingTableRequest.checkout_id = argsBGID.ToString();
objGetBillingTableRequest.WhereClause = " where checkout_id=" + argsBGID.ToString();
ret = objAdminBLL.GetContractorData1(objGetBillingTableRequest);
hdnBTID.Value = ret.Contractor[iCount].checkout_id.ToString();
out_no.Text = ret.Contractor[iCount].checkout_id.ToString();
txtnric.Text = ret.Contractor[iCount].user_id.ToString();
txtname.Text = ret.Contractor[iCount].user_name.ToString();
txtPassNo.Text = ret.Contractor[iCount].user_address.ToString();
cmbContractorPass.Text = ret.Contractor[iCount].company_from.ToString();
txtKeyNo.Text = ret.Contractor[iCount].to_visit.ToString();
//role.Text = ret.Contractor[iCount].Role.ToString();
dt = Convert.ToDateTime(ret.Contractor[iCount].checkin_time);
calDateOfIncident.Text = Convert.ToString(dt);
dt = Convert.ToDateTime(ret.Contractor[iCount].checkout_time);
calDateOfIncident1.Text = Convert.ToString(dt);
string remark = ret.Contractor[iCount].remarks.ToString();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void BindGridWithFilter()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetContractorData objReq = new GetContractorData();
getLocationIDByName(ddllocation.Text.Trim());
string WhereClause = ReturnWhere();
if (!string.IsNullOrEmpty(ddllocation.SelectedValue.Trim()))
{
objReq.Location_id = ddllocation.SelectedValue.Trim();
}
if (!string.IsNullOrEmpty(txtnricno.Text))
{
objReq.NRICno = txtnricno.Text;
}
if (!string.IsNullOrEmpty(txtvehicleno.Text))
{
objReq.vehicle_no = txtvehicleno.Text;
}
if (!string.IsNullOrEmpty(txtkeyno.Text))
{
objReq.key_no = txtkeyno.Text;
}
if (!string.IsNullOrEmpty(txtpasstype.Text))
{
objReq.pass_no = txtpasstype.Text;
}
if (!string.IsNullOrEmpty(txtdatefrom.Text))
{
if (string.IsNullOrEmpty(txtdateto.Text))
{
objReq.checkin_time = txtdatefrom.Text;
}
}
if (!string.IsNullOrEmpty(txtdateto.Text))
{
if (!string.IsNullOrEmpty(txtdatefrom.Text))
{
objReq.checkin_time = txtdatefrom.Text;
objReq.checkin_time = txtdateto.Text;
}
}
if (!string.IsNullOrEmpty(WhereClause))
{
objReq.WhereClause = WhereClause;
}
// GetContractorDataResponse ret = ws.GetContractorData(objReq);
DataTable ret = ws.GetContractorData(objReq);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvItemTable.PageSize = pageSize;
// gvItemTable.DataSource = ret.Contractor;
gvItemTable.DataSource = ret;
if (ret.Rows.Count == 0)
{
// contracter1.Visible = false;
// contractor2.Visible = false;
}
gvItemTable.DataBind();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
