protected void ImgExpExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = BLL_PB_PhoneCard.PhoneCord_Request_Export(txtCardNumber.Text != "" ? txtCardNumber.Text : null, (DataTable)Session["sVesselCode"], UDFLib.ConvertToDate(txtFromDate.Text).ToShortDateString(), UDFLib.ConvertToDate(txtToDate.Text).ToShortDateString(), ddlStatus.SelectedIndex == 0 ? null : ddlStatus.SelectedValue);
UDFLib.ChangeColumnDataType(dt, "DATE_OF_CREATION", typeof(string));
UDFLib.ChangeColumnDataType(dt, "PBILL_DATE", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["DATE_OF_CREATION"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[i]["DATE_OF_CREATION"]));
dt.Rows[i]["PBILL_DATE"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[i]["PBILL_DATE"]));
}
string[] HeaderCaptions = { "Request Number", "Vessel Name", "Status", "Request Date", "Total Cards", "Bill Date" };
string[] DataColumnsName = { "REQUEST_NUMBER", "VESSEL_NAME", "REQUEST_STATUS", "DATE_OF_CREATION", "TOTAL_REQUEST", "PBILL_DATE" };
GridViewExportUtil.ExportToExcel(dt, HeaderCaptions, DataColumnsName, "PhoneCardRequest", "Request List");
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void BindItems()
{
try
{
int Record_Count = 0;
DataTable dt = BLL_PB_PortageBill.Get_Lib_Crew_Welfare(UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertDateToNull(ddlEectiveDates.SelectedValue), pagerWf.CurrentPageIndex, pagerWf.PageSize, ref Record_Count);
UDFLib.ChangeColumnDataType(dt, "Effective_Date", typeof(string));
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr["Effective_Date"].ToString()))
{
dr["Effective_Date"] = UDFLib.ConvertUserDateFormat(Convert.ToString(dr["Effective_Date"].ToString()), UDFLib.GetDateFormat());
}
}
}
gvWelfare.DataSource = dt;
gvWelfare.DataBind();
pagerWf.CountTotalRec = Record_Count.ToString();
pagerWf.BuildPager();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
public void BindReport()
{
try
{
CommonReports rpt = new CommonReports();
DataTable dt = GetReportData();
UDFLib.ChangeColumnDataType(dt, "PBILL_Date", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["PBILL_DATE"] = UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[i]["PBILL_DATE"]));
}
rpt.ResourceName = _reportfile;
rpt.SetDataSource(dt);
rpt.Site = this.Site;
CrystalReportViewer1.Visible = true;
CrystalReportViewer1.ReportSource = rpt;
CrystalReportViewer1.DisplayToolbar = true;
CrystalReportViewer1.HasPrintButton = false;
CrystalReportViewer1.HasExportButton = false;
CrystalReportViewer1.HasToggleGroupTreeButton = false;
CrystalReportViewer1.DisplayGroupTree = false;
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void ImgExpExcel_Click(object sender, EventArgs e)
{
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = objBLL.Crew_Contract_Withhold_Search(txtfilter.Text != "" ? txtfilter.Text : null, "Percent"
, UDFLib.ConvertIntegerToNull(ddlEntryTypeFilter.SelectedValue), sortbycoloumn, sortdirection
, null, null, ref rowcount);
UDFLib.ChangeColumnDataType(dt, "Effective_Date", typeof(string));
foreach (DataRow row in dt.Rows)
{
if (!string.IsNullOrEmpty(row["Effective_Date"].ToString()))
{
row["Effective_Date"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(row["Effective_Date"]), UDFLib.GetDateFormat());
}
}
string[] HeaderCaptions = { "Contract No", "Withhold Amount", "Withhold Type", "Entry Type", "Effective Date" };
string[] DataColumnsName = { "Contract_Number", "Withhold_Amount", "Withhold_Type", "Name", "Effective_Date" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "Leave_Wages_Withhold_Rules", "Leave Wages Withhold Rules");
}
protected void Load_SeniorityRecords()
{
try
{
int PAGE_SIZE = ucCustomPager.PageSize;
int PAGE_INDEX = ucCustomPager.CurrentPageIndex;
int SelectRecordCount = ucCustomPager.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
int RankId = int.Parse(ddlRank.SelectedValue.ToString());
string Status = ddlStaus.SelectedValue.ToString();
int CompanySeniorityYear = int.Parse(ddlCompanySeniorityFilter.SelectedValue.ToString());
DataTable dt = BLL_PortageBill.Get_CrewSeniorityRecords(RankId, Status, CompanySeniorityYear, txtSearchText.Text.Trim(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection);
UDFLib.ChangeColumnDataType(dt, "RankEffective_date", typeof(string));
UDFLib.ChangeColumnDataType(dt, "CompanyEffective_date", typeof(string));
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr["RankEffective_date"].ToString()))
{
dr["RankEffective_date"] = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dr["RankEffective_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
if (!string.IsNullOrEmpty(dr["CompanyEffective_date"].ToString()))
{
dr["CompanyEffective_date"] = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dr["CompanyEffective_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
}
}
gvSeniorityRecords.DataSource = dt;
gvSeniorityRecords.DataBind();
if (ucCustomPager.isCountRecord == 1)
{
ucCustomPager.CountTotalRec = SelectRecordCount.ToString();
ucCustomPager.BuildPager();
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
public string getCrewTransferDetails(string crewid, string voyageid, string userid)
{
BLL_Crew_CrewDetails objCrewBLL = new BLL_Crew_CrewDetails();
DataTable dt = objCrewBLL.Get_Transfer_Promotions(UDFLib.ConvertToInteger(crewid), UDFLib.ConvertToInteger(voyageid), UDFLib.ConvertToInteger(userid));
UDFLib.ChangeColumnDataType(dt, "Effective_Date", typeof(string));
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr["Effective_Date"].ToString()))
{
dr["Effective_Date"] = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dr["Effective_Date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
}
}
return(UDFLib.CreateHtmlTableFromDataTable(dt, new string[] { "From Vessel", "Current Rank", "To Vessel", "Joining Rank", "Effective Date" }, new string[] { "FromVessel", "FromRank", "ToVessel", "ToRank", "Effective_Date" }, "Crew Transfer/Promotion Details"));
}
protected void Load_EffectiveDates()
{
DataTable dt = BLL_PB_PortageBill.Get_Crew_Welfare_Effective_Dates(UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue));
UDFLib.ChangeColumnDataType(dt, "Effective_Date", typeof(string));
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr["Effective_Date"].ToString()))
{
dr["Effective_Date"] = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dr["Effective_Date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
}
}
ddlEectiveDates.DataSource = dt;
ddlEectiveDates.DataTextField = "EFFECTIVE_DATE";
ddlEectiveDates.DataValueField = "EFFECTIVE_DATE";
ddlEectiveDates.DataBind();
ListItem liSelect = new ListItem("ALL", "0");
ddlEectiveDates.Items.Insert(0, liSelect);
}
protected void btnExportExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
string _SortOrderColumns = "DOA_HomePort , RANK_SORT_ORDER ";
Dictionary <string, UDCHyperLink> DicLink = new Dictionary <string, UDCHyperLink>();
lblPageTitle.Text = "Portage Bill : " + Convert.ToString(ViewState["Vessel_Name"]) + " - " + DateTime.Parse(ViewState["PBDt"].ToString()).ToString("MMM-yyyy");
UDCHyperLink alink = new UDCHyperLink();
alink.Target = "_blank";
alink.NaviagteURL = "../crew/CrewDetails.aspx";
alink.QueryStringDataColumn = new string[] { "VoyageID", "CrewID" };
alink.QueryStringText = new string[] { "VoyageID", "ID" };
DicLink.Add("Code", alink);
DataSet dsPb = BLL_PB_PortageBill.Get_PortageBill(Convert.ToInt32(DateTime.Parse(ViewState["PBDt"].ToString()).Month), Convert.ToInt32(DateTime.Parse(ViewState["PBDt"].ToString()).Year), Convert.ToInt32(ViewState["Vessel_ID"]), UDFLib.ConvertStringToNull(null), 0);
dtcomment = dsPb.Tables["Comment"];
dtEntryType = dsPb.Tables["EntryType"];
DataTable dtpb = UDFLib.PivotTable("Description",
"Amount",
"Sort_Order",
new string[] { "VOYAGEID", "PBMONTH", "PBYEAR" },
new string[] { "VOYAGEID", "PBMONTH", "PBYEAR", "RANK_SORT_ORDER", "IsFinalized", "DOA_HomePort", "RANK_SORT_ORDER", "Amount", "Description", "Sort_Order", "CrewID" },
_SortOrderColumns,
DicLink,
dsPb.Tables["Data"]
);
totalEarnID = dtpb.Columns.IndexOf("Total Earning");
totalDedID = dtpb.Columns.IndexOf("Total Deduction");
BFid = dtpb.Columns.IndexOf("balance");
dtpb.DefaultView.RowFilter = "rank <> ''";
DataTable dt = new DataTable();
dt = dtpb.DefaultView.ToTable();
string[] HeaderCaptions = { };
string[] DataColumnsName = { };
for (int i = 0; i < dt.Columns.Count; i++)
{
Array.Resize(ref HeaderCaptions, HeaderCaptions.Length + 1); HeaderCaptions[HeaderCaptions.Length - 1] = dt.Columns[i].ColumnName;
Array.Resize(ref DataColumnsName, DataColumnsName.Length + 1); DataColumnsName[DataColumnsName.Length - 1] = dt.Columns[i].ColumnName;
}
foreach (DataRow row in dt.Rows)
{
string st = row["Code"].ToString();
int start = st.IndexOf('>');
int end = st.IndexOf('<', start);
st = st.Substring(start + 1, end - start - 1);
row["Code"] = st;
}
UDFLib.ChangeColumnDataType(dt, "To", typeof(string));
UDFLib.ChangeColumnDataType(dt, "From", typeof(string));
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["From"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[i]["From"].ToString()), UDFLib.GetDateFormat());
dt.Rows[i]["To"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[i]["To"].ToString()), UDFLib.GetDateFormat());
}
}
//RemoveLinks(GridViewPB);
GridViewExportUtil.ExportToExcel(dt, HeaderCaptions, DataColumnsName, "PortageBill-" + Request.QueryString["arg"].Split('~')[2] + "-" + DateTime.Parse(Request.QueryString["arg"].Split('~')[1]).ToString("MMM-yyyy") + ".xls", "PortageBill-" + Request.QueryString["arg"].Split('~')[2] + "-" + DateTime.Parse(Request.QueryString["arg"].Split('~')[1]).ToString("MMM-yyyy"));
//GridViewExportUtil.Export("PortageBill-" + Request.QueryString["arg"].Split('~')[2] + "-" + DateTime.Parse(Request.QueryString["arg"].Split('~')[1]).ToString("MMM-yyyy") + ".xls", GridView1);
// GridView1.GridLines = GridLines.None;
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
/// <summary>
/// Method called when Export button is clicked
/// </summary>
protected void imgBtnExport_Click(object sender, ImageClickEventArgs e)
{
//Check whether date is proper
if (txtFrom.Text.Trim() != "")
{
try
{
DateTime dt1 = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtFrom.Text));
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Nature", "alert('From date is invalid.')", true);
return;
}
}
if (txtTo.Text.Trim() != "")
{
try
{
DateTime dt1 = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtTo.Text));
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Nature", "alert('To date is invalid.')", true);
return;
}
}
//Compare From and To date
if (DateTime.Compare(DateTime.Parse(UDFLib.ConvertToDefaultDt(txtTo.Text)), DateTime.Parse(UDFLib.ConvertToDefaultDt(txtFrom.Text))) < 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Nature", "alert('From date must be less than To date.')", true);
return;
}
try
{
int Count = 1; string moduleName = "";
if (ddlModule.SelectedItem.ToString() == "-SELECT-")
{
moduleName = "";
}
else
{
moduleName = ddlModule.SelectedItem.ToString();
}
//Take the values of Sorting order and sort column name
string sortbycoloumn = (ViewState["SORTBYACOLOUMN"] == null) ? null : (ViewState["SORTBYACOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTADIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTADIRECTION"].ToString());
}
DataSet dt = objMenuBLL.Get_AccessRightChanges(UDFLib.ConvertDateToNull(UDFLib.ConvertToDefaultDt(txtFrom.Text)), UDFLib.ConvertDateToNull(UDFLib.ConvertToDefaultDt(txtTo.Text)), null, null, sortbycoloumn, sortdirection,
UDFLib.ConvertIntegerToNull(ddlUser.SelectedValue), UDFLib.ConvertStringToNull(moduleName), txtPage.Text, int.Parse(Session["USERID"].ToString()), ref Count);
UDFLib.ChangeColumnDataType(dt.Tables[0], "Date", typeof(string));
if (dt.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dt.Tables[0].Rows)
{
if (!string.IsNullOrEmpty(dr["Date"].ToString()))
{
dr["Date"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dr["Date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
}
string fileHeader = "<table><tr style='font-weight:bold;'><td colspan='8'><center><h1>" + "Access Rights Changes Report</h1></center></td><td style='font-weight:bold;'>Client Name:</td><td>" + dt.Tables[1].Rows[0]["Company_Name"].ToString() + "</td></tr>";
fileHeader += "<tr><td style='font-weight:bold;'>From Date:</td><td> " + txtFrom.Text + "</td><td style='font-weight:bold;'>To Date:</td><td> " + txtTo.Text + "</td><td style='font-weight:bold;'>Selected User:</td><td>"
+ (ddlUser.SelectedItem.ToString() == "-SELECT-" ? "All" : ddlUser.SelectedItem.ToString()) + "</td><td style='font-weight:bold;'>Selected Module:</td><td>" + (ddlModule.SelectedItem.ToString() == "-SELECT-" ? "All" : ddlModule.SelectedItem.ToString()) + "</td><td style='font-weight:bold;'>Page:</td><td>" + txtPage.Text + "</td></tr>";
fileHeader += "</table>";
string[] HeaderCaptions = { "Date", "User Name", "First Name", "Last Name", "Module", "Page Description", "Page Link", "Changes", "Changed By", "User IP" };
string[] DataColumnsName = { "Date", "User_name", "First_Name", "Last_Name", "Module", "Description", "Page", "Changes", "Chaged_By", "UserIP" };
GridViewExportUtil.ShowExcel(dt.Tables[0], HeaderCaptions, DataColumnsName, "AccessReport", fileHeader, "");
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
