protected void BindAllotmentsToVerify(DataRow dr)
{
try
{
JSConfirmStatus.Value = "false";
if (dr != null)
{
CrewID = int.Parse(dr["id"].ToString());
ViewState["PBMonth"] = Convert.ToDateTime(dr["PBDate"]).Month;
ViewState["PBYear"] = Convert.ToDateTime(dr["PBDate"]).Year;
ViewState["PBYearPrev"] = Convert.ToDateTime(dr["PBDate"]).AddMonths(-1).Year;
ViewState["PBMonthPrev"] = Convert.ToDateTime(dr["PBDate"]).AddMonths(-1).Month;
AllotmentID = int.Parse(dr["AllotmentID"].ToString());
}
lblPortageBilldate.Text = "Portage Bill : " + ViewState["PBMonth"].ToString() + " / " + ViewState["PBYear"].ToString() + " [ Current ]";
lblPrevMonthPBDate.Text = "Portage Bill : " + ViewState["PBMonthPrev"].ToString() + " / " + ViewState["PBYearPrev"].ToString() + " [ Previous ]";
frmvCrewDetails.DataSource = BLL_PB_PortageBill.Get_Allotments(int.Parse(ddlFleet.SelectedValue), int.Parse(ddlVessel.SelectedValue), ViewState["PBMonth"].ToString(), ViewState["PBYear"].ToString(), int.Parse(ddlApproval.SelectedValue), int.Parse(DDLBank.SelectedValue), int.Parse(ddlStatus.SelectedValue), txtSearch.Text, CrewID, null, AllotmentID);
frmvCrewDetails.DataBind();
DataSet dtAllAllotment = BLL_PB_PortageBill.Get_Allotments_ByCrewID(int.Parse(CrewID.ToString()), Convert.ToInt32(ViewState["PBMonth"]), Convert.ToInt32(ViewState["PBYear"]));
if (dtAllAllotment.Tables[0].Rows.Count > 1)
{
(frmvCrewDetails.FindControl("btnVerifyAllot") as Button).Attributes.Add("onclick", "AlertForMorethanOneAllotments('" + dtAllAllotment.Tables[1].Rows[0][0].ToString() + "','" + (frmvCrewDetails.FindControl("btnVerifyAllot") as Button).ClientID + "');return false;");
}
DataSet ds = BLL_PB_PortageBill.ACC_Get_CrewWages_ByMonth(int.Parse(CrewID.ToString()), Convert.ToInt32(ViewState["PBMonth"]), Convert.ToInt32(ViewState["PBYear"]));
gvJoiningWages.DataSource = ds.Tables[1];
gvJoiningWages.DataBind();
if (ds.Tables[1].Rows.Count > 1)
{
gvJoiningWages.Rows[gvJoiningWages.Rows.Count - 1].Font.Bold = true;
}
gvBortagebill.DataSource = ds.Tables[0];
gvBortagebill.DataBind();
if (ds.Tables[0].Rows.Count > 1)
{
gvBortagebill.Rows[gvBortagebill.Rows.Count - 1].Font.Bold = true;
}
gvPrevMonthPB.DataSource = ds.Tables[2];
gvPrevMonthPB.DataBind();
if (ds.Tables[2].Rows.Count > 1)
{
gvPrevMonthPB.Rows[gvPrevMonthPB.Rows.Count - 1].Font.Bold = true;
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void SendMailOnFlagSave(int Allotment_ID, int Vessel_ID, string PBill_Date, int CrewID)
{
Table tblFlag = new Table();
TableRow R1flg = new TableRow();
TableCell CL1flg = new TableCell();
TableRow R2flg = new TableRow();
TableCell CL2flg = new TableCell();
R1flg.Cells.Add(CL1flg);
R2flg.Cells.Add(CL2flg);
tblFlag.Rows.Add(R1flg);
tblFlag.Rows.Add(R2flg);
DateTime dtDate = Convert.ToDateTime(PBill_Date);
frmvCrewDetails.DataSource = BLL_PB_PortageBill.Get_Allotments(int.Parse(ddlFleet.SelectedValue), int.Parse(ddlVessel.SelectedValue), ViewState["PBMonth"].ToString(), ViewState["PBYear"].ToString(), int.Parse(ddlApproval.SelectedValue), int.Parse(DDLBank.SelectedValue), int.Parse(ddlStatus.SelectedValue), txtSearch.Text, Convert.ToInt32(hdfCrewIDFlag.Value), null, AllotmentID);
frmvCrewDetails.DataBind();
(frmvCrewDetails.FindControl("btnVerifyAllot") as Button).Visible = false;
DataSet dsRmk = BLL_PB_PortageBill.ACC_GET_Allotment_Flag(Allotment_ID, Vessel_ID, dtDate);
GridView gvFlag = new GridView();
gvFlag.HeaderStyle.CssClass = "CreateHtmlTableFromDataTable-DataHedaer";
gvFlag.RowStyle.CssClass = "CreateHtmlTableFromDataTable-Data";
gvFlag.AutoGenerateColumns = false;
gvFlag.DataKeyNames = new string[] { "Flag_ID" };
gvFlag.BorderWidth = 1;
gvFlag.Width = 498;
BoundField User = new BoundField();
User.DataField = "CreatedBy";
User.HeaderText = "User";
BoundField Date = new BoundField();
Date.DataField = "CreatedOn";
Date.HeaderText = "Date";
BoundField Message = new BoundField();
Message.DataField = "Remark";
Message.HeaderText = "Message";
BoundField Attachcol = new BoundField();
Attachcol.DataField = "CreatedBy";
Attachcol.HeaderText = "Attachments";
gvFlag.Columns.Add(User);
gvFlag.Columns.Add(Date);
gvFlag.Columns.Add(Message);
gvFlag.Columns.Add(Attachcol);
gvFlag.DataSource = dsRmk.Tables[0];
gvFlag.DataBind();
foreach (GridViewRow gr in gvFlag.Rows)
{
GridView gvAttach = new GridView();
gvAttach.AutoGenerateColumns = false;
gvAttach.BorderWidth = 0;
gvAttach.ShowHeader = false;
gvAttach.RowStyle.CssClass = "CreateHtmlTableFromDataTable-Data-Attachment";
HyperLinkField LinkAttch = new HyperLinkField();
LinkAttch.DataNavigateUrlFields = new string[] { "Attachment_Path" };
LinkAttch.DataTextField = "Attachment_Name";
LinkAttch.Target = "blank";
gvAttach.Columns.Add(LinkAttch);
gvAttach.DataSource = dsRmk.Tables[1].AsEnumerable().Where(a => a["Flag_ID"].ToString().Equals(gvFlag.DataKeys[gr.RowIndex].Values["Flag_ID"].ToString())).AsDataView().ToTable();
gvAttach.DataBind();
gr.Cells[3].Text = "";
gr.Cells[3].Controls.Add(gvAttach);
}
CL1flg.Controls.Add(frmvCrewDetails);
CL2flg.Controls.Add(gvFlag);
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
tblFlag.RenderControl(htmlWrite);
string mailContent = htmlWrite.InnerWriter.ToString();
string mailBody = "<html><head> <style type='text/css'> body { font-size: 11px;font-family: Tahoma ,Tahoma, Sans-Serif; } .CreateHtmlTableFromDataTable-PageHeader { background-color: #F6B680; } .CreateHtmlTableFromDataTable-DataHedaer { background-color: #F2F2F2; border: 1px solid gray; text-align: center; } .CreateHtmlTableFromDataTable-Data{ border: 1px solid gray; } </style> </head> <body > <table style='width:500px;background-color: #FFFFFF;border: 2px solid #FFB733;' border='1' ><tr><td>" + mailContent + "</td> </tr> </table> </body></html>";
string sToEmailAddress = BLL_PB_PortageBill.ACC_Get_Allotment_Flag_Mail(Convert.ToInt32(Session["userid"]));
BLL_Crew_CrewDetails objMail = new BLL_Crew_CrewDetails();
objMail.Send_CrewNotification(0, 0, 0, 0, sToEmailAddress, "", "", "Allotment Flag", mailBody, "", "MAIL", "", UDFLib.ConvertToInteger(Session["USERID"].ToString()), "READY");
}
protected void Load_Allotments()
{
int?AmountValue = chkAmountIsGreaterthanZero.Checked == true?UDFLib.ConvertIntegerToNull(1) : null;
gvAllotments.PageSize = int.Parse(ddlPageSize.SelectedValue);
DataTable dt = BLL_PB_PortageBill.Get_Allotments(int.Parse(ddlFleet.SelectedValue)
, int.Parse(ddlVessel.SelectedValue)
, ddlMonth.SelectedValue
, ddlYear.SelectedValue
, int.Parse(ddlApproval.SelectedValue)
, int.Parse(DDLBank.SelectedValue)
, int.Parse(ddlStatus.SelectedValue)
, txtSearch.Text
, CrewID
, UDFLib.ConvertIntegerToNull(rbtnVerificationStatus.SelectedValue)
, null
, AmountValue
, chkFlagedItems.Checked
, Convert.ToInt32(ddlCountry.SelectedValue));
gvAllotments.DataSource = dt;
gvAllotments.DataBind();
DataTable dtIDs = new DataTable();
dtIDs.Columns.Add("ID");
dtIDs.Columns.Add("AllotmentID");
dtIDs.Columns.Add("PBDate", typeof(DateTime));
DataRow drID;
foreach (DataRow dr in dt.Rows)
{
drID = dtIDs.NewRow();
drID["ID"] = dr["id"].ToString();
drID["AllotmentID"] = dr["AllotmentID"].ToString();
drID["PBDate"] = dr["PBill_Date"];
dtIDs.Rows.Add(drID);
}
ctlRecordNavigationAllotment.InitRecords(dtIDs);
lblRecordCount.Text = dt.Rows.Count.ToString();
if (gvAllotments.PageCount > 0)
{
lblPageStatus.Text = (gvAllotments.PageIndex + 1).ToString() + " of " + gvAllotments.PageCount.ToString();
}
else
{
lblPageStatus.Text = "0 of 0";
}
UpdatePanel2.Update();
DateTime?pbilldate = BLL_PB_PortageBill.Get_Valid_Date_TO_Rework_Allotment(Convert.ToInt32(ddlVessel.SelectedValue));
if (pbilldate != null && objUA.Admin == 1)
{
btnReworkAllotmentToVessel.Text = "Rework allotment [" + Convert.ToDateTime(pbilldate).ToString("MMM-yyyy") + "] to " + ddlVessel.SelectedItem.Text;
btnReworkAllotmentToVessel.CommandArgument = pbilldate.ToString();
btnReworkAllotmentToVessel.Visible = true;
}
}