private void Load_LashingGearInventoryReport_Details(int Main_Report_ID, int Vessel_ID)
{
try
{
DataSet ds = BLL_LGInventoryReport.Get_LGI_REPORT_Log(Main_Report_ID, Vessel_ID);
if (ds.Tables[1].Rows.Count > 0)
{
lblReportDate.Text = ds.Tables[1].Rows[0]["RptDate"].ToString();
lblVesselName.Text = ds.Tables[1].Rows[0]["Vessel_Name"].ToString();
txtremarks.Text = ds.Tables[1].Rows[0]["Remarks"].ToString();
lblMasterSignature.Text = ds.Tables[1].Rows[0]["MasterName"].ToString();
//lblmasterDate.Text = ds.Tables[1].Rows[0]["CrewMsDate"].ToString();
lblchiefofficer.Text = ds.Tables[1].Rows[0]["COName"].ToString();
//lblchiefofficerdate.Text = ds.Tables[1].Rows[0]["CrewCoDate"].ToString();
}
GridView_LashingInventoryRPT.DataSource = ds.Tables[0];
GridView_LashingInventoryRPT.DataBind();
objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5 }, "Units Received", "HeaderStyle-css");
objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7 }, "Operational Losses or Condemned", "HeaderStyle-css");
//UserAccessValidation();
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
MergeGridviewHeader_Info objVetMerge = new MergeGridviewHeader_Info();
if (GetSessionUserID() == 0)
{
Response.Redirect("~/account/login.aspx");
}
String msgretv = String.Format("setTimeout(getOperatingSystem,500);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgret6v", msgretv, true);
UserAccessValidation();
setDateFormat();
if (!IsPostBack)
{
BindVesselDDL();
VET_Get_VettingTypeList();
Add_VettingStatus();
VET_Get_OilMajorList();
Add_JobStatus();
Bind_VettingIndex();
VET_Get_InspectorList();
}
objVetMerge.AddMergedColumns(new int[] { 9, 10, 11, 12 }, "Report", "GroupHeaderStyle-css HeaderStyle-css");
objVetMerge.AddMergedColumns(new int[] { 13, 14, 15, 16 }, "Jobs", "GroupHeaderStyle-css HeaderStyle-css");
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
TechnicalBAL objtechBAL = new TechnicalBAL();
dtQTNReceived = objtechBAL.GetToopTipsForQtnRecve();
dtQTNSent = objtechBAL.GetToopTipsForQtnSent();
if (!IsPostBack)
{
BindFleetDLL();
DDLFleet.SelectedValue = Session["USERFLEETID"].ToString();
BindVesselDDL();
BindDeptTypeOpt();
BindDepartmentByST_SP();
//BindPendingStatas();
rgdReqAllStage.Attributes.Add("bordercolor", "#D8D8D8");
txtSearchJoinFromDate.Text = (DateTime.Now.AddDays(-(DateTime.Now.DayOfYear) + 1)).ToString("dd-MM-yyyy");
txtSearchJoinToDate.Text = (DateTime.Now.AddMonths(1).AddDays(-(DateTime.Now.Day))).ToString("dd-MM-yyyy");
BindSearchRequistionstages();
//txtSearchJoinFromDate.Text.Trim() == "" ? "1900/01/01" : txtSearchJoinFromDate.Text.Trim(),
//txtSearchJoinToDate.Text.Trim() == "" ? "2099/01/01" : txtSearchJoinToDate.Text.Trim(),
}
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "Requisition", "HeaderStyle-css");
objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8 }, "Quotation", "HeaderStyle-css");
objChangeReqstMerge.AddMergedColumns(new int[] { 9, 10, 11, 12 }, "Purchase Order", "HeaderStyle-css");
objChangeReqstMerge.AddMergedColumns(new int[] { 13, 14, 15 }, "Delivery", "HeaderStyle-css");
}
protected void Page_Load(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "myFunction();", true);
UserAccessValidation();
//UserAccessTypeValidation();
objContractList.AddMergedColumns(new int[] { 10, 11 }, "Evaluation", "HeaderStyle-center");
objContractList.AddMergedColumns(new int[] { 12, 13, 14 }, "Supplier", "HeaderStyle-center");
objContractList.AddMergedColumns(new int[] { 15, 16 }, "Change", "HeaderStyle-center");
objContractList.AddMergedColumns(new int[] { 17, 18, 19, 20, 21, 22 }, "Invoice/PO", "HeaderStyle-center");
this.Form.DefaultButton = this.btnGet.UniqueID;
if (!IsPostBack)
{
if (Request.QueryString["Supplier_Code"] != null)
{
txtfilter.Text = Request.QueryString["Supplier_Code"].ToString();
}
else
{
txtfilter.Text = "";
}
chkApproved.Checked = true;
chkBlack.Checked = true;
chkCond.Checked = true;
chkexp.Checked = true;
chkUnreg.Checked = true;
BindType();
BindPort();
BindScope();
BindEvaluationStatus();
BindEvaluationGrid();
BindChangeRequestGrid();
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
UserAccessValidation();
if (!IsPostBack)
{
BindFleetDLL();
DDLFleet.SelectedValue = Session["USERFLEETID"].ToString();
BindVesselDDL();
ViewState["System_ID"] = null;
ViewState["IsNewFlage"] = null;
ViewState["SORTDIRECTION"] = null;
ViewState["SORTBYCOLOUMN"] = null;
ViewState["Status"] = null;
optStatus.SelectedValue = "P";
BindMachineryChageRequests();
}
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5 }, "ORIGINAL", "HeaderStyle-css");
objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7, 8, 9 }, "CHANGE REQUEST", "HeaderStyle-css");
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
}
}
public void BindOverDueJobs()
{
mergeheadgvOverdue = new MergeGridviewHeader_Info();
mergeheadgvOverdue.AddMergedColumns(new int[] { 7, 8 }, "Frequency", "PMSGridHeaderStyle-css");
mergeheadgvOverdue.AddMergedColumns(new int[] { 9, 10 }, "Last Done", "PMSGridHeaderStyle-css");
mergeheadgvOverdue.AddMergedColumns(new int[] { 14, 15 }, "M/C R. Hrs.", "PMSGridHeaderStyle-css");
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());
}
DataSet ds = objJobStatus.TecJobOverDueSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), ucf_DDLVessel.SelectedValues, ucf_DLLLocation.SelectedValues, ucf_DDLSubCatalogue.SelectedValues
, UDFLib.ConvertIntegerToNull(DDLJobDepartment.SelectedValue), ucf_DDLRank.SelectedValues, UDFLib.ConvertStringToNull(ucf_txtSearchJobTitle.FilterText), ucf_txtSearchJobTitle.FilterType
, UDFLib.ConvertIntegerToNull(ucf_txtSearchJobID.FilterNumber), ucf_txtSearchJobID.FilterType, ucf_optCritical.SelectedValues, ucf_optCMS.SelectedValues, null, null
, UDFLib.ConvertIntegerToNull(ddlMonth.SelectedValue), UDFLib.ConvertIntegerToNull(ddlYear.SelectedValue), UDFLib.ConvertStringToNull(optStatus.SelectedValue)
, sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
gvOverDueJobs.DataSource = ds.Tables[0];
gvOverDueJobs.DataBind();
if (ViewState["Jobid"] == null)
{
ViewState["Jobid"] = ds.Tables[0].Rows[0]["JOB_ID"].ToString();
ViewState["Job_OverDue_ID"] = ds.Tables[0].Rows[0]["OverDue_ID"].ToString();
ViewState["Vessel_ID"] = ds.Tables[0].Rows[0]["Vessel_ID"].ToString();
gvOverDueJobs.SelectedIndex = 0;
//BindJobsOverdueHistory(Convert.ToInt32(ViewState["Jobid"].ToString()));
}
SetJobOverdueRowSelection();
}
else
{
gvOverDueJobs.SelectedIndex = -1;
gvOverDueJobs.DataSource = ds.Tables[0];
gvOverDueJobs.DataBind();
gvJobHistory.DataSource = ds.Tables[0];
gvJobHistory.DataBind();
}
}
public void BindGridView()
{
try
{
objChangeReqstMerge.AddMergedColumns(new int[] { 0, 1, 2, 3, 4, 5 }, "PO", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7, 8, 9, 10, 11, 12 }, "Invoice", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 13, 14, 15 }, "Payment", "HeaderStyle-center");
ViewState["SupplyID"] = "";
ChkStatus();
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());
}
DataSet ds = new DataSet();
if (POStatus != null || UnpaidInvoiceStatus != null || InvoiceStatus != null)
{
ds = BLL_POLOG_Register.POLOG_Get_Invoice_Summary_Report(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue),
UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), POStatus, UnpaidInvoiceStatus, InvoiceStatus, txtFromDate.Text != "" ? Convert.ToDateTime(txtFromDate.Text) : Convert.ToDateTime("01/01/1900")
, txtToDate.Text != "" ? Convert.ToDateTime(txtToDate.Text) : Convert.ToDateTime("01/01/1900"),
txtFromPayment.Text != "" ? Convert.ToDateTime(txtFromPayment.Text) : Convert.ToDateTime("01/01/1900"), txtToPayment.Text != "" ? Convert.ToDateTime(txtToPayment.Text) : Convert.ToDateTime("01/01/1900"), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
}
//}
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
divPurchase.Visible = true;
gvPurchase.DataSource = ds.Tables[0];
gvPurchase.DataBind();
Label lblPOUSDAmount1 = (Label)gvPurchase.FooterRow.FindControl("lblPOUSDAmount1");
Label lblInvBookValue1 = (Label)gvPurchase.FooterRow.FindControl("lblInvBookValue1");
lblPOUSDAmount1.Text = ds.Tables[1].Rows[0]["PO_USD_Value"].ToString();
lblInvBookValue1.Text = ds.Tables[2].Rows[0]["Invoice_USD_Amount"].ToString();
}
else
{
divPurchase.Visible = false;
gvPurchase.DataSource = ds.Tables[0];
gvPurchase.DataBind();
gvPurchase.EmptyDataText = "NO RECORDS FOUND";
}
}
catch { }
{
}
}
protected void BindGrid()
{
try
{
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Verified", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 16, 17 }, "Approved", "HeaderStyle-center");
int rowcount = ucCustomPagerItems.isCountRecord;
DataTable dtType = ChkType();
string urgent = null;
if (chkUrgent.Checked == true)
{
urgent = "YES";
}
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
ChkStatus();
//string ReqsnStatus = hdfSelectedStageValue.Value;
DataSet ds = BLL_POLOG_Register.POLOG_Get_Pending_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue),
UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), CurrStatus, urgent, dtType, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
//btnApprove.Visible = true;
gvPendinginvoice.DataSource = ds.Tables[0];
gvPendinginvoice.DataBind();
}
else
{
// btnApprove.Visible = false;
gvPendinginvoice.DataSource = ds.Tables[0];
gvPendinginvoice.DataBind();
gvPendinginvoice.EmptyDataText = "NO RECORDS FOUND";
}
}
catch { }
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Form_ID = UDFLib.ConvertToInteger(Request.QueryString["Form_ID"]);
Dtl_Report_ID = UDFLib.ConvertToInteger(Request.QueryString["DtlID"]);
Vessel_ID = UDFLib.ConvertToInteger(Request.QueryString["VID"]);
objMergeList.AddMergedColumns(new int[] { 5, 6 }, "Fuel Pump", "HeaderStyle-css-2");
objMergeList.AddMergedColumns(new int[] { 10, 11, 12, 13 }, "Running Hours Since", "HeaderStyle-css-2");
Load_ME_Perf_Report_Details(Dtl_Report_ID, Vessel_ID);
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserAccessValidation();
objContractList.AddMergedColumns(new int[] { 4, 5, 6 }, "Company Seniority", "HeaderStyle-css HeaderStyle-css-center");
objContractList.AddMergedColumns(new int[] { 7, 8, 9, 10 }, "Rank Seniority", "HeaderStyle-css HeaderStyle-css-center");
if (!IsPostBack)
{
ucCustomPager.PageSize = 20;
Load_RankList();
Load_SeniorityRecords();
}
//string msg1 = String.Format("$('.sailingInfo').SailingInfo();");
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgshowdetails", msg1, true);
}
protected void Page_Load(object sender, EventArgs e)
{
UserAccessValidation();
if (!string.IsNullOrEmpty(Request.QueryString["Vessel_ID"]))
{
DataSet dsCapt = BLL_PB_PortageBill.ReportDetailsByID(Request.QueryString["ID"], Request.QueryString["Vessel_ID"]);
if (dsCapt.Tables[0].Rows.Count > 0)
{
lblVessel.Text = dsCapt.Tables[0].Rows[0]["Vessel_Name"].ToString();
if (!string.IsNullOrEmpty(dsCapt.Tables[0].Rows[0]["from_date"].ToString()))
{
lblFrom.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dsCapt.Tables[0].Rows[0]["from_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
if (!string.IsNullOrEmpty(dsCapt.Tables[0].Rows[0]["To_date"].ToString()))
{
lblTo.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dsCapt.Tables[0].Rows[0]["To_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
lblOpnBL.Text = dsCapt.Tables[0].Rows[0]["Opening_Bal"].ToString();
lblClosing.Text = dsCapt.Tables[0].Rows[0]["Closing_Bal"].ToString();
objItemColumn.AddMergedColumns(new int[] { 5, 6 }, "Amount", "HeaderStyle-css");
gvCastCash.DataSource = dsCapt.Tables[0];
gvCastCash.DataBind();
(gvCastCash.FooterRow.FindControl("lblRcvdTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Recp_Amount"].ToString();
(gvCastCash.FooterRow.FindControl("lblPaidTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Payment_Amount"].ToString();
}
}
}
protected void BindInvoiceCount()
{
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());
}
DataSet ds = BLL_POLOG_Invoice.POLOG_Get_Rework_Invoice(Convert.ToInt16(ddlUserName.SelectedValue), sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
// objChangeReqstMerge.AddMergedColumns(new int[] { 3, 4 }, "PO", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5, 6, 7, 8, 9 }, "Invoice", "HeaderStyle-center");
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
gvInvoice.DataSource = ds.Tables[0];
gvInvoice.DataBind();
}
if (ds.Tables[1].Rows.Count > 0)
{
gvInvoiceCount.DataSource = ds.Tables[1];
gvInvoiceCount.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// UserAccessValidation();
if (!string.IsNullOrEmpty(Request.QueryString["Vessel_ID"]))
{
DataTable dtWelfareDetails = BLL_PB_PortageBill.Get_Crew_Welfare_Details(UDFLib.ConvertToInteger(Request.QueryString["Welfare_ID"]), Convert.ToInt32(Request.QueryString["Vessel_ID"]), UDFLib.ConvertDateToNull(Request.QueryString["PB_Date"]));
if (dtWelfareDetails.Rows.Count > 0)
{
lblVessel.Text = dtWelfareDetails.Rows[0]["Vessel_Name"].ToString();
if (!string.IsNullOrEmpty(dtWelfareDetails.Rows[0]["from_date"].ToString()))
{
lblFrom.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dtWelfareDetails.Rows[0]["from_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
if (!string.IsNullOrEmpty(dtWelfareDetails.Rows[0]["To_date"].ToString()))
{
lblTo.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dtWelfareDetails.Rows[0]["To_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat());
}
lblOpnBL.Text = dtWelfareDetails.Rows[0]["Opening_Bal"].ToString();
lblClosing.Text = dtWelfareDetails.Rows[0]["Closing_Bal"].ToString();
objItemColumn.AddMergedColumns(new int[] { 5, 6 }, "Amount", "HeaderStyle-css");
gvWelfareDetails.DataSource = dtWelfareDetails;
gvWelfareDetails.DataBind();
(gvWelfareDetails.FooterRow.FindControl("lblRcvdTotal") as Label).Text = dtWelfareDetails.Rows[0]["Total_Recp_Amount"].ToString();
(gvWelfareDetails.FooterRow.FindControl("lblPaidTotal") as Label).Text = dtWelfareDetails.Rows[0]["Total_Payment_Amount"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserAccessValidation();
if (!IsPostBack)
{
ViewState["SORTDIRECTION"] = null;
ViewState["SORTBYCOLOUMN"] = null;
ucCustomPagerItems.PageSize = 20;
Load_ApprovalGroup();
Load_UserList();
Load_ApprovalType();
BindUserApproval();
}
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3 }, "Approvel Limit", "HeaderStyle-css");
objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5, 6, 7 }, "Approver Type", "HeaderStyle-css");
}
protected void BindOnlineInvoice()
{
try
{
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5, 6, 7 }, "PO Details", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 9, 10, 11, 12, 13, 14 }, "Online Invoice", "HeaderStyle-center");
int rowcount = ucCustomPager1.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataSet ds = BLL_POLOG_Invoice.POLOG_Get_PedingOnline_Invoice(txtfilter.Text.Trim() != "" ? txtfilter.Text.Trim() : null, GetSessionUserID(),
sortbycoloumn, sortdirection
, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount);
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
gvOnlineInvoice.DataSource = ds.Tables[0];
gvOnlineInvoice.DataBind();
}
else
{
gvOnlineInvoice.DataSource = null;
gvOnlineInvoice.DataBind();
gvExistingInvoices.DataSource = null;
gvExistingInvoices.DataBind();
gvDuplieCateinvoice.DataSource = null;
gvDuplieCateinvoice.DataBind();
}
}
catch { }
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
objVicRate.AddMergedColumns(new int[] { 0, 1, 2, 3 }, "Dry", "HeaderStyle-css HeaderStyle-css-center");
objVicRate.AddMergedColumns(new int[] { 4, 5, 6, 7 }, "Fresh", "HeaderStyle-css HeaderStyle-css-center");
DataSet dsProv = BLL_PURC_Provision.Get_Calculate_Victualling_Rate(Convert.ToInt32(Request.QueryString["VESSEL_ID"]), Request.QueryString["REQSN_CODE"].ToString(), UDFLib.ConvertStringToNull(Request.QueryString["ORDER_CODE"]), Convert.ToInt32(Session["USERID"]));
gvVictuallingRate.DataSource = dsProv.Tables["VICRATE"];
gvVictuallingRate.DataBind();
if (dsProv.Tables["MEAT"].Rows.Count > 0)
{
lblMeatMaxLimit.Text = Convert.ToString(dsProv.Tables["MEAT"].Rows[0]["MEAT_LIMIT"]);
lblMeatCurrentQty.Text = Convert.ToString(dsProv.Tables["MEAT"].Rows[0]["CURRENT_MEAT_QTY"]);
}
gvPercentage.DataSource = BLL_PURC_Provision.Get_Reqsn_Items_Percent(Request.QueryString["REQSN_CODE"].ToString(), UDFLib.ConvertStringToNull(Request.QueryString["ORDER_CODE"]), "PROVI");
gvPercentage.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
UserAccessValidation();
if (!IsPostBack)
{
BindFleetDLL();
DDLFleet.SelectedValue = Session["USERFLEETID"].ToString();
BindVesselDDL();
BindSystem();
BindSubSystem();
BindPMSDepartmentDDL();
BindRankDDL();
ViewState["Vessel_id"] = null;
ViewState["System_ID"] = null;
ViewState["IsNewFlage"] = null;
ViewState["SORTDIRECTION"] = null;
ViewState["SORTBYCOLOUMN"] = null;
ViewState["Status"] = null;
optStatus.SelectedValue = "P";
// ucCustomPagerItems.PageSize = 30;
BindGrid();
}
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "Original Job Deatils", "HeaderStyle-css HeadetTHStyle");
objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11 }, "Change Request", "HeaderStyle-css HeadetTHStyle");
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
}
}
protected void BindInvoiceApprovedGrid()
{
try
{
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Invoice Approved", "HeaderStyle-center");
int rowcount = ucCustomPager1.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
string InvoiceStatus = (ViewState["InvoiceStatus"] == null) ? null : (ViewState["InvoiceStatus"].ToString());
string InvoiceWorkflow = (ViewState["InvoiceWorkflow"] == null) ? null : (ViewState["InvoiceWorkflow"].ToString());
//string InvoiceWorkflow = (ViewState["InvoiceWorkflow"] == null) ? null : (ViewState["InvoiceWorkflow"].ToString());
DataSet ds = BLL_POLOG_Register.POLOG_Get_Approved_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue),
UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1 : 0, InvoiceStatus, InvoiceWorkflow, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection
, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount);
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
divApprovedInvoice.Visible = true;
btnApprove.Visible = true;
//btnApproveAll.Visible = true;
//btnRework.Visible = true;
//btnRefresh.Visible = true;
//btnUnApprove.Visible = false;
gvApprovedInvoice.DataSource = ds.Tables[0];
gvApprovedInvoice.DataBind();
}
else
{
divApprovedInvoice.Visible = false;
gvApprovedInvoice.DataSource = ds.Tables[0];
gvApprovedInvoice.DataBind();
}
}
catch { }
{
}
}
/// <summary>
/// Bind ApprovalHistory Gridview
/// </summary>
protected void gvApprovalHistory_DataBound(object sender, EventArgs e) // -- DataBound ApprovalHistory Gridview
{
string HeaderToHide = "";
string HeaderSupplier = "";
var grh = gvApprovalHistory.HeaderRow;
for (int i = 0; i < gvApprovalHistory.HeaderRow.Cells.Count; i++)
{
string Suppname = grh.Cells[i].Text.ToLower();
if (Suppname.Contains("_hide"))
{
HeaderToHide += i.ToString() + ",";
HeaderSupplier += grh.Cells[i].Text.Split(new char[] { '_' })[0] + ",";
gvApprovalHistory.HeaderRow.Cells[i].Visible = false;
foreach (GridViewRow gr in gvApprovalHistory.Rows)
{
gr.Cells[i].Visible = false;
}
}
if (Suppname.Contains("_amount"))
{
gvApprovalHistory.HeaderRow.Cells[i].Text = "Amount";
gvApprovalHistory.HeaderRow.Cells[i].CssClass = "HeaderStyle-css";
foreach (GridViewRow gr in gvApprovalHistory.Rows)
{
gr.Cells[i].CssClass = "amount-css";
gr.Cells[0].CssClass = "text-css";
gr.Cells[gr.Cells.Count - 1].CssClass = "text-css";
}
}
if (Suppname.Contains("_currency"))
{
gvApprovalHistory.HeaderRow.Cells[i].Text = "Currency";
gvApprovalHistory.HeaderRow.Cells[i].CssClass = "HeaderStyle-css";
}
}
string[] strColumnIndex = HeaderToHide.Split(new char[] { ',' });
string[] strHeaderName = HeaderSupplier.Split(new char[] { ',' });
int index = 0;
foreach (string item in strColumnIndex)
{
if (item != "")
{
objApprovalHist.AddMergedColumns(new int[] { int.Parse(item) + 1, int.Parse(item) + 2 }, strHeaderName[index]);
}
index++;
}
}
protected void Page_Load(object sender, EventArgs e)
{
calFrom.Format = CalendarExtender1.Format = UDFLib.GetDateFormat();
if (GetSessionUserID() == 0)
{
Response.Redirect("~/account/login.aspx");
}
else
{
UserAccessValidation();
}
TodayDateFormat = UDFLib.DateFormatMessage();
objContractList.AddMergedColumns(new int[] { 13, 14 }, "Eval(%)", "HeaderStyle-css-2");
if (!IsPostBack)
{
ConfidentialityCheck();
ViewState["SORTDIRECTION"] = null;
ViewState["SORTBYCOLOUMN"] = null;
int CurrentUserID = GetSessionUserID();
hdnUserID.Value = CurrentUserID.ToString();
//txtSearchJoinFromDate.Text = DateTime.Now.AddYears(-5).ToString("dd/MM/yyyy", iFormatProvider);
txtSearchJoinFromDate.Text = DateTime.Now.AddYears(-5).ToString("dd/MM/yyyy", iFormatProvider);
txtSearchJoinFromDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(txtSearchJoinFromDate.Text));
txtSearchJoinToDate.Text = DateTime.Now.ToString("dd/MM/yyyy", iFormatProvider);
txtSearchJoinToDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(txtSearchJoinToDate.Text));
Load_CountryList();
Load_FleetList();
Load_ManningAgentList();
Load_RankList();
Load_VesselList();
Load_MainStatus();
Load_VesselTypes();
ucCustomPager_CrewList.PageSize = 30;
FillGridViewAfterSearch();
if (Session["UTYPE"].ToString() == "MANNING AGENT")
{
GridView1.Columns[13].Visible = false;
GridView1.Columns[14].Visible = false;
}
}
string js = "Timer();RefreshButtonPopups();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "initscript", js, true);
}
protected void BindApprovedPaymentInvoice()
{
try
{
int rowcount = ucCustomPagerItems.isCountRecord;
DataTable dtType = new DataTable();
objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5 }, "Payment Planned", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7 }, "Priority", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 8, 9 }, "Overdue", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 10, 11 }, "0 To 7 Days", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 12, 13 }, "8 to 14 Days", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "After 15 Days", "HeaderStyle-center");
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
Int16 AutoCheck = 0;
if (chkAuto.Checked == true)
{
AutoCheck = 1;
}
else
{
AutoCheck = 0;
}
DataTable dt = BLL_POLOG_Register.POLOG_Get_Payment_Processing_Invoice_Search(UDFLib.ConvertStringToNull(ddlCurrency.SelectedValue), Convert.ToInt16(AutoCheck), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
//if (dt.Rows.Count > 0)
//{
divApprovedinvoice.Visible = true;
gvApprovedPaymentinvoice.DataSource = dt;
gvApprovedPaymentinvoice.DataBind();
gvApprovedPaymentinvoice.Rows[0].BackColor = System.Drawing.Color.Yellow;
BindSupplierInvoice(dt.Rows[0]["Supplier_Code"].ToString());
BindSupplierDetails(dt.Rows[0]["Supplier_Code"].ToString());
txtSupplierCode.Text = dt.Rows[0]["Supplier_Code"].ToString();
//}
//else
//{
// divApprovedinvoice.Visible = false;
// gvApprovedPaymentinvoice.DataSource = dt;
// gvApprovedPaymentinvoice.DataBind();
//}
}
catch { }
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (UDFLib.GetSessionUserID() == 0)
{
Response.Redirect("~/account/login.aspx?ReturnUrl=" + Request.Path.ToString());
}
UserAccessValidation();
objMegeHead.AddMergedColumns(new int[] { 1, 2 }, "Inspection", "HeaderStyle-css HeadetTHStyle");
objMegeHead.AddMergedColumns(new int[] { 8, 9, 10 }, "Duration", "HeaderStyle-css HeadetTHStyle");
if (!IsPostBack)
{
if (Session["COMPANYTYPE"].ToString().ToUpper() == "SURVEYOR")
{
lblFleet.Text = "Company :";
DDLFleet.Visible = false;
ddlVessel_Manager.Visible = true;
}
FillDDL();
if (Request.QueryString.Count == 3)
{
txtFromDate.Text = Convert.ToDateTime(Request.QueryString[0]).ToString("dd/MMM/yy");
txtToDate.Text = Convert.ToDateTime(Request.QueryString[1]).ToString("dd/MMM/yy");
DDLVessel.SelectedValue = Request.QueryString[2];
}
string CompanyID = Session["USERCOMPANYID"].ToString();
// removed DisplayReportIcon
if (Request.QueryString.Count > 0 && Request.QueryString["InspectionId"] != "")
{
InspectionId = Convert.ToInt16(Request.QueryString["InspectionId"]);
}
Load_Current_Schedules();
}
}
private void LoadDetails(int Main_Report_ID, int Vessel_ID)
{
try
{
DataSet ds = BLL_TankerInspection.GET_TANK_REPORT_DETAILS(Vessel_ID, Main_Report_ID);
if (ds.Tables[1].Rows.Count > 0)
{
lblYear.Text = ds.Tables[0].Rows[0]["Report_Year"].ToString();
lblVesselName.Text = ds.Tables[0].Rows[0]["Vessel_Name"].ToString();
txtremarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString();
if (ds.Tables[0].Rows[0]["VslMasterID"].ToString() != "" && ds.Tables[0].Rows[0]["VslMasterID"].ToString() != "0")
{
lnkMaster.Text = ds.Tables[0].Rows[0]["VslMasterName"].ToString();
lnkMaster.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + ds.Tables[0].Rows[0]["VslMasterID"].ToString();
lnkMaster.Target = "_blank";
imgMaster.ImageUrl = hdnBaseURL.Value + "uploads/CrewImages/" + ds.Tables[0].Rows[0]["PhotoUrl1"].ToString();
lnkMaster.Visible = true;
imgMaster.Visible = true;
}
else
{
lnkMaster.Visible = false;
imgMaster.Visible = false;
}
if (ds.Tables[0].Rows[0]["VslChiefOfficerID"].ToString() != "" && ds.Tables[0].Rows[0]["VslChiefOfficerID"].ToString() != "0")
{
lnkChiefOfficer.Text = ds.Tables[0].Rows[0]["VslChiefOfficerName"].ToString();
lnkChiefOfficer.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + ds.Tables[0].Rows[0]["VslChiefOfficerID"].ToString();
lnkChiefOfficer.Target = "_blank";
imgChiefOfficer.ImageUrl = hdnBaseURL.Value + "uploads/CrewImages/" + ds.Tables[0].Rows[0]["PhotoUrl2"].ToString();
lnkChiefOfficer.Visible = true;
imgChiefOfficer.Visible = true;
}
else
{
lnkChiefOfficer.Visible = false;
imgChiefOfficer.Visible = false;
}
}
GridView_Tanker.DataSource = ds.Tables[1];
GridView_Tanker.DataBind();
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5, 6 }, "Units Received", "HeaderStyle-css");
//UserAccessValidation();
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
objItemColumn.AddMergedColumns(new int[] { 6, 7, 8, 9, 10 }, "Scanned Copy from vessel", "HeaderStyle-css");
if (!IsPostBack)
{
UserAccessValidation();
Load_Years();
Load_FleetList();
Load_VesselList();
Load_PB_Received();
}
}
public void BindLimit(string Group_Code)
{
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5 }, "Approver", "HeaderStyle-center");
DataTable dt = BLL_POLOG_Lib.POLOG_Get_Approval_Limit_Search(Group_Code, GetSessionUserID());
if (dt.Rows.Count > 0)
{
gvLimit.DataSource = dt;
gvLimit.DataBind();
}
else
{
gvLimit.DataSource = dt;
gvLimit.DataBind();
}
}
public void BindJobsOverdueHistory(int?Jobid)
{
BLL_PMS_Job_Status objJobStatus = new BLL_PMS_Job_Status();
mergeheadgvOverdueHistory = new MergeGridviewHeader_Info();
mergeheadgvOverdueHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css");
//mergeheadgvJobHistory = new MergeGridviewHeader_Info();
//mergeheadgvOverdueHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css");
int rowcount = ucCustomPagerItems.isCountRecord;
int?jobid = null; if (ViewState["Jobid"] != null)
{
jobid = Convert.ToInt32(ViewState["Jobid"].ToString());
}
DataSet ds = objJobStatus.TecJobsOverdueHistorySearch(jobid, null
, null, null, null, null, null, null, null, null
, null, null, null, null, null, null
, null, null, ref rowcount);
if (ds.Tables[0].Rows.Count > 0)
{
gvOverDueJobHistory.DataSource = ds.Tables[0];
gvOverDueJobHistory.DataBind();
//mergeheadgvJobHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css");
gvJobHistory.DataSource = ds.Tables[1];
gvJobHistory.DataBind();
}
else
{
gvOverDueJobHistory.DataSource = ds.Tables[0];
gvOverDueJobHistory.DataBind();
// mergeheadgvJobHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css");
gvJobHistory.DataSource = ds.Tables[0];
gvJobHistory.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserAccessValidation();
lblmsg.Text = "";
objContractList.AddMergedColumns(new int[] { 6, 7 }, "No. of items", "HeaderStyle-css");
if (!IsPostBack)
{
// first check for supplier's log-in
string s = UDFLib.ConvertStringToNull(1);
if (string.IsNullOrWhiteSpace(Convert.ToString(Session["SUPPCODE"])) && UDFLib.ConvertToInteger(Session["userid"]) == 0)
{
Server.Transfer("../FileNotFound.aspx");
}
//else if (Request.QueryString["__supplier_`_code"] != null)
//{
// Session["userid"] = Request.QueryString["__supplier_`_code"];
//}
uc_Purc_DepartmentListctp.SelectedValue = "0";
ctlPortListctp.SelectedValue = "0";
if (!string.IsNullOrWhiteSpace(Convert.ToString(Session["SUPPCODE"])) && Convert.ToString(Session["SUPPCODE"]) != "0")
{
uc_SupplierListCTP.SelectedValue = Convert.ToString(Session["SUPPCODE"]);
lblsupp.Enabled = false;
hlnkCreateNewContract.Visible = false;
btnCompare.Visible = false;
gvContractList.ShowFooter = false;
chkQtnStatus.Visible = false;
chkContractStatus.Visible = false;
}
else
{
uc_SupplierListCTP.SelectedValue = "0";
}
BindDataItems();
}
}
protected void BindPendingInvoiceGrid()
{
try
{
objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center");
objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Invoice Approved", "HeaderStyle-center");
int rowcount = ucCustomPager1.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dtType = ChkType();
string InvoiceStatus = null;
DataSet ds = BLL_POLOG_Invoice.POLOG_Get_Final_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue),
UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), InvoiceStatus, dtType, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection
, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount);
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
if (ds.Tables[0].Rows.Count > 0)
{
divApprovedPayment.Visible = false;
divPendingInvoice.Visible = true;
btnApprove.Visible = true;
gvPendingInvoice.DataSource = ds.Tables[0];
gvPendingInvoice.DataBind();
}
else
{
divApprovedPayment.Visible = false;
divPendingInvoice.Visible = false;
gvPendingInvoice.DataSource = ds.Tables[0];
gvPendingInvoice.DataBind();
}
}
catch { }
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["SCMID"];
string id1 = Request.QueryString["SCMID"].ToString();
string tabid = TabSCM.ActiveTab.ID;
string tabindex = TabSCM.ActiveTab.TabIndex.ToString();
if (!string.IsNullOrEmpty(Request.QueryString["SCMID"].ToString()))
{
BindSCMList();
}
UserAccessValidation();
BindSCMTabs();
}
mergeheadgvSfvs.AddMergedColumns(new int[] { 3, 4, 5 }, "Attendance", "HeaderStyle-css");
mergeheadgvSwpt.AddMergedColumns(new int[] { 3, 4, 5 }, "Attendance", "HeaderStyle-css");
mergeheadgvOrtg.AddMergedColumns(new int[] { 3, 4, 5 }, "Attendance", "HeaderStyle-css");
}
protected void Page_Load(object sender, EventArgs e)
{
UserAccessValidation();
if (!string.IsNullOrEmpty(Request.QueryString["Vessel_ID"]))
{
DataSet dsCapt = BLL_PB_PortageBill.ReportDetailsByID_Cur(Request.QueryString["ID"], Request.QueryString["Vessel_ID"]);
if (dsCapt.Tables[0].Rows.Count > 0)
{
lblVessel.Text = dsCapt.Tables[0].Rows[0]["Vessel_Name"].ToString();
lblFrom.Text = dsCapt.Tables[0].Rows[0]["from_date"].ToString();
lblTo.Text = dsCapt.Tables[0].Rows[0]["To_date"].ToString();
lblOpnBL.Text = dsCapt.Tables[0].Rows[0]["Opening_Bal"].ToString();
// lblClosing.Text = dsCapt.Tables[0].Rows[0]["Closing_Bal"].ToString();
lblClosing.Text = (Convert.ToDouble(dsCapt.Tables[0].Rows[0]["Opening_Bal"].ToString()) + Convert.ToDouble(dsCapt.Tables[0].Rows[0]["Total_Recp_Amount"].ToString()) - Convert.ToDouble(dsCapt.Tables[0].Rows[0]["Total_Payment_Amount"].ToString())).ToString();
objItemColumn.AddMergedColumns(new int[] { 5, 6 }, "Amount", "HeaderStyle-css");
gvCastCash.DataSource = dsCapt.Tables[0];
gvCastCash.DataBind();
gvCastCash.FooterRow.Cells[4].Text = "USD";
gvCastCash.FooterRow.Cells[3].Text = "Total :-";
gvCastCash.FooterRow.Cells[4].Style.Add("text-align", "center");
gvCastCash.FooterRow.Cells[3].Style.Add("text-align", "center");
gvCastCash.FooterRow.Cells[3].Style.Add("font-weight", "bold");
gvCastCash.FooterRow.Cells[4].Style.Add("font-weight", "bold");
gvCastCash.FooterRow.Cells[5].Style.Add("font-weight", "bold");
gvCastCash.FooterRow.Cells[6].Style.Add("font-weight", "bold");
(gvCastCash.FooterRow.FindControl("lblRcvdTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Recp_Amount"].ToString();
(gvCastCash.FooterRow.FindControl("lblPaidTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Payment_Amount"].ToString();
}
}
}