protected Boolean Validate(string sValue, string sDataType) { Boolean ret = true; string js = ""; switch (sDataType) { case "DATETIME": try { DateTime dt = DateTime.Parse(UDFLib.ConvertToDefaultDt(sValue)); ret = true; } catch { ret = false; js = "ShowNotification('Alert','Entered value is not a valid Date', true)"; } break; } if (js != "") { ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); } return(ret); }
protected void btnFindSignOffCrew_Click(object sender, EventArgs e) { string msg = ""; if (txtFromDt.Text.Trim() != "") { try { DateTime dt = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtFromDt.Text)); } catch { msg += "Enter Valid From Date\\n"; } } if (txtToDt.Text.Trim() != "") { try { DateTime dt = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtToDt.Text)); } catch { msg += "Enter Valid To Date\\n"; } } if (msg != "") { string js = "alert('" + msg + "')"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); return; } Search_SigningOff(); }
/// <summary> /// Description: Method to bind the grid based on search criteria /// </summary> protected void BindKPI() { string sStartDate = UDFLib.ConvertToDefaultDt(txtStartDate.Text); string sEndDate = UDFLib.ConvertToDefaultDt(txtEndDate.Text); //string sStartDate = txtStartDate.Text; //string sEndDate = txtEndDate.Text; try { if (sStartDate != "" && sEndDate != "") { DateTime Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); DataTable dt = objKPI.Get_NOx_Average((DataTable)Session["Vessel_Id"], Startdate, EndDate); ViewState["RecCount"] = dt.Rows.Count; rgdItems.DataSource = dt; rgdItems.DataBind(); hdnVessel_IDs.Value = null; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Description: Method to load data based on selected vessel and date range /// </summary> private void LoadData() { try { hdnVessel_IDs.Value = null; string Qtr = ""; string sStartDate = txtStartDate.Text; string sEndDate = txtEndDate.Text; if (sStartDate != "" && sEndDate != "") { DateTime StartDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); //ConvertToDefaultDt() method is used to change the user selected date format to the default format, the format in which date is saved in database. DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); //hdnLastMonth.Value = lastMonth; DataSet ds = objKPI.Get_Vetting_KPI_ByCompany(Qtr, 0, StartDate, EndDate); DataTable dt = ds.Tables[0]; string[] Pkey_cols = new string[] { "KPI_ID" }; string[] Hide_cols = new string[] { "ID", "Qtr_Start", "Qtr_End", "Code" }; DataTable dt1 = objKPI.PivotTable("Qtr", "KPI_Value", "", Pkey_cols, Hide_cols, dt); gvCompanyKPI.DataSource = dt1; gvCompanyKPI.DataBind(); IntializeControls(); string jsMethodName = null; jsMethodName = "$(document).ready(function () {searchInitialize();});"; ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "uniqueKey", jsMethodName, true); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
public void item_click(object sender, EventArgs e) { try { LinkButton lnkVessel = (LinkButton)sender; GridViewRow gvrSelected = (GridViewRow)lnkVessel.NamingContainer; foreach (GridViewRow gvr in gvCompanyKPI.Rows) { gvr.Cells[0].BackColor = System.Drawing.Color.White; } gvrSelected.Cells[0].BackColor = System.Drawing.Color.Yellow; HiddenField hdf = (HiddenField)gvrSelected.FindControl("hdKPIID"); HiddenField hdf2 = (HiddenField)gvrSelected.FindControl("hdnKpiName"); start_date = UDFLib.ConvertToDefaultDt(txtStartDate.Text); end_date = UDFLib.ConvertToDefaultDt(txtEndDate.Text); string jsMethodName = null; jsMethodName = "showChart2('" + Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)).ToString("yyyy-MM-dd") + "','" + Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)).ToString("yyyy-MM-dd") + "','" + hdf.Value + "','" + hdf2.Value + "')"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", jsMethodName, true); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
public void item_click(object sender, EventArgs e) { try { LinkButton lnkVessel = (LinkButton)sender; GridViewRow gvrSelected = (GridViewRow)lnkVessel.NamingContainer; foreach (GridViewRow gvr in gvPMSOverdue.Rows) { gvr.Cells[0].BackColor = System.Drawing.Color.White; } gvrSelected.Cells[0].BackColor = System.Drawing.Color.Yellow; HiddenField hdf = (HiddenField)gvrSelected.FindControl("hdVesselID"); hiddenStartDate.Value = UDFLib.ConvertToDefaultDt(txtStartDate.Text); hiddenEndDate.Value = UDFLib.ConvertToDefaultDt(txtEndDate.Text); string vesselname = lnkVessel.Text; string jsMethodName = null; jsMethodName = "showChart2('" + Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)).ToString("yyyy-MM-dd") + "','" + Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)).ToString("yyyy-MM-dd") + "','" + vesselname + "','" + hdf.Value + "')"; //ScriptManager.RegisterClientScriptBlock(this, typeof(string), "uniqueKey", jsMethodName, true); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", jsMethodName, true); } catch (Exception ex) { //UDFLib.WriteExceptionLog(ex); } }
protected void btnSaveRefererDetail_Click(object sender, EventArgs e) { string msg = ""; try { string js; int CrewID = GetCrewID(); DateTime Dt_ReferenceDate = DateTime.Parse(UDFLib.ConvertUserDateFormat(Convert.ToString("1900/01/01"))); try { if (txtReferenceDate.Text != "") { if (!UDFLib.DateCheck(txtReferenceDate.Text)) { js = "alert('Enter valid Reference Check Date" + UDFLib.DateFormatMessage() + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js, true); return; } } Dt_ReferenceDate = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtReferenceDate.Text.Trim())); } catch (Exception) { msg = "Enter valid Reference Check Date" + UDFLib.DateFormatMessage(); js = "alert('" + msg + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js, true); return; } if ((Dt_ReferenceDate > DateTime.Today)) { js = "alert('Reference Date cannot be greater than todays date.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js, true); } else if (Dt_ReferenceDate == Convert.ToDateTime("01/01/1900 ")) { js = "alert('Invalid Date entry in REFERENCE CHECK DATE field.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js, true); } else { objBLLCrew.Save_Crew_Reference_Details(0, CrewID, txtRefererName.Text.Trim(), txtRefererPhoneNo.Text.Trim(), Dt_ReferenceDate.ToShortDateString(), txtPersonQuieredName.Text.Trim(), txtPersonQuieredTitle.Text.Trim(), GetSessionUserID()); objDS_ReferenceDetail.SelectParameters["CrewID"].DefaultValue = CrewID.ToString(); objDS_ReferenceDetail.Select(); gdRefererDetails.DataBind(); pnlView_RefererDetails.Visible = true; pnlAdd_RefererDetails.Visible = false; js = "parent.GetInterviewResult(" + Request.QueryString["CrewID"].ToString() + ");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); } } catch (Exception) { } }
protected void Assign() { if (txtEventDate.Text.ToString() != "") { int EventID = objCrew.CREATE_CrewChangeEvent(VesselId, UDFLib.ConvertToDefaultDt(txtEventDate.Text).ToString(), 0, GetSessionUserID(), 0); if (EventID > 0) { DataSet ds = BLL_Crew_CrewList.Get_VesselTypeForCrewMatrix(VesselId); DataTable dtEventDate = ds.Tables[1]; ddlEvents.DataSource = dtEventDate; ddlEvents.DataBind(); ddlEvents.Items.Insert(0, new ListItem("- SELECT -", "0")); ddlEvents.SelectedValue = EventID.ToString(); txtEventDate.Text = ""; AddCrewToEvent(); } else if (EventID == -1) { string js = "alert('Event date is not inside the vessel arrival and departure dates!!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser", js, true); } } else { AddCrewToEvent(); } }
protected void btnsave_Click(object sender, EventArgs e) { DateTime Dt_EffectiveDate = DateTime.Parse("1900/01/01"); if (!UDFLib.DateCheck(txtEffectiveDate.Text)) { string js = "alert('Enter valid Date" + TodayDateFormat + "');" + String.Format("showModal('divadd',false);"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "DateFormat", js, true); return; } try { txtEffectiveDate.Text = txtEffectiveDate.Text != "" ? UDFLib.ConvertToDefaultDt(txtEffectiveDate.Text) : txtEffectiveDate.Text; if (HiddenFlag.Value == "Add") { int retval = objBLL.Insert_Crew_Contract_Withhold(UDFLib.ConvertToInteger(txtContractNumber.Text), UDFLib.ConvertDecimalToNull(txtAmount.Text), txtWithholdType.Text , UDFLib.ConvertToInteger(ddlEntryType.SelectedValue), UDFLib.ConvertDateToNull(txtEffectiveDate.Text), Convert.ToInt32(Session["USERID"])); } else { int retval = objBLL.Edit_Crew_Contract_Withhold(UDFLib.ConvertIntegerToNull(txtContractWithholdID.Text.Trim()), UDFLib.ConvertToInteger(txtContractNumber.Text) , UDFLib.ConvertDecimalToNull(txtAmount.Text), txtWithholdType.Text , UDFLib.ConvertToInteger(ddlEntryType.SelectedValue), UDFLib.ConvertDateToNull(txtEffectiveDate.Text), Convert.ToInt32(Session["USERID"])); } BindCrewWithhold(); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); } catch (Exception) { return; } }
protected void BindPortCallHistory(int Type, int?PortID, int?VesselID) { DateTime dateTime; if (!string.IsNullOrEmpty(txtStartDate.Text) && !string.IsNullOrEmpty(txtEndDate.Text)) { //This change has been done to validate the date format as per user selection if (DateTime.TryParseExact(txtStartDate.Text, DateFormat, CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime) && DateTime.TryParseExact(txtEndDate.Text, DateFormat, CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime)) { // Format your DateTime for valid date time error var from = UDFLib.ConvertToDefaultDt(txtStartDate.Text); var To = UDFLib.ConvertToDefaultDt(txtEndDate.Text); DateTime Startdate = Convert.ToDateTime(from); DateTime EndDate = Convert.ToDateTime(To); DataTable dt = objPortCall.Get_PortCallHistory(Type, PortID, VesselID, Startdate, EndDate, rdborder.SelectedValue); if (dt.Rows.Count > 0) { gvPortCallHistory.DataSource = dt; gvPortCallHistory.DataBind(); gvPortCallHistory.Visible = true; } else { gvPortCallHistory.DataSource = dt; gvPortCallHistory.DataBind(); } } } }
protected void btnSaveEOCEdit_Click(object sender, EventArgs e) { try { if (txtNewCOCDate.Text != "") { if (!UDFLib.DateCheck(txtNewCOCDate.Text)) { string js = "alert('Enter valid EOC Date" + UDFLib.DateFormatMessage() + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); return; } } int CrewID = UDFLib.ConvertToInteger(Request.QueryString["CrewID"]); int VoyID = UDFLib.ConvertToInteger(Request.QueryString["VoyID"]); if (VoyID != 0) { int RetVal = objBLLCrew.UPDATE_COC_Date(VoyID, UDFLib.ConvertToDefaultDt(Convert.ToString(txtNewCOCDate.Text)), txtCOCRemark.Text, GetSessionUserID()); if (RetVal == 1) { lblMsg.Text = "EOC Date Modified"; string js = "parent.GetCrewVoyages(" + CrewID.ToString() + ");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected Boolean ValidateEntry(string IssueDate, string ExpiryDate) { Boolean ret = true; string msg = ""; if (IssueDate == "") { ret = false; msg = "Issue Date is mandatory "; } if (IssueDate != "") { try { DateTime dt = DateTime.Parse(UDFLib.ConvertToDefaultDt(IssueDate)); } catch { ret = false; msg = "Enter valid ISSUE DATE" + CurrentDateFormatMessage; } } if (ExpiryDate != "") { try { DateTime dt = DateTime.Parse(UDFLib.ConvertToDefaultDt(ExpiryDate)); } catch { ret = false; msg = "Enter valid EXPIRY DATE" + CurrentDateFormatMessage; } } if (IssueDate != "" && ExpiryDate != "") { try { DateTime dtExpiryDate = DateTime.Parse(UDFLib.ConvertToDefaultDt(ExpiryDate)); DateTime dtIssueDate = DateTime.Parse(UDFLib.ConvertToDefaultDt(IssueDate)); if (dtIssueDate > dtExpiryDate) { ret = false; msg = "Issue date cannot be greater than Expiry date"; } } catch { ret = false; msg = "Invalid entry in DATE field."; } } if (msg != "") { string js = "alert('" + msg + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msgValidation", js, true); } return(ret); }
/// <summary> /// Description: Method to load data based on selected vessel and date range /// </summary> private void LoadData() { try { DataTable dt = (DataTable)Session["Vessel_Id"]; hdnVessel_IDs.Value = null; if (dt.Rows.Count != 0) { BindKPI(); Vessel_Ids = new string[dt.Rows.Count]; int i = 0; foreach (DataRow dr in dt.Rows) { Vessel_Ids[i] = dr[0].ToString(); hdnVessel_IDs.Value = hdnVessel_IDs.Value + "," + dr[0].ToString(); i++; } hdnVessel_IDs.Value = hdnVessel_IDs.Value.Trim(','); if (Convert.ToInt32(ViewState["RecCount"]) > 0) { divChart.Visible = true; if (CheckBox1.Checked != true) { btnVoyageChart.Visible = false; hdnStartDate.Value = ""; hdnEndDate.Value = ""; hdnStartDate.Value = UDFLib.ConvertToDefaultDt(txtStartDate.Text); hdnEndDate.Value = UDFLib.ConvertToDefaultDt(txtEndDate.Text); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", "showChart();", true); } else { btnVoyageChart.Visible = true; btnChart.Visible = false; } } else { btnVoyageChart.Visible = false; btnChart.Visible = false; divChart.Visible = false; } } else { string msg = String.Format("alert('Please select vessels')"); if (CheckBox1.Checked != true) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Description: If by voyage is selected , for all vessels voyage ddl wil populate based on search date /// </summary> protected void ddlVoyage_SelectedIndexChanged(object sender, EventArgs e) { try { DateTime?Startdate = null; //Startdate = Convert.ToDateTime(txtStartDate.Text); Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); DateTime?EndDate = null; //EndDate = Convert.ToDateTime(txtEndDate.Text); EndDate = Convert.ToDateTime(UDFLib.ConvertToDate(txtEndDate.Text)); DropDownList ddlVoyage = (DropDownList)sender; GridDataItem item = (GridDataItem)ddlVoyage.NamingContainer; Label txtSrno = (Label)item.FindControl("Vessel_Average"); HiddenField hdf = (HiddenField)item.FindControl("hdVesselID"); LinkButton lnkVessel = (LinkButton)item.FindControl("Item_Name"); if (ddlVoyage.SelectedIndex != 0) { string val = ddlVoyage.SelectedValue.Trim().Split(':')[0] + ":" + ddlVoyage.SelectedValue.Trim().Split(':')[1]; DataTable dtq = BLL_TMSA_PI.GetTelDate(val.Trim(), Convert.ToInt32(hdf.Value)).Tables[0]; if (dtq.Rows[0][0].ToString() != "") { Startdate = Convert.ToDateTime(dtq.Rows[0][1].ToString()); hiddenStartDate.Value = Startdate.Value.Date.ToString("dd-MM-yyyy"); } if (dtq.Rows[dtq.Rows.Count - 1][0].ToString() != "") { EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1][1].ToString()); hiddenEndDate.Value = EndDate.Value.Date.ToString("dd-MM-yyyy"); } } DataTable dt = BLL_TMSA_PI.GetVoyageDataNOx(ddlVoyage.SelectedValue.Trim(), Convert.ToInt32(hdf.Value)).Tables[0]; if (dt.Rows.Count > 0) { txtSrno.Text = Math.Round(Convert.ToDouble(dt.Rows[0]["Value"].ToString()), 2).ToString(); if (Convert.ToDouble(dt.Rows[0]["Value"]) == 0) { lnkVessel.Enabled = false; item["Vessel"].BackColor = System.Drawing.Color.White; } else { lnkVessel.Enabled = true; } } else { txtSrno.Text = "0"; lnkVessel.Enabled = false; item["Vessel"].BackColor = System.Drawing.Color.White; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void btnSaveCostItem_Click(object sender, EventArgs e) { try { string js; if (txtExp_Date.Text.Trim().Length == 0) { js = "alert('Date is not Valid!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); js = "showModal('dvPopupCostItem');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "updated1", js, true); UpdatePanel2.Update(); return; } else { try { DateTime dt = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtExp_Date.Text)); } catch { js = "alert('Enter valid Date" + TodayDateFormat + "')"; ScriptManager.RegisterStartupScript(this, this.GetType(), "scripts", js, true); js = "showModal('dvPopupCostItem');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "script2", js, true); UpdatePanel2.Update(); return; } } if (txtDesc.Text.ToString().Length == 0 || ddlExpType.SelectedIndex <= 0 || ddlLocalCurr.SelectedIndex == 0 || txtLocalAmt.Text.Trim().Length == 0) { js = "showModal('dvPopupCostItem');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "updated1", js, true); UpdatePanel2.Update(); return; } int Vessel_ID = UDFLib.ConvertToInteger(Request.QueryString["Vessel_ID"]); int Office_ID = UDFLib.ConvertToInteger(Request.QueryString["Office_ID"]); int Cost_Item_ID = BLL_Crew_MedHistory.INSERT_Med_Cost_Item(UDFLib.ConvertToInteger(hdnCaseID.Value), Vessel_ID, Office_ID, UDFLib.ConvertToDefaultDt(Convert.ToString(txtExp_Date.Text)), txtDesc.Text, UDFLib.ConvertToInteger(ddlExpType.SelectedValue), UDFLib.ConvertToInteger(ddlLocalCurr.SelectedValue), UDFLib.ConvertDecimalToNull(txtLocalAmt.Text), UDFLib.ConvertDecimalToNull(txtUSDAmt.Text), GetSessionUserID()); Upload_CostItemAttachments(Cost_Item_ID); Load_Crew_MedHistory_Details(UDFLib.ConvertToInteger(hdnCaseID.Value), Vessel_ID, Office_ID); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } finally { Session["MedicalCostItemAttachments"] = null; } }
protected void btnExport_Click(object sender, ImageClickEventArgs e) { try { if (checkVoyage.Checked == false) { if (txtStartDate.Text != "") { Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); } if (txtEndDate.Text != "") { EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); } DataTable dt = BLL_TMSA_PI.Search_PI_ValuesNOX(Convert.ToInt32(ddlvessel.SelectedValue), Convert.ToDateTime(txtStartDate.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(txtEndDate.Text).ToString("yyyy-MM-dd")).Tables[0]; string[] HeaderCaptions = { "Record_Date", "Value" }; string[] DataColumnsName = { "Record_Date", "Value" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "NOX Effeciency-" + ddlvessel.SelectedItem.Text, "NOX Effeciency-" + ddlvessel.SelectedItem.Text); } else { DataTable liTable = new DataTable(); if (listVoyage.Items.Count > 0) { for (int x = 0; x < listVoyage.Items.Count; x++) { //string v1 = listVoyage.Items[0].Value.Split(':')[1].Trim(); //string v2 = listVoyage.Items[listVoyage.Items.Count - 1].Value.Split(':')[0].Trim(); string val = listVoyage.Items[x].Value.Split(':')[0] + ":" + listVoyage.Items[x].Value.Split(':')[1]; DataTable dtq = BLL_TMSA_PI.GetTelDate(val.Trim(), Convert.ToInt32(ddlvessel.SelectedValue)).Tables[0]; if (dtq.Rows[0]["Telegram_Date_DDMM"].ToString() != "") { Startdate = Convert.ToDateTime(dtq.Rows[0]["Telegram_Date_DDMM"].ToString()); } if (dtq.Rows[dtq.Rows.Count - 1]["Telegram_Date_DDMM"].ToString() != "") { EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1]["Telegram_Date_DDMM"].ToString()); } DataTable dt = BLL_TMSA_PI.GetVoyageDataNOx(listVoyage.Items[x].Value.Trim(), Convert.ToInt32(ddlvessel.SelectedValue)).Tables[0]; liTable.Merge(dt); } string[] HeaderCaptions = { "From Port", "To Port", "Effective From", "Effective To", "Efficiency" }; string[] DataColumnsName = { "FromPort", "ToPort", "EffectiveFrom", "EffectiveTo", "Value" }; GridViewExportUtil.ExportToExcel(liTable, HeaderCaptions, DataColumnsName, "NOX Effeciency-" + ddlvessel.SelectedItem.Text, "NOX Effeciency(Voyage)-" + ddlvessel.SelectedItem.Text); } } } catch (Exception ex) { } }
protected void btnFilter_Click(object sender, ImageClickEventArgs e) { if (Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)) <= Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text))) { LoadData(); } else { string msg2 = String.Format("alert('Start Date should not be greater than End Date ')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true); } }
/// <summary> /// Method to export values displayed on the grid applying same search criteria /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, ImageClickEventArgs e) { try { hdnVessel_IDs.Value = null; string Qtr = ""; string sStartDate = txtStartDate.Text; string sEndDate = txtEndDate.Text; if (sStartDate != "" && sEndDate != "") { DateTime StartDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); //ConvertToDefaultDt() method is used to change the user selected date format to the default format, the format in which date is saved in database. DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); //hdnLastMonth.Value = lastMonth; DataSet ds = objKPI.Get_Vetting_KPI_ByCompany(Qtr, 0, StartDate, EndDate); DataTable dt = ds.Tables[0]; string[] Pkey_cols = new string[] { "KPI_ID" }; string[] Hide_cols = new string[] { "ID", "Qtr_Start", "Qtr_End", "Code" }; DataTable dt1 = objKPI.PivotTable("Qtr", "KPI_Value", "", Pkey_cols, Hide_cols, dt); string[] HeaderCaptions = new string[dt1.Columns.Count - 1]; string[] DataColumnsName = new string[dt1.Columns.Count - 1]; string ColumnName; int i = 0; foreach (DataColumn column in dt1.Columns) { ColumnName = column.ColumnName; if (ColumnName != "KPI_ID") { if (ColumnName == "KPI_Name") { HeaderCaptions[i] = "KPI Name"; } else { HeaderCaptions[i] = ColumnName; } DataColumnsName[i] = ColumnName; } i++; } GridViewExportUtil.ExportToExcel(dt1, HeaderCaptions, DataColumnsName, "Vetting Company KPIs", "Vetting Company KPIs"); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Method is called at the time of binding records from database to grid /// </summary> public void BindAccessGrid() { //string URL = String.Format("showprogressbar();"); //ScriptManager.RegisterStartupScript(Page, Page.GetType(), "URL", URL, true); try { int Count = ucCustomPagerItems.isCountRecord; //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()); } DateTime dt1 = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtFrom.Text)); DateTime dt2 = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtTo.Text)); string moduleName = ""; if ((ddlModule.SelectedItem == null) || (ddlModule.SelectedItem.ToString() == "-SELECT-")) { moduleName = ""; } else { moduleName = ddlModule.SelectedItem.ToString(); } DataSet dt = objMenuBLL.Get_AccessRightChanges(UDFLib.ConvertDateToNull(dt1), UDFLib.ConvertDateToNull(dt2), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, sortbycoloumn, sortdirection, UDFLib.ConvertIntegerToNull(ddlUser.SelectedValue), UDFLib.ConvertStringToNull(moduleName), txtPage.Text, int.Parse(Session["USERID"].ToString()), ref Count); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = Count.ToString(); ucCustomPagerItems.BuildPager(); } if (dt.Tables[0].Rows.Count > 0) { grdAccessReport.DataSource = dt; grdAccessReport.DataBind(); } else { grdAccessReport.DataSource = dt; grdAccessReport.DataBind(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void BindKPI() { string sStartDate = UDFLib.ConvertToDefaultDt(txtStartDate.Text); string sEndDate = UDFLib.ConvertToDefaultDt(txtEndDate.Text); if (sStartDate != "" && sEndDate != "") { DateTime Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); DataTable dt = objKPI.Get_SOx_Average((DataTable)Session["Vessel_Id"], Startdate, EndDate).Tables[0]; ViewState["RecCount"] = dt.Rows.Count; rgdItems.DataSource = dt; rgdItems.DataBind(); hdnVessel_IDs.Value = null; } }
/// <summary> /// Description: Method to bind the grid based on search criteria /// </summary> protected void BindKPI() { string sStartDate = UDFLib.ConvertToDefaultDt(txtStartDate.Text); string sEndDate = UDFLib.ConvertToDefaultDt(txtEndDate.Text); // string sStartDate = txtStartDate.Text; // string sEndDate = txtEndDate.Text; if (sStartDate != "" && sEndDate != "") { DateTime Startdate = Convert.ToDateTime(sStartDate); DateTime EndDate = Convert.ToDateTime(sEndDate); DataTable dt = objKPI.Get_CO2_Average((DataTable)Session["Vessel_Id"], Startdate, EndDate); ViewState["RecCount"] = dt.Rows.Count; hdnVessel_IDs.Value = null; } }
protected void rgdItems_ItemDataBound(object sender, GridItemEventArgs e) { foreach (GridDataItem dataItem in rgdItems.MasterTableView.Items) { try { DropDownList ddlVoyage = (DropDownList)dataItem.FindControl("ddlVoyage"); HiddenField hdVoyage = (HiddenField)dataItem.FindControl("hdVoyage"); HiddenField hdVesselID = (HiddenField)dataItem.FindControl("hdVesselID"); LinkButton lnkVessel = (LinkButton)dataItem.FindControl("Item_Name"); if (hdVesselID.Value != null && CheckBox1.Checked == true) { Label Vessel_Average = (Label)dataItem.FindControl("Vessel_Average"); Vessel_Average.Text = "0"; ddlVoyage.Enabled = true; int Vessel_Id = Convert.ToInt32(hdVesselID.Value); if (txtStartDate.Text != "" && txtEndDate.Text != "") { //DateTime Startdate = Convert.ToDateTime(txtStartDate.Text); //DateTime EndDate = Convert.ToDateTime(txtEndDate.Text); DateTime Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); DataTable dt = objKPI.GetVoyageList(Vessel_Id, Startdate, EndDate); ddlVoyage.DataSource = dt; ddlVoyage.DataTextField = "VOYAGE"; ddlVoyage.DataValueField = "TelID"; ddlVoyage.DataBind(); ddlVoyage.Items.Insert(0, new ListItem("-Select-", "0")); } } Label avg = (Label)dataItem.FindControl("Vessel_Average"); if (Convert.ToDouble(avg.Text) == 0) { lnkVessel.Enabled = false; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } } }
protected void bindVoyage() { BLL_TMSA_KPI objKPI = new BLL_TMSA_KPI(); int Vessel_Id = Convert.ToInt32(ddlvessel.SelectedValue); if (txtStartDate.Text != "" && txtEndDate.Text != "") { DateTime Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); DataTable dt = objKPI.GetVoyageList(Vessel_Id, Startdate, EndDate); ddlVoyage.DataSource = dt; ddlVoyage.DataTextField = "VOYAGE"; ddlVoyage.DataValueField = "TelID"; ddlVoyage.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { CalStartDate.Format = UDFLib.GetDateFormat(); //Display the selected date from datepicker as in the same format which has been selected by the user. CalEndDate.Format = UDFLib.GetDateFormat(); // UserAccessValidation(); if (!IsPostBack) { txtStartDate.Text = DateTime.Now.AddYears(-1).ToString(UDFLib.GetDateFormat()); txtEndDate.Text = DateTime.Now.ToString(UDFLib.GetDateFormat()); hiddenStartDate.Value = UDFLib.ConvertToDefaultDt(txtStartDate.Text); hiddenEndDate.Value = UDFLib.ConvertToDefaultDt(txtEndDate.Text); //LoadKPIList(); LoadData(); IntializeControls(); loadPIDetails(); GenearteDiv(); } }
/// <summary> /// Default EOC months is set in Contract period library page according to Ranks.If not set txtCOCDate will be blanck /// </summary> protected void txtJoiningDate_TextChanged(object sender, EventArgs e) { int Joining_Rank = UDFLib.ConvertToInteger(((DropDownList)gvSignOnCrew.Rows[0].FindControl("ddlRank")).SelectedValue); string Joining_Date = ((TextBox)gvSignOnCrew.Rows[0].FindControl("txtJoinDate")).Text; try { DateTime.Parse(UDFLib.ConvertToDefaultDt(Joining_Date)); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "$('#gvSignOnCrew_ctl02_txtCOCDate').val('');alert('Enter valid Joining Date" + UDFLib.DateFormatMessage() + "');", true); return; } if (Joining_Rank > 0) { if (Joining_Date != "") { int Days = 0; try { DataTable dt = new DataTable(); dt = objBLLInfra.Get_Crew_Contract_Period_List(Joining_Rank); if (dt.Rows.Count > 0 && dt.Rows[0]["Days"].ToString() != "") { Days = int.Parse(dt.Rows[0]["Days"].ToString()); } if (Days > 0) { ((TextBox)gvSignOnCrew.Rows[0].FindControl("txtCOCDate")).Text = DateTime.Parse(UDFLib.ConvertToDefaultDt(Joining_Date)).AddDays(Days).ToString(DateFormat); } } catch { string js = "parent.ShowNotification('Alert','Enter valid Joining Date" + UDFLib.DateFormatMessage() + "',true)"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); } } } }
protected void btnportfilter_Click(object sender, ImageClickEventArgs e) { if (ddlvessel.SelectedIndex != 0 && !string.IsNullOrEmpty(txtEndDate.Text) && !string.IsNullOrEmpty(txtStartDate.Text)) { if (Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)) <= Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text))) { if (checkVoyage.Checked) { bindVoyage(); BindVoyageData(); gvSearch.Visible = false; gvVoyage.Visible = true; imgADD.Enabled = true; divVoyage.Visible = true; } else { bindgvSearch(); gvSearch.Visible = true; gvVoyage.Visible = false; imgADD.Enabled = false; } ImgComp.Visible = true; listVoyage.Items.Clear(); int KPI_ID = 1; } else { clear(); string msg2 = String.Format("alert('Start Date should not be greater than End Date ')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true); } } else { clear(); string msg2 = String.Format("alert('Vessel/StartDate/EndDate should not be blank')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true); } }
protected void Page_Load(object sender, EventArgs e) { CalStartDate.Format = UDFLib.GetDateFormat(); //Display the selected date from datepicker as in the same format which has been selected by the user. CalEndDate.Format = UDFLib.GetDateFormat(); UserAccessValidation(); if (!IsPostBack) { txtStartDate.Text = DateTime.Now.AddDays(-30).ToString(UDFLib.GetDateFormat()); txtEndDate.Text = DateTime.Now.ToString(UDFLib.GetDateFormat()); //txtStartDate.Text = DateTime.Now.AddDays(-30).ToString("dd-MM-yyyy"); //txtEndDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); hiddenStartDate.Value = UDFLib.ConvertToDefaultDt(txtStartDate.Text); hiddenEndDate.Value = UDFLib.ConvertToDefaultDt(txtEndDate.Text); BindVesselList(); loadFormula(); bindgvSearch(); gvSearch.Visible = true; } }
/// <summary> /// Method use to intialize the default Quarter and Default KPI for selected /// </summary> protected void IntializeControls() { DataTable dt = objKPI.Get_Vetting_KPI_List(); int firstKPI_Id = 0; string Kpi_Name = ""; if (dt.Rows.Count > 0) { firstKPI_Id = Convert.ToInt16(dt.Rows[0]["KPI_ID"]); Kpi_Name = dt.Rows[0]["Name"].ToString(); ViewState["KPI_ID"] = firstKPI_Id; hdnKpi_ID.Value = firstKPI_Id.ToString(); hdnKpi_Name.Value = Kpi_Name; DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)); int IMonth = 0; int Year = 2017; int Qtr = 1; IMonth = EndDate.Month; Year = EndDate.Year; if (IMonth < 4) { Qtr = 1; } else if ((IMonth > 3 && IMonth <= 6)) { Qtr = 2; } else if ((IMonth > 6 && IMonth <= 9)) { Qtr = 3; } else { Qtr = 4; } hdnQtr.Value = "Q" + Qtr.ToString() + "-" + Year.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { CalStartDate.Format = UDFLib.GetDateFormat(); //Display the selected date from datepicker as in the same format which has been selected by the user. CalEndDate.Format = UDFLib.GetDateFormat(); UserAccessValidation(); if (!IsPostBack) { txtStartDate.Text = DateTime.Now.AddDays(-30).ToString(UDFLib.GetDateFormat()); txtEndDate.Text = DateTime.Now.ToString(UDFLib.GetDateFormat()); //txtStartDate.Text = DateTime.Now.AddDays(-30).ToString("dd-MM-yyyy"); //txtEndDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); hdnStartDate.Value = UDFLib.ConvertToDefaultDt(txtStartDate.Text); hdnEndDate.Value = UDFLib.ConvertToDefaultDt(txtEndDate.Text); BindFleetDLL(); Load_VesselList(); LoadData(); loadPIDetails(); } }
private void LoadData() { DataTable dt = (DataTable)Session["Vessel_Id"]; hdnVessel_IDs.Value = null; hiddenStart.Value = UDFLib.ConvertToDefaultDt(txtStartDate.Text); //ConvertToDefaultDt() method is used to change the user selected date format to the default format, the format in which date is saved in database. hiddenEnd.Value = UDFLib.ConvertToDefaultDt(txtEndDate.Text); if (dt.Rows.Count != 0) { Vessel_Ids = new string[dt.Rows.Count]; int i = 0; foreach (DataRow dr in dt.Rows) { Vessel_Ids[i] = dr[0].ToString(); hdnVessel_IDs.Value = hdnVessel_IDs.Value + "," + dr[0].ToString(); i++; } hdnVessel_IDs.Value = hdnVessel_IDs.Value.Trim(','); if (ViewState["SelectedTab"] != null) { if (Convert.ToInt32(ViewState["SelectedTab"]) == 2) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", "showChart(2);", true); } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", "showChart(1);", true); } } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", "showChart(1);", true); } } else { string msg = String.Format("alert('Please select vessels.')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); } }