protected void Load_CrewCardStatus()
{
int CrewID = GetCrewID();
int CardApprover = 0;
if (Session["UTYPE"].ToString() == "OFFICE USER" || Session["UTYPE"].ToString() == "ADMIN")
{
DataSet ds = objBLLCrew.Get_CrewCardStatus(CrewID, int.Parse(Session["USERID"].ToString()));
ds.Tables[0].TableName = "Cards";
ds.Tables[1].TableName = "Attachments";
ds.AcceptChanges();
DataRelation Rel = new DataRelation("CardAttachments", ds.Tables["Cards"].Columns["CardID"], ds.Tables["Attachments"].Columns["CardID"]);
ds.Relations.Add(Rel);
ds.AcceptChanges();
rptCardDetails.DataSource = ds;
rptCardDetails.DataMember = "Cards";
rptCardDetails.DataBind();
if (ds.Tables["Cards"].Rows.Count > 0)
{
hdnCardID.Value = ds.Tables["Cards"].Rows[0]["CardID"].ToString();
if (ds.Tables["Cards"].Rows[0]["cardstatus"].ToString() == "PROPOSED")
{
if (ds.Tables["Cards"].Rows[0]["cardtype"].ToString() == "YELLOW CARD")
{
CardApprover = objUser.CRW_CHECK_Card_Approval("Yellow_Card", int.Parse(Session["USERID"].ToString()));
if (CardApprover == 1)
{
pnlCardEntry.Visible = false;
pnlCardApprove.Visible = true;
}
else
{
pnlCardEntry.Visible = false;
pnlCardApprove.Visible = false;
lblMessage.Text = "There is a pending proposal for the crew.<br><br>You can not propose a new card unless the previous proposal is accepted or rejected by the authority";
}
}
else
{
CardApprover = objUser.CRW_CHECK_Card_Approval("Red_Card", int.Parse(Session["USERID"].ToString()));
if (CardApprover == 1)
{
pnlCardEntry.Visible = false;
pnlCardApprove.Visible = true;
}
else
{
pnlCardEntry.Visible = false;
pnlCardApprove.Visible = false;
lblMessage.Text = "There is a pending proposal for the crew.<br><br>You can not propose a new card unless the previous proposal is accepted or rejected by the authority";
}
}
}
if (ds.Tables["Cards"].Rows[0]["cardstatus"].ToString() == "ISSUED")
{
if (ds.Tables["Cards"].Rows[0]["cardtype"].ToString() == "YELLOW CARD")
{
CardApprover = objUser.CRW_CHECK_Card_Approval("Red_Card", int.Parse(Session["USERID"].ToString()));
if (CardApprover == 1)
{
pnlCardEntry.Visible = true;
btnSaveAndApprove.Visible = true;
}
else
{
btnSaveAndApprove.Visible = false;
}
}
else
{
pnlCardEntry.Visible = false;
}
}
}
else
{
string CardType;
if (int.Parse(ddlCrewCardType.SelectedValue.ToString()) == 1)
{
CardType = "Yellow_Card";
}
else
{
CardType = "Red_Card";
}
CardApprover = objUser.CRW_CHECK_Card_Approval(CardType, int.Parse(Session["USERID"].ToString()));
if (CardApprover == 1)
{
btnSaveAndApprove.Visible = true;
}
else
{
btnSaveAndApprove.Visible = false;
}
pnlCardDetails.Visible = false;
}
}
else
{
lblMessage.Text = "You are not authorised to access this page.!!";
pnlCardEntry.Visible = false;
pnlCardApprove.Visible = false;
pnlCardDetails.Visible = false;
}
}
