private void PopulatePageCntrls(int argsBGID)
{
Int32 iCount = 0;
GetSOPDataResponse ret = null;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL objAdminBLL = new AdminBLL();
GetSOPData objGetBillingTableRequest = new GetSOPData();
objGetBillingTableRequest.SOP_ID = argsBGID.ToString();
objGetBillingTableRequest.WhereClause = " where SOP_ID =" + argsBGID.ToString();
ret = objAdminBLL.GetSOPData(objGetBillingTableRequest);
hdnBTID.Value = ret.SOPNo[iCount].SOP_ID.ToString();
hdnBTID.Value = ret.SOPNo[iCount].SOP_Title.ToString();
hdnBTID.Value = ret.SOPNo[iCount].SOP_Subject.ToString();
hdnBTID.Value = ret.SOPNo[iCount].ImagePathName.ToString();
hdnBTID.Value = ret.SOPNo[iCount].Location.ToString();
txtUpdateSOPNo.Text = ret.SOPNo[iCount].SOP_ID.ToString();
txtUpdateSOPTitle.Text = ret.SOPNo[iCount].SOP_Title.ToString();
txtUpdateSOPSubject.Text = ret.SOPNo[iCount].SOP_Subject.ToString();
//ddllocation.Items.Insert(0,ret.SOPNo[iCount].Location.ToString());
Session.Add("ImagePath", ret.SOPNo[iCount].ImagePathName.ToString());
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void BindGridWithFilter()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
getLocationIDByName(ddllocation.Text.Trim());
AdminBLL ws = new AdminBLL();
GetSOPData objReq = new GetSOPData();
if (ddllocation.Text.ToString() == "")
{
}
else
{
objReq.WhereClause = " Where Location = '" + searchid.Text + "' ";
}
GetSOPDataResponse ret = ws.GetSOPData(objReq);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvSOPTable.PageSize = pageSize;
gvSOPTable.DataSource = ret.SOPNo;
gvSOPTable.DataBind();
// ShowHide();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void BindGridWithFilter()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetSOPData objReq = new GetSOPData();
string WhereClause = ReturnWhere();
if (!string.IsNullOrEmpty(txtSOPID.Text))
{
objReq.SOP_ID = txtSOPID.Text;
}
if (!string.IsNullOrEmpty(txtSOPSubjectSearch.Text))
{
objReq.SOP_Subject = txtSOPSubjectSearch.Text;
}
if (!string.IsNullOrEmpty(txtSOPtitle.Text))
{
objReq.SOP_Title = txtSOPtitle.Text;
}
if (!string.IsNullOrEmpty(WhereClause))
{
objReq.WhereClause = WhereClause;
}
if (!string.IsNullOrEmpty(txtdatefrom.Text))
{
if (string.IsNullOrEmpty(txtdateto.Text))
{
objReq.Date_From = txtdatefrom.Text;
}
}
if (!string.IsNullOrEmpty(txtdateto.Text))
{
if (!string.IsNullOrEmpty(txtdatefrom.Text))
{
objReq.Date_From = txtdatefrom.Text;
objReq.Date_From = txtdateto.Text;
}
}
GetSOPDataResponse ret = ws.GetSOPData(objReq);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvSOPTable.PageSize = pageSize;
gvSOPTable.DataSource = ret.SOPNo;
gvSOPTable.DataBind();
ShowHide();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
public GetSOPDataResponse GetAllSOPData(GetSOPData objGetSOPDataRequest)
{
try
{
AdminDAL objAdminDAL = new AdminDAL();
GetSOPDataResponse ret = new GetSOPDataResponse();
List <SOP> lst = objAdminDAL.GetAllSOPData(objGetSOPDataRequest);
ret.SOPNo = lst;
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
private void PopulatePageCntrls(int argsBGID)
{
Int32 iCount = 0;
GetSOPDataResponse ret = null;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL objAdminBLL = new AdminBLL();
GetSOPData objGetBillingTableRequest = new GetSOPData();
objGetBillingTableRequest.SOP_ID = argsBGID.ToString();
objGetBillingTableRequest.WhereClause = " where SOP_ID =" + argsBGID.ToString();
ret = objAdminBLL.GetSOPData(objGetBillingTableRequest);
hdnBTID.Value = ret.SOPNo[iCount].SOP_ID.ToString();
hdnBTID.Value = ret.SOPNo[iCount].SOP_Title.ToString();
hdnBTID.Value = ret.SOPNo[iCount].SOP_Subject.ToString();
//hdnBTID.Value = ret.SOPNo[iCount].ImagePathName.ToString();
hdnBTID.Value = ret.SOPNo[iCount].Location.ToString();
cn = db.getconnection();
cn.Open();
SqlCommand _cmd = new SqlCommand("select Location_name from location where Location_id=@id", cn);
_cmd.Parameters.AddWithValue("@id", hdnBTID.Value);
SqlDataReader dr = _cmd.ExecuteReader();
if (dr.Read())
{
ddllocation.Items.Insert(0, dr.GetString(0));
//========================//
dr.Close();
dr.Dispose();
//========================//
cn.Close();
}
txtUpdateSOPNo.Text = ret.SOPNo[iCount].SOP_ID.ToString();
txtUpdateSOPTitle.Text = ret.SOPNo[iCount].SOP_Title.ToString();
txtUpdateSOPSubject.Text = ret.SOPNo[iCount].SOP_Subject.ToString();
Session.Add("ImagePath", ret.SOPNo[iCount].ImagePathName.ToString());
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void BindGrid()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetSOPData _req = new GetSOPData();
GetSOPDataResponse _resp = ws.GetSOPData(_req);
gvSOPTable.DataSource = _resp.SOPNo;
gvSOPTable.DataBind();
ShowHide();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void BindGridWithFilter()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetSOPData objReq = new GetSOPData();
// string WhereClause = ReturnWhere();
GetSOPDataResponse ret = ws.GetSOPData(objReq);
gvSOPTable.DataSource = ret.SOPNo;
gvSOPTable.DataBind();
ShowHide();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}