protected void checkForConsignmentApprovals()
{
string errMsg = string.Empty;
string statusMsg = string.Empty;
string cEmailID = (!String.IsNullOrEmpty(Request.QueryString["eid"]))? Request.QueryString["eid"].ToString() : "";
string dbErr =
(!String.IsNullOrEmpty(Request.QueryString["dbErr"]))? Request.QueryString["dbErr"].ToString() : "";
string funkShun =
(!String.IsNullOrEmpty(Request.QueryString["f"]))? Request.QueryString["f"].ToString() : "";
if (funkShun == "approveconsignor")
{
if (dbErr == "")
{
statusMsg = "Consignor [ " + cEmailID + " ] approved.";
lblStatusMsg.CssClass = "statusMsg";
}
else
{
statusMsg = "DB error on Consignor Approval: [ " + cEmailID + " ]. Please try again.";
lblStatusMsg.CssClass = "errMsg";
}
lblStatusMsg.Visible = true;
lblStatusMsg.Text = statusMsg;
}
mySqlConnector mySqlConn = new mySqlConnector();
if (mySqlConn.isInitialized())
{
//-- now check db for pending approvals
if (mySqlConn.checkForPending_C_Approvals())
{
HyperLinkField userId = new HyperLinkField();
userId.HeaderText = "UserId";
userId.DataTextField = "emailaddress";
userId.DataNavigateUrlFields = new string[] { "emailaddress", "userId" };
userId.DataNavigateUrlFormatString = "~/admin/approveConsignor.aspx?eid={0}&uid={1}&aid=" + Session["emailAddress"].ToString();
//userId.SortExpression = "emailaddress";
gvConsingorApproveList.Columns.Add(userId);
BoundField firstname = new BoundField();
firstname.ReadOnly = true;
firstname.HeaderText = "First";
firstname.DataField = "firstname";
//firstname.SortExpression = "firstname";
gvConsingorApproveList.Columns.Add(firstname);
BoundField lastname = new BoundField();
lastname.ReadOnly = true;
lastname.HeaderText = "Last";
lastname.DataField = "lastname";
//lastname.SortExpression = "lastname";
gvConsingorApproveList.Columns.Add(lastname);
BoundField address1 = new BoundField();
address1.ReadOnly = true;
address1.HeaderText = "Address";
address1.DataField = "address1";
//address1.SortExpression = "address1";
gvConsingorApproveList.Columns.Add(address1);
BoundField address2 = new BoundField();
address2.ReadOnly = true;
address2.HeaderText = "Address2";
address2.DataField = "address2";
// address2.SortExpression = "address2";
gvConsingorApproveList.Columns.Add(address2);
BoundField city = new BoundField();
city.ReadOnly = true;
city.HeaderText = "City";
city.DataField = "city";
//city.SortExpression = "city";
gvConsingorApproveList.Columns.Add(city);
BoundField state = new BoundField();
state.ReadOnly = true;
state.HeaderText = "State";
state.DataField = "state";
//state.SortExpression = "state";
gvConsingorApproveList.Columns.Add(state);
BoundField zip = new BoundField();
zip.ReadOnly = true;
zip.HeaderText = "Zip";
zip.DataField = "zip";
// zip.SortExpression = "zip";
gvConsingorApproveList.Columns.Add(zip);
BoundField phoneNumber = new BoundField();
phoneNumber.ReadOnly = true;
phoneNumber.HeaderText = "Phone";
phoneNumber.DataField = "phoneNumber";
//phoneNumber.SortExpression = "phoneNumber";
gvConsingorApproveList.Columns.Add(phoneNumber);
BoundField createDate = new BoundField();
createDate.ReadOnly = true;
createDate.HeaderText = "__date";
createDate.DataField = "created";
//phoneNumber.SortExpression = "phoneNumber";
gvConsingorApproveList.Columns.Add(createDate);
gvConsingorApproveList.DataSource = null;
gvConsingorApproveList.Dispose();
gvConsingorApproveList.DataSource = mySqlConn.ds;
gvConsingorApproveList.DataBind();
consingorApproveList.Visible = true;
}
else
{
noConsignors.Text = mySqlConn.connErrMsg;
noConsignors.Visible = true;
}
}
else
{
errMsg = "db connection error!";
displayFormErrors(errMsg);
}
mySqlConn.deInitialize();
}
