public DataSet Get_SurvayList(int FleetID, int VesselID, int MainCategoryId, int CategoryID, int CertificateID, string IssueFrom, string IssueTo, string ExpFrom, string ExpTo, int ExpiryInDays, int Verified, string SearchText, Boolean ShowAll, string CatIDList, int?PAGE_SIZE, int?PAGE_INDEX, int?SelectRecordCount) { DateTime dt = DateTime.Parse("1900/01/01"); DateTime dt1 = DateTime.Parse("9999/01/01"); DateTime dtIssueFrom = IssueFrom == "" ? dt : UDFLib.ConvertToDate(IssueFrom, UDFLib.GetDateFormat()); DateTime dtIssueTo = IssueTo == "" ? dt1 : UDFLib.ConvertToDate(IssueTo, UDFLib.GetDateFormat()); DateTime dtExpFrom = ExpFrom == "" ? dt : UDFLib.ConvertToDate(ExpFrom, UDFLib.GetDateFormat()); DateTime dtExpTo = ExpTo == "" ? dt1 : UDFLib.ConvertToDate(ExpTo, UDFLib.GetDateFormat()); //Overdue = -1 //Custom Dates =0 if (ExpiryInDays == -1) { //Overdue dtExpTo = UDFLib.ConvertToDate(DateTime.Today.ToString(UDFLib.GetDateFormat()), UDFLib.GetDateFormat()).AddDays(1); } else if (ExpiryInDays == 0) { //Custom Dates } else { //30, 60, 90 days //dtExpFrom = DateTime.Parse(DateTime.Today.ToString("yyyy/MM/dd")); - Changed on 05/05/2011 dtExpTo = UDFLib.ConvertToDate(DateTime.Today.ToString(UDFLib.GetDateFormat()), UDFLib.GetDateFormat()).AddDays(ExpiryInDays); } return(objDLL.Get_SurvayList_DL(FleetID, VesselID, MainCategoryId, CategoryID, CertificateID, dtIssueFrom, dtIssueTo, dtExpFrom, dtExpTo, Verified, SearchText, ExpiryInDays, ShowAll, CatIDList, PAGE_SIZE, PAGE_INDEX, SelectRecordCount)); }
/// <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 btnSavePlanning_Click(object sender, EventArgs e) { try { int iCrewID = int.Parse(hdnCrewID.Value); if (iCrewID == 0) { lblMessage.Text = "Please select a crew from the above list to plan an Briefing"; return; } if (int.Parse(ddlPlanInterviewer.SelectedValue) == 0) { lblMessage.Text = "Please Select Briefer"; return; } if (txtPlanDate.Text.Trim().Equals("")) { lblMessage.Text = "Please Enter Date" + TodayDateFormat; return; } if (int.Parse(ddlInterviewSheet.SelectedValue) == 0) { lblMessage.Text = "Please Select Briefing Sheet"; return; } string PlanDateTime = UDFLib.ConvertToDate(txtPlanDate.Text, UDFLib.GetDateFormat()).ToShortDateString() + " " + ddlPlanH.Text + ":" + ddlPlanM.Text; if (int.Parse(ddlPlanH.Text) < 12) { PlanDateTime += " AM"; } else { PlanDateTime += " PM"; } string TimeZone = ddlTimeZone.SelectedValue; int iInterviewID = objCrewBLL.INS_CrewInterviewPlanning(iCrewID, 0, txtPlanCrewName.Text, PlanDateTime, int.Parse(ddlPlanInterviewer.SelectedValue), "", GetSessionUserID(), TimeZone, "Briefing", int.Parse(ddlInterviewSheet.SelectedValue)); gvCrewBriefPlan.DataBind(); hdnInterviewID.Value = iInterviewID.ToString(); if (iInterviewID > 0) { lblMessage.Text = "Briefing planned for " + txtPlanCrewName.Text; SendMail_InterviewPlanning(iInterviewID); string js = "parent.GetInterviewResult(" + iCrewID + ");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); } else { lblMessage.Text = "Briefing already planned for " + txtPlanCrewName.Text + " at same time " + PlanDateTime; } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
/// <summary> /// Check if any reqsn with same catalogue in Draft mode. /// </summary> protected void CreateNewRequisition() { using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase()) { IventoryItemData objDoInventory = new IventoryItemData(); objDoInventory.POType = ddlPOType.SelectedValue.ToString(); objDoInventory.VesselCode = ddlVessel.SelectedValue.ToString(); objDoInventory.Department = ddlFunction.SelectedValue.ToString(); objDoInventory.DocumentNumber = "1"; objDoInventory.Totalitem = 0; objDoInventory.LineType = "R"; objDoInventory.CreatedBy = GetSessionUserID().ToString(); objDoInventory.UserName = GetSessionUserName().ToString().Split(new char[] { ' ' })[0]; objDoInventory.UrgencyCode = ddlUrgency.SelectedValue; objDoInventory.Account_Type = ddlAccountType.SelectedValue; objDoInventory.RequisitionType = ddlReqsnType.SelectedValue; objDoInventory.SystemCode = ddlCatalogue.SelectedValue; if (ddlDeliveryPort.SelectedValue != "0" && ddlDeliveryPort.SelectedValue != "") { objDoInventory.Delivery_Port = Convert.ToInt16(ddlDeliveryPort.SelectedValue);//Convert.ToInt16(Session["DeliveryPort"]); } else { objDoInventory.Delivery_Port = 0; } objDoInventory.Delivery_Date = UDFLib.ConvertToDate(txtDeliveryDate.Text); objDoInventory.Port_Call = Convert.ToInt16(ddlPortCall.SelectedValue); objDoInventory.Owner_Code = ddlOwnerName.SelectedValue; DataSet ds = BLL_PURC_Common.PURC_Checking_Requisition(objDoInventory); if (ds.Tables[0].Rows.Count > 0) { pnlViewRequisition.Visible = true; pnlNewRequisition.Visible = false; ddlRequisitionList.DataSource = ds.Tables[0]; ddlRequisitionList.DataTextField = "requisition_code"; ddlRequisitionList.DataValueField = "DOCUMENT_CODE"; ddlRequisitionList.DataBind(); ddlRequisitionList.Items.Insert(0, new ListItem("-SELECT-", "0")); ddlRequisitionList.SelectedIndex = 0; BindRequisition(ddlRequisitionList.SelectedValue); } else { string ReturenID = objTechService.GenerateRequisitionNumber(objDoInventory); if (ReturenID != "") //(dtReqsn_DocumentCode.Rows.Count >0) { ViewState["flt_DocumentCode"] = ReturenID; //Convert.ToString(dt.Rows[0]["DOCUMENT_CODE"]); Session["DocumentCode"] = ReturenID; Response.Redirect("PURC_Reqn_Items.aspx?DocumentCode=" + ViewState["flt_DocumentCode"] + ""); } } } }
protected void ObjectDataSource2_Updating(object sender, ObjectDataSourceMethodEventArgs e) { try { e.InputParameters["REFERENCE_DATE"] = UDFLib.ConvertToDate(e.InputParameters["REFERENCE_DATE"].ToString()).ToShortDateString(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void ImgExportToExcel_Click(object sender, EventArgs e) { string Sign_On_From = ""; string Sign_On_To = ""; string SearchString = txtSearch.Text; int TotalDays = 0; int PAGE_SIZE = -1; int PAGE_INDEX = -1; int SelectRecordCount = 0; int FleetCode = UDFLib.ConvertToInteger(ddlFleet.SelectedValue); int VesselID = UDFLib.ConvertToInteger(ddlVessel.SelectedValue); if (txtSignOnFrom.Text != "") { Sign_On_From = UDFLib.ConvertToDate(Convert.ToString(txtSignOnFrom.Text), UDFLib.GetDateFormat()).ToString(); } if (txtSignOnTo.Text != "") { Sign_On_To = UDFLib.ConvertToDate(Convert.ToString(txtSignOnTo.Text), UDFLib.GetDateFormat()).ToString(); } DataTable dt = BLL_Crew_CrewList.Get_Super_Att_Vessel_Report(FleetCode, VesselID, Sign_On_From, Sign_On_To, SearchString, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, ref TotalDays); dt.Columns.Add("Joining_Date1"); dt.Columns.Add("Sign_On_Date1"); dt.Columns.Add("Sign_Off_Date1"); foreach (DataRow dr in dt.Rows) { if (dr["Joining_Date"].ToString() != "" && dr["Joining_Date"] != null) { dr["Joining_Date1"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dr["Joining_Date"]), Convert.ToString(Session["User_DateFormat"])); } if (dr["Sign_On_Date"].ToString() != "" && dr["Sign_On_Date"] != null) { dr["Sign_On_Date1"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dr["Sign_On_Date"])); } if (dr["Sign_Off_Date"].ToString() != "" && dr["Sign_Off_Date"] != null) { dr["Sign_Off_Date1"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dr["Sign_Off_Date"])); } } dt.AcceptChanges(); string[] HeaderCaptions = { "Vessel", "S/Code", "Name", "Rank", "Contract Date", "S/On Date", "S/Off Date", "Days ONBD" }; string[] DataColumnsName = { "Vessel_Short_Name", "Staff_Code", "Staff_Name", "Rank_Short_Name", "Joining_Date1", "Sign_On_Date1", "Sign_Off_Date1", "DaysOnBoard" }; GridViewExportUtil.ExportToExcel(dt, HeaderCaptions, DataColumnsName, "Superintendents_attending_vessels.xls", "Superintendents attending vessels Report"); }
protected void BindRJBGrid() { DateTime dtFrom = DateTime.Parse("1900/01/01"); DateTime dtTo = DateTime.Parse("2900/01/01"); if (txtSearchJoinFromDate.Text != "") { dtFrom = UDFLib.ConvertToDate(txtSearchJoinFromDate.Text.ToString(), UDFLib.GetDateFormat()); } if (txtSearchJoinToDate.Text != "") { dtTo = UDFLib.ConvertToDate(txtSearchJoinToDate.Text.ToString(), UDFLib.GetDateFormat()); } DateTime dtExpectFrom = DateTime.Parse("1900/01/01"); DateTime dtExpectTo = DateTime.Parse("2900/01/01"); if (txtExpectedFromDate.Text != "") { dtExpectFrom = UDFLib.ConvertToDate(txtExpectedFromDate.Text.ToString(), UDFLib.GetDateFormat()); } if (txtExpectedToDate.Text != "") { dtExpectTo = UDFLib.ConvertToDate(txtExpectedToDate.Text.ToString(), UDFLib.GetDateFormat()); } int PAGE_SIZE = ucCustomPagerItems.PageSize; int PAGE_INDEX = ucCustomPagerItems.CurrentPageIndex; int SelectRecordCount = 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 = objCrew.Get_RJBList_Index(UDFLib.ConvertIntegerToNull(ddlRank.SelectedValue), UDFLib.ConvertIntegerToNull(ddlStaus.SelectedValue), dtFrom.ToString("yyyy/MM/dd"), dtTo.ToString("yyyy/MM/dd"), UDFLib.ConvertIntegerToNull(ddlCurrentVessel.SelectedValue), dtExpectFrom.ToString("yyyy/MM/dd"), dtExpectTo.ToString("yyyy/MM/dd"), txtSearchText.Text.Trim(), GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection); GridView1.DataSource = dt; GridView1.DataBind(); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = SelectRecordCount.ToString(); ucCustomPagerItems.BuildPager(); } }
protected void ObjectDataSource2_Updating(object sender, ObjectDataSourceMethodEventArgs e) { if (e.InputParameters["InterviewPlanDate"].ToString() != null) { if (!UDFLib.DateCheck(e.InputParameters["InterviewPlanDate"].ToString())) { ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError2", "alert('Enter valid Date" + UDFLib.DateFormatMessage() + "');", true); return; } } e.InputParameters["InterviewPlanDate"] = UDFLib.ConvertToDate(e.InputParameters["InterviewPlanDate"].ToString()).ToShortDateString(); InterviewID = int.Parse(e.InputParameters["Id"].ToString()); }
protected DataTable GetSearchDataTable() { DataTable dtFilters = new DataTable(); dtFilters.Columns.Add("VesselManager", typeof(int)); dtFilters.Columns.Add("Fleet", typeof(int)); dtFilters.Columns.Add("Vessel", typeof(int)); dtFilters.Columns.Add("RankID", typeof(int)); dtFilters.Columns.Add("Nationality", typeof(int)); dtFilters.Columns.Add("Status", typeof(int)); dtFilters.Columns.Add("CalculatedStatus", typeof(int)); dtFilters.Columns.Add("ManningOfficeID", typeof(int)); dtFilters.Columns.Add("EOCDueIn", typeof(int)); dtFilters.Columns.Add("JoiningDateFrom", typeof(String)); dtFilters.Columns.Add("JoiningDateTo", typeof(String)); dtFilters.Columns.Add("SearchText", typeof(String)); DateTime dtFrom = DateTime.Parse("1900/01/01"); DateTime dtTo = DateTime.Parse("2900/01/01"); if (txtSearchJoinFromDate.Text != "") { dtFrom = UDFLib.ConvertToDate(Convert.ToString(txtSearchJoinFromDate.Text), UDFLib.GetDateFormat()); } if (txtSearchJoinToDate.Text != "") { dtTo = UDFLib.ConvertToDate(Convert.ToString(txtSearchJoinToDate.Text), UDFLib.GetDateFormat()); } dtFilters.Rows.Add( 1, UDFLib.ConvertToInteger(ddlFleet.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlVessel.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlRank.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlCountry.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlMainStatus.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlCalculatedStatus.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlManningOffice.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlCOC.SelectedValue.ToString()), dtFrom.ToString("yyyy/MM/dd"), dtTo.ToString("yyyy/MM/dd"), txtSearchText.Text); return(dtFilters); }
protected void Page_Load(object sender, EventArgs e) { try { DateFormat = UDFLib.GetDateFormat(); calFromDate.Format = calToDate.Format = UDFLib.GetDateFormat(); if (Request.QueryString.Count != 0) { if (Request.QueryString["VesselId"] != null && Request.QueryString["VesselId"] != "") { VesselId = Convert.ToInt16(Request.QueryString["VesselId"].ToString()); } if (Request.QueryString["InspectionType"] != null && Request.QueryString["InspectionType"] != "") { InspectionType = Request.QueryString["InspectionType"].ToString(); } } if (!IsPostBack) { if (Request.QueryString.Count != 0) { if (Request.QueryString["Status"] != null && Request.QueryString["Status"] != "") { Status = Request.QueryString["Status"].ToString(); } if (Request.QueryString["IssueDate"] != null && Request.QueryString["IssueDate"] != "") { IssueDate = UDFLib.ConvertToDate(Request.QueryString["IssueDate"].ToString()); txtInspectionFromDate.Text = UDFLib.ConvertUserDateFormat(IssueDate.ToShortDateString(), DateFormat); } } BindPort(); ddlStatus.ClearSelection(); ddlStatus.Items.FindByValue(Status).Selected = true; DataSet ds = objInsp.Get_Current_Schedules(Status, VesselId, IssueDate.ToShortDateString().Equals("01/01/0001") ? null : UDFLib.ConvertDateToNull(IssueDate), null, 0); gvInspectionSchedule.DataSource = ds.Tables[0]; gvInspectionSchedule.DataBind(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected string CalculatedExpiryDate(string DateOfExpiry, string ExtensionDate, int GraceRange) { string RangeMax = "", MaxDate = ""; if (DateOfExpiry != "") { MaxDate = DateOfExpiry; RangeMax = UDFLib.ConvertToDate(DateOfExpiry).AddDays((GraceRange * 30 / 2)).ToString(UDFLib.GetDateFormat()); if (GraceRange > 0 && RangeMax != "") { MaxDate = UDFLib.ConvertToDate(MaxDate) > UDFLib.ConvertToDate(RangeMax) ? MaxDate : RangeMax; } if (ExtensionDate != "") { MaxDate = UDFLib.ConvertToDate(MaxDate) > UDFLib.ConvertToDate(ExtensionDate) ? MaxDate : ExtensionDate; } } return(MaxDate); }
protected void Load_Report() { int FleetCode = UDFLib.ConvertToInteger(ddlFleet.SelectedValue); int VesselID = UDFLib.ConvertToInteger(ddlVessel.SelectedValue); string Sign_On_From = ""; string Sign_On_To = ""; if (txtSignOnFrom.Text != "") { Sign_On_From = UDFLib.ConvertToDate(Convert.ToString(txtSignOnFrom.Text), UDFLib.GetDateFormat()).ToString(); } if (txtSignOnTo.Text != "") { Sign_On_To = UDFLib.ConvertToDate(Convert.ToString(txtSignOnTo.Text), UDFLib.GetDateFormat()).ToString(); } string SearchString = txtSearch.Text; int PAGE_SIZE = ucCustomPager_CrewList.PageSize; int PAGE_INDEX = ucCustomPager_CrewList.CurrentPageIndex; int SelectRecordCount = ucCustomPager_CrewList.isCountRecord; int TotalDays = 0; DataTable dt = BLL_Crew_CrewList.Get_Super_Att_Vessel_Report(FleetCode, VesselID, Sign_On_From, Sign_On_To, SearchString, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, ref TotalDays); if (ucCustomPager_CrewList.isCountRecord == 1) { ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_CrewList.BuildPager(); } GridView_Crew.DataSource = dt; GridView_Crew.DataBind(); lblGrandTotal.Text = TotalDays.ToString(); }
protected void gvSeniorityRecords_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { lblmsg.Text = ""; int CrewID = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[0].ToString()); int CompanySeniorityYear = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[1].ToString()); int CompanySeniorityDays = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[2].ToString()); int CompanySeniorityYear_New = UDFLib.ConvertToInteger(e.NewValues["CompanySeniorityYear"]); int CompanySeniorityDays_New = UDFLib.ConvertToInteger(e.NewValues["CompanySeniorityDays"]); string Remarks = "Updating Company Seniority first time for existing crews"; DateTime CompanyEffectiveDate_New; if ((CompanySeniorityYear_New > 0 || CompanySeniorityDays_New > 0) && (CompanySeniorityYear != CompanySeniorityYear_New || CompanySeniorityDays != CompanySeniorityDays_New)) { if (CompanySeniorityDays_New > 364) { lblmsg.Text = "Company Seniority Days cannot be greater than 364"; } if (e.NewValues["CompanyEffective_date"] != null) { CompanyEffectiveDate_New = UDFLib.ConvertToDate(Convert.ToString(e.NewValues["CompanyEffective_date"]), UDFLib.GetDateFormat()); BLL_PortageBill.Update_CrewCompanySeniority(CrewID, CompanySeniorityYear_New, CompanySeniorityDays_New, Remarks, CompanyEffectiveDate_New, Convert.ToInt32(Session["userid"])); } else { lblmsg.Text = "Company Effective Date is mandatory to update Company Seniority"; } } int RankSeniorityYear = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[3].ToString()); int RankSeniorityDays = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[4].ToString()); int RankSeniorityYear_New = UDFLib.ConvertToInteger(e.NewValues["RankSeniorityYear"]); int RankSeniorityDays_New = UDFLib.ConvertToInteger(e.NewValues["RankSeniorityDays"]); Remarks = "Updating Rank Seniority first time for existing crews"; if ((RankSeniorityYear_New > 0 || RankSeniorityDays_New > 0) && (RankSeniorityYear != RankSeniorityYear_New || RankSeniorityDays != RankSeniorityDays_New)) { GridViewRow row = (GridViewRow)gvSeniorityRecords.Rows[e.RowIndex]; int RankId1 = int.Parse(((DropDownList)row.FindControl("ddlSeniorityRank")).SelectedValue.ToString()); if (RankSeniorityDays_New > 364) { lblmsg.Text = "Rank Seniority Days cannot be greater than 364"; } if (e.NewValues["RankEffective_date"] != null) { BLL_PortageBill.Update_CrewRankSeniority(CrewID, RankId1, RankSeniorityYear_New, RankSeniorityDays_New, 0, Remarks, UDFLib.ConvertToDate(e.NewValues["RankEffective_date"].ToString(), UDFLib.GetDateFormat()), Convert.ToInt32(Session["userid"])); } else { lblmsg.Text = "Rank Effective Date is mandatory to update Rank Seniority"; } } if (lblmsg.Text.Trim() == "") { lblmsg.Visible = false; gvSeniorityRecords.EditIndex = -1; Load_SeniorityRecords(); } else { lblmsg.Visible = true; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
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_Kitty_Export(txtSatatus.Text != "" ? txtSatatus.Text : null, null, txtTitle.Text != "" ? txtTitle.Text : null, null, null, null, (DataTable)Session["sVesselCode"], UDFLib.ConvertToDate(txtFromDate.Text.Trim(), UDFLib.GetDateFormat()).ToShortDateString(), UDFLib.ConvertToDate(txtToDate.Text.Trim(), UDFLib.GetDateFormat()).ToShortDateString(), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize); 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"])); } string[] HeaderCaptions = { "Vessel Name", "Request Date", "Card Number", "Card Pin", "Unit", "Title", "Sub Title", "Supplier ", "Voyage" }; string[] DataColumnsName = { "VESSEL_NAME", "DATE_OF_CREATION", "CARD_NUM", "CARD_PIN", "CARD_UNITS", "TITLE", "SUBTITLE", "Full_NAME", "STAFF_NAME" }; GridViewExportUtil.ExportToExcel(dt, HeaderCaptions, DataColumnsName, "KittyList", "Kitty List"); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Bind all records of vetting /// </summary> public void Bind_VettingIndex() { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); DataSet ds = new DataSet(); 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()); } int IsValid = 0; DataTable dtEXInspector = new DataTable(); dtEXInspector.Columns.Add("ID"); DataTable dtInspector = new DataTable(); dtInspector.Columns.Add("ID"); foreach (DataRow dr in DDLInspector.SelectedValues.Rows) { if (dr[0].ToString().Split('_')[1] == "In") { dtInspector.Rows.Add(dr[0].ToString().Split('_')[0]); } if (dr[0].ToString().Split('_')[1] == "Ex") { dtEXInspector.Rows.Add(dr[0].ToString().Split('_')[0]); } } DateTime?VetFromDate, VetToDate; VetFromDate = txtLVetFromDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLVetFromDate.Text)); VetToDate = txtLVetToDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLVetToDate.Text)); if (rbtnValid.Checked == true) { IsValid = 1; } ds = objBLLIndx.VET_Get_VettingIndex(DDLVessel.SelectedValues, DDLVetType.SelectedValues, DDLStatus.SelectedValues, txtDueDays.Text == "0" ? UDFLib.ConvertToInteger(txtDueDays.Text.Trim()) : UDFLib.ConvertIntegerToNull(txtDueDays.Text.Trim()), IsValid, UDFLib.ConvertToInteger(rbtnObservation.SelectedValue), DDLOilMajor.SelectedValues, dtInspector, dtEXInspector, VetFromDate, VetToDate, DDLJobStatus.SelectedValues, txtVessel.Text != "" ? txtVessel.Text.Trim() : null, sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ds.Tables.Count > 0) { ViewState["dtObservationCount"] = ds.Tables[1]; ViewState["dtNotesCount"] = ds.Tables[2]; ViewState["dtResponse"] = ds.Tables[3]; ViewState["dtJobsCount"] = ds.Tables[4]; } if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } gvVettingIndex.DataSource = ds.Tables[0]; gvVettingIndex.DataBind(); if (ds.Tables[0].Rows.Count > 0) { btnExport.Enabled = true; } else { btnExport.Enabled = false; } UpdPnlGrid.Update(); UpdPnlFilter.Update(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
protected void btnSaveInterviewResult_Click(object sender, EventArgs e) { string js = ""; try { int iCrewID = GetCrewID(); int iUserID = GetSessionUserID(); int InterviewID = UDFLib.ConvertToInteger(Request.QueryString["ID"]); int InterviewerID = GetSessionUserID(); int QustionAnswered = 0; if (InterviewID > 0) { DataTable dt = new DataTable(); dt.Columns.Add("QID"); dt.Columns.Add("SelectedOptionID"); dt.Columns.Add("NotApplicable"); dt.Columns.Add("Remarks"); foreach (GridViewRow gvr in GridView_AssignedCriteria.Rows) { CheckBox chk = (CheckBox)gvr.FindControl("chkNA"); RadioButtonList rdoOptions = (RadioButtonList)gvr.FindControl("rdoOptions"); TextBox txtRemarks = (TextBox)gvr.FindControl("txtRemarks"); int QID = UDFLib.ConvertToInteger(GridView_AssignedCriteria.DataKeys[gvr.RowIndex].Value); int NotApplicable = -1; if (chk != null) { NotApplicable = chk.Checked == true ? 1 : 0; if (NotApplicable == 1) { QustionAnswered = 1; } } int SelectedOptionID = 0; if (rdoOptions != null) { if (rdoOptions.SelectedIndex != -1) { SelectedOptionID = UDFLib.ConvertToInteger(rdoOptions.SelectedValue.Split(',')[0]); QustionAnswered = 1; } } string Remarks = ""; if (txtRemarks != null) { Remarks = txtRemarks.Text; } DataRow dr = dt.NewRow(); dr["QID"] = QID; dr["SelectedOptionID"] = SelectedOptionID; dr["NotApplicable"] = NotApplicable; dr["Remarks"] = Remarks; dt.Rows.Add(dr); } if (QustionAnswered > 0) { string InterviewDate = UDFLib.ConvertToDate(Convert.ToString(txtInterviewDate.Text), UDFLib.GetDateFormat()).ToString(); int Ret = BLL_Crew_Interview.UPDATE_CrewInterviewResult(iCrewID, InterviewID, InterviewerID, InterviewDate, 0, "", "", "", "", iUserID, dt); js = "Briefing result updated"; btnSaveInterviewResult.Enabled = false; } else { js = "Answer atleast one question before saving briefing"; } } else { lblMessage.Text = "Please select the crew again to fill the interview result."; } } catch (Exception ex) { lblMessage.Text = ex.Message; } if (js.Length > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser3", "alert('" + js + "');", true); } }
protected void ObjectDataSource2_Updating(object sender, ObjectDataSourceMethodEventArgs e) { e.InputParameters["InterviewPlanDate"] = UDFLib.ConvertToDate(e.InputParameters["InterviewPlanDate"].ToString()).ToShortDateString(); InterviewID = int.Parse(e.InputParameters["Id"].ToString()); }
protected void btnSaveEvaluation_Click(object sender, EventArgs e) { try { int CrewID = UDFLib.ConvertToInteger(Request.QueryString["CrewID"].ToString()); //int CrewRank = UDFLib.ConvertToInteger(hdnCrewrank.Value); int EID = UDFLib.ConvertToInteger(Request.QueryString["EID"].ToString()); string DueDate = UDFLib.ConvertStringToNull(Request.QueryString["DueDate"]); if (!string.IsNullOrEmpty(DueDate)) { // DueDate = DueDate.ToString().Replace('-', '/'); } else if (txtEvaDate.Text != "") { DueDate = txtEvaDate.Text; } int Schedule_ID = 0; if (Request.QueryString["SchID"] != null) { Schedule_ID = UDFLib.ConvertToInteger(Request.QueryString["SchID"].ToString()); } DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Criteria_ID", typeof(int))); dt.Columns.Add(new DataColumn("UserAnswer", typeof(int))); dt.Columns.Add(new DataColumn("TextAnswer", typeof(string))); dt.Columns.Add(new DataColumn("Remarks", typeof(string))); dt.Columns.Add(new DataColumn("NotApplicable", typeof(int))); int QustionAnswered = 0; foreach (GridViewRow row in GridView_AssignedCriteria.Rows) { QustionAnswered = 0; int UserAnswer = 0; string TextAnswer = ""; HiddenField hdnCriteria_ID = (HiddenField)row.FindControl("hdnCriteria_ID"); int Criteria_ID = UDFLib.ConvertToInteger(hdnCriteria_ID.Value); RadioButtonList rdoOptions = (RadioButtonList)row.FindControl("rdoOptions"); if (rdoOptions != null) { UserAnswer = UDFLib.ConvertToInteger(rdoOptions.SelectedValue); } string Remarks = ((TextBox)(row.FindControl("txtRemarks"))).Text; ((TextBox)(row.FindControl("txtRemarks"))).BackColor = System.Drawing.Color.White; TextBox txtAns = (TextBox)row.FindControl("txtAnswer"); if (txtAns != null) { TextAnswer = txtAns.Text; } CheckBox chkNA = (CheckBox)row.FindControl("chkNA"); if (chkNA.Checked == true) { UserAnswer = 0; TextAnswer = ""; } if (chkNA.Checked == true || UserAnswer > 0 || TextAnswer.Length > 0) { QustionAnswered = 1; } if (QustionAnswered == 0) { QustionAnswered = -1; break; } DataRow dr = dt.NewRow(); dr[0] = Criteria_ID; dr[1] = UserAnswer; dr[2] = TextAnswer; dr[3] = Remarks; dr[4] = (chkNA.Checked == true ? 1 : 0); dt.Rows.Add(dr); } string js = ""; if (QustionAnswered > 0) { int C_EID = BLL_Crew_Evaluation.INSERT_Crew_Evaluation(CrewID, EID, GetSessionUserID(), UDFLib.ConvertToDate(txtEvaDate.Text).ToShortDateString(), GetSessionUserID(), UDFLib.ConvertToDate(DueDate).ToShortDateString(), Schedule_ID); if (C_EID > 0) { BLL_Crew_Evaluation.INSERT_Crew_Evaluation_Answer(C_EID, dt, GetSessionUserID()); } js = "alert('Evaluation Saved');window.open('','_self','');window.close();"; btnSaveEvaluation.Enabled = false; } else if (QustionAnswered == -1) { js = "alert('All evalution question are mandatory');chkNA_Checked();"; } ScriptManager.RegisterStartupScript(this, this.GetType(), "status", js, true); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void Load_CTM_Requests() { try { bool PendingWith = false; int? PendingWithUserID = null; if (Boolean.TryParse(Convert.ToString(ViewState["PendingWithMe"]), out PendingWith)) { if (PendingWith == true) { PendingWithUserID = PendingWith ? UDFLib.ConvertIntegerToNull(Session["userid"]) : null; } } if (ViewState["CTM_STATUS"].ToString() == "SENTTOOFFICE") { if (Boolean.TryParse(Convert.ToString(ViewState["PendingWithMe"]), out PendingWith)) { PendingWithUserID = PendingWith ? UDFLib.ConvertIntegerToNull(Session["userid"]) : null; } } int rowcount = ucCustomPagerItems.isCountRecord; DataTable dt = BLL_PB_PortageBill.Get_CTM_Requests(ddlFleet.SelectedValues, ddlVessel.SelectedValues, txtFromDate.Text == "" ? "" : UDFLib.ConvertToDate(txtFromDate.Text, UDFLib.GetDateFormat()).ToShortDateString(), txtToDate.Text == "" ? "" : UDFLib.ConvertToDate(txtToDate.Text, UDFLib.GetDateFormat()).ToShortDateString() , UDFLib.ConvertStringToNull(ViewState["CTM_STATUS"]), UDFLib.ConvertStringToNull(txtSearch.Text), PendingWithUserID , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); gvCTMRequests.DataSource = dt; gvCTMRequests.DataBind(); ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); if (ViewState["CTM_STATUS"].ToString() != "SENTTOOFFICE") //Pending with me { gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ApproverName")].Visible = false; } else { gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ApproverName")].Visible = true; } if (ViewState["CTM_STATUS"].ToString() == "APPROVED") { gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ApprovedAmt")].Visible = false; gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ApprovedOn")].Visible = false; } else { gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ApprovedAmt")].Visible = true; gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ApprovedOn")].Visible = true; } if (ViewState["CTM_STATUS"].ToString() == "ACKVESSEL") { gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ReceivedAmt")].Visible = true; //Received ON gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "DateReceived")].Visible = true; //Received Amount } else { gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "ReceivedAmt")].Visible = false; gvCTMRequests.Columns[UDFLib.FindGridColumnIndex(gvCTMRequests.Columns, "DateReceived")].Visible = false; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
public void BindCrewHistoryGrid() { DateTime dtFrom = DateTime.Parse("1900/01/01"); DateTime dtTo = DateTime.Parse("2900/01/01"); if (txtSearchJoinFromDate.Text != "") { dtFrom = UDFLib.ConvertToDate(Convert.ToString(txtSearchJoinFromDate.Text), UDFLib.GetDateFormat()); } if (txtSearchJoinToDate.Text != "") { dtTo = UDFLib.ConvertToDate(Convert.ToString(txtSearchJoinToDate.Text), UDFLib.GetDateFormat()); } int PAGE_SIZE = ucCustomPager_CrewList.PageSize; int PAGE_INDEX = ucCustomPager_CrewList.CurrentPageIndex; int PAGE_SIZE1 = ucCustomPager1.PageSize; int PAGE_INDEX1 = ucCustomPager1.CurrentPageIndex; int SelectRecordCount = ucCustomPager_CrewList.isCountRecord; int SelectRecordCount1 = ucCustomPager1.isCountRecord; DataSet ds = BLL_Crew_CrewList.Get_Crewlist_History(Convert.ToInt32(DDLVessel.SelectedValue), UDFLib.ConvertToInteger(ddlCountry.SelectedValue.ToString()), UDFLib.ConvertToInteger(ddlRank.SelectedValue.ToString()), dtFrom, dtTo, PAGE_SIZE, PAGE_INDEX, PAGE_SIZE1, PAGE_INDEX1, ref SelectRecordCount, ref SelectRecordCount1); gvCrwHistroy.DataSource = ds.Tables[0]; gvCrwHistroy.DataBind(); if (ucCustomPager_CrewList.isCountRecord == 1) { ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_CrewList.BuildPager(); } if (ucCustomPager1.isCountRecord == 1) { ucCustomPager1.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager1.BuildPager(); } ds.Relations.Add(new DataRelation("NestedCat", ds.Tables[1].Columns["rank_category"], ds.Tables[2].Columns["rank_category"])); ds.Tables[2].TableName = "Members"; rpt1.DataSource = ds.Tables[1]; rpt1.DataBind(); if (ucCustomPager_CrewList.isCountRecord == 1) { ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_CrewList.BuildPager(); } if (ucCustomPager1.isCountRecord == 1) { ucCustomPager1.CountTotalRec = SelectRecordCount1.ToString(); ucCustomPager1.BuildPager(); } }
protected void btnSaveVoyage_Click(object sender, EventArgs e) { string Message = ""; string Joining_Date = ""; int Joining_Rank = 0, CurrentRankId = 0, CurrentRankScaleId = 0; int Vessel_ID = 0; string COCDate = ""; int Joining_Port = 0; string Sign_On_Date = ""; int Join_Type = UDFLib.ConvertToInteger(rdoOptions.SelectedValue); int CurrentVoyageID = UDFLib.ConvertToInteger(Request.QueryString["VoyID"]); int New_Voy_ID = 0, RankScaleId = 0; try { //Get Current voyage details DataTable dtVoy = objBLLCrew.Get_CrewVoyages(GetCrewID(), CurrentVoyageID); if (dtVoy.Rows.Count > 0) { Joining_Date = dtVoy.Rows[0]["Joining_Date"].ToString(); Joining_Rank = UDFLib.ConvertToInteger(dtVoy.Rows[0]["Joining_Rank"].ToString()); Vessel_ID = UDFLib.ConvertToInteger(dtVoy.Rows[0]["Vessel_ID"].ToString()); COCDate = dtVoy.Rows[0]["COCDate"].ToString(); Joining_Port = UDFLib.ConvertToInteger(dtVoy.Rows[0]["Joining_Port"].ToString()); Sign_On_Date = dtVoy.Rows[0]["Sign_On_Date"].ToString(); RankScaleId = UDFLib.ConvertToInteger(dtVoy.Rows[0]["RankScaleId"].ToString()); CurrentRankId = Joining_Rank; CurrentRankScaleId = RankScaleId; } if (rdoOptions.SelectedValue == "1") { if (txtJoiningDate.Text.Trim() == "" || txtSignOnDate.Text.Trim() == "" || UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue) == 0 || UDFLib.ConvertToInteger(ddlVessel.SelectedValue) == 0 || txtCOCDate.Text == "" || txtSignOffDate.Text == "" || UDFLib.ConvertToInteger(ctlSignOffPort.SelectedValue) == 0 || UDFLib.ConvertToInteger(ctlJoiningPort.SelectedValue) == 0 || UDFLib.ConvertToInteger(ddlContract.SelectedValue) == 0) { Message = "Vessel Name,Contract Template, Joining Rank, Contract Date, Sign-On Date, Sign-Off-Date, Sign-Off-Port, Joining Port and EOC Date are mandatory fields. You might have missed one of the fields."; } else if (UDFLib.ConvertToDate(txtJoiningDate.Text) < UDFLib.ConvertDateToNull(COCDate)) { Message = "Contract date should be greater than the EOC of previous voyage"; } else if (txtJoiningDate.Text.Trim() != "" && txtSignOnDate.Text != "" && UDFLib.ConvertToDate(txtJoiningDate.Text) > UDFLib.ConvertToDate(txtSignOnDate.Text)) { Message = "Sign-On Date can not be less than the Contract date"; } else if (UDFLib.ConvertToDate(txtSignOffDate.Text) < DateTime.Today.AddDays(1)) { Message = "The transfer has to be planned atleast 1 day in advance"; } else if (UDFLib.ConvertToDate(txtSignOffDate.Text) > UDFLib.ConvertToDate(txtSignOnDate.Text)) { Message = "The sign-off/sign-on dates are incorrect. Sign-off has to happen before the next sign-on"; } else if (Vessel_ID == UDFLib.ConvertToInteger(ddlVessel.SelectedValue)) { Message = "Please select the new vessel different from the staff's current vessel."; } else { Vessel_ID = UDFLib.ConvertToInteger(ddlVessel.SelectedValue); Joining_Rank = UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue); New_Voy_ID = objBLLCrew.TransferCrew(CurrentVoyageID, GetCrewID(), Vessel_ID, Join_Type, Joining_Rank, UDFLib.ConvertToDate(txtJoiningDate.Text).ToShortDateString(), UDFLib.ConvertToDate(txtSignOnDate.Text).ToShortDateString(), UDFLib.ConvertToInteger(ctlJoiningPort.SelectedValue), UDFLib.ConvertToDate(txtCOCDate.Text).ToShortDateString(), GetSessionUserID(), UDFLib.ConvertToDate(txtSignOffDate.Text).ToShortDateString(), UDFLib.ConvertToInteger(ctlSignOffPort.SelectedValue), UDFLib.ConvertToInteger(ddlContract.SelectedValue)); if (New_Voy_ID > 0) { Message = "Crew transfer planned"; btnSaveVoyage.Enabled = false; } else { Message = "The transfer is already planned for the crew"; } } } if (rdoOptions.SelectedValue == "2") { if (txtJoiningDate.Text.Trim() == "" || txtSignOnDate.Text.Trim() == "" || UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue) == 0 || txtCOCDate.Text == "" || UDFLib.ConvertToInteger(ddlContract.SelectedValue) == 0) { Message = "Contract Template,Joining Rank, Contract Date, Sign-On Date and EOC Date are mandatory fields. You might have missed one of the fields."; } else if (Joining_Rank == UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue) && RankScaleConsidered == 1 && RankScaleId == UDFLib.ConvertToInteger(ddlRankScale.SelectedValue)) { Message = "Promoted rank scale should not be the same as the current rank scale."; } else if (Joining_Rank == UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue) && RankScaleConsidered == 0) { Message = "Promoted rank should not be the same as the current rank."; } else if (UDFLib.ConvertDateToNull(txtJoiningDate.Text) < UDFLib.ConvertDateToNull(COCDate)) { Message = "Contract date should be greater than the EOC of previous voyage"; } else if (txtJoiningDate.Text.Trim() != "" && txtSignOnDate.Text != "" && UDFLib.ConvertDateToNull(txtJoiningDate.Text) > UDFLib.ConvertDateToNull(txtSignOnDate.Text)) { Message = "Sign-On Date can not be less than the Contract date"; } else if (UDFLib.ConvertDateToNull(txtSignOnDate.Text) < DateTime.Today.AddDays(1)) { Message = "The promotion has to be planned atleast 1 day in advance"; } else { Joining_Rank = UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue); int NewWageContractId = 0; if (hdWageContractId.Value != null && hdWageContractId.Value.ToString() != "") { NewWageContractId = int.Parse(hdWageContractId.Value.ToString()); } New_Voy_ID = objBLLCrew.TransferCrew(CurrentVoyageID, GetCrewID(), Vessel_ID, Join_Type, Joining_Rank, UDFLib.ConvertToDate(txtJoiningDate.Text).ToShortDateString(), UDFLib.ConvertToDate(txtSignOnDate.Text).ToShortDateString(), UDFLib.ConvertToInteger(ctlJoiningPort.SelectedValue), UDFLib.ConvertToDate(txtCOCDate.Text).ToShortDateString(), GetSessionUserID(), "", 0, NewWageContractId, UDFLib.ConvertToInteger(ddlContract.SelectedValue)); if (New_Voy_ID > 0) { Message = "Staff promotion planned"; Message = Message + Save_Wages(GetCrewID(), New_Voy_ID, Vessel_ID); btnSaveVoyage.Enabled = false; if ((CurrentRankId != Joining_Rank) || (RankScaleConsidered == 1 && CurrentRankScaleId != UDFLib.ConvertToInteger(ddlRankScale.SelectedValue))) { //Save entry in Log for change in Wage Rank Scale BLL_PortageBill.Ins_CrewChangeWageLog(CurrentRankId, UDFLib.ConvertToInteger(ddlRankScale.SelectedValue.ToString()), GetCrewID(), GetSessionUserID()); } } else { Message = "The transfer is already planned for the crew"; } } } if (rdoOptions.SelectedValue == "3") { if (UDFLib.ConvertToInteger(ddlVessel.SelectedValue) == 0 || txtJoiningDate.Text.Trim() == "" || txtSignOnDate.Text.Trim() == "" || UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue) == 0 || txtCOCDate.Text == "" || txtSignOffDate.Text == "" || UDFLib.ConvertToInteger(ctlSignOffPort.SelectedValue) == 0 || UDFLib.ConvertToInteger(ddlContract.SelectedValue) == 0) { Message = "Vessel Name,Contract Template, Joining Rank, Contract Date, Sign-On Date, Sign-Off-Date, Sign-Off-Port and EOC Date are mandatory fields. You might have missed one of the fields."; } else if (Joining_Rank == UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue) && RankScaleConsidered == 1 && RankScaleId == UDFLib.ConvertToInteger(ddlRankScale.SelectedValue)) { Message = "Promoted rank scale should not be the same as the current rank scale."; } else if (Joining_Rank == UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue) && RankScaleConsidered == 0) { Message = "Promoted rank should not be the same as the current rank."; } else if (Vessel_ID == UDFLib.ConvertToInteger(ddlVessel.SelectedValue)) { Message = "Please select the new vessel different from the staff's current vessel."; } else if (UDFLib.ConvertDateToNull(txtJoiningDate.Text) < UDFLib.ConvertDateToNull(COCDate)) { Message = "Contract date should be greater than the EOC of previous voyage"; } else if (txtJoiningDate.Text.Trim() != "" && txtSignOnDate.Text != "" && UDFLib.ConvertDateToNull(txtJoiningDate.Text) > UDFLib.ConvertDateToNull(txtSignOnDate.Text)) { Message = "Sign-On Date can not be less than the Contract date"; } else if (UDFLib.ConvertDateToNull(txtSignOffDate.Text) < DateTime.Today.AddDays(1)) { Message = "The transfer has to be planned atleast 1 day in advance"; } else if (UDFLib.ConvertDateToNull(txtSignOffDate.Text) > UDFLib.ConvertDateToNull(txtSignOnDate.Text)) { Message = "The sign-off/sign-on dates are incorrect. Sign-off has to happen before the next sign-on"; } else { Vessel_ID = UDFLib.ConvertToInteger(ddlVessel.SelectedValue); Joining_Rank = UDFLib.ConvertToInteger(ddlJoiningRank.SelectedValue); New_Voy_ID = objBLLCrew.TransferCrew(CurrentVoyageID, GetCrewID(), Vessel_ID, Join_Type, Joining_Rank, UDFLib.ConvertToDate(txtJoiningDate.Text).ToShortDateString(), UDFLib.ConvertToDate(txtSignOnDate.Text).ToShortDateString(), UDFLib.ConvertToInteger(ctlJoiningPort.SelectedValue), UDFLib.ConvertToDate(txtCOCDate.Text).ToShortDateString(), GetSessionUserID(), UDFLib.ConvertToDate(txtSignOffDate.Text).ToShortDateString(), UDFLib.ConvertToInteger(ctlSignOffPort.SelectedValue), UDFLib.ConvertToInteger(ddlContract.SelectedValue)); if (New_Voy_ID > 0) { Message = "Staff transfer promotion planned"; Message = Message + Save_Wages(GetCrewID(), New_Voy_ID, Vessel_ID); btnSaveVoyage.Enabled = false; if ((CurrentRankId != Joining_Rank) || (RankScaleConsidered == 1)) { //Save entry in Log for change in Wage Rank Scale if (RankScaleConsidered == 1 && CurrentRankScaleId != UDFLib.ConvertToInteger(ddlRankScale.SelectedValue)) { BLL_PortageBill.Ins_CrewChangeWageLog(CurrentRankId, UDFLib.ConvertToInteger(ddlRankScale.SelectedValue.ToString()), GetCrewID(), GetSessionUserID()); } else { BLL_PortageBill.Ins_CrewChangeWageLog(CurrentRankId, 0, GetCrewID(), GetSessionUserID()); } } } else { Message = "The transfer is already planned for the crew"; } } } if (New_Voy_ID > 0) { int VoyID = UDFLib.ConvertToInteger(Request.QueryString["VoyID"]); DataTable dt = objBLLCrew.Get_Transfer_Promotions(GetCrewID(), VoyID, GetSessionUserID()); GridView1.DataSource = dt; GridView1.DataBind(); pnlViewTransfer.Visible = true; pnlTransfer.Visible = false; pnlPromotion.Visible = false; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } if (Message.Length > 0) { lblMessage.Text = Message; } }
/// <summary> /// Open the Inspection List based on Certificate Inspection /Renewable Inspection icon /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSearchInspection_Click(object sender, EventArgs e) { try { DataSet ds = objInsp.Get_Current_Schedules(ddlStatus.SelectedValue, VesselId, txtInspectionFromDate.Text == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtInspectionFromDate.Text)), txtInspectionToDate.Text == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtInspectionToDate.Text)), Convert.ToInt16(DDLPort.SelectedValue)); if (ds.Tables.Count > 0) { gvInspectionSchedule.DataSource = ds.Tables[0]; gvInspectionSchedule.DataBind(); } else { gvInspectionSchedule.DataSource = null; gvInspectionSchedule.DataBind(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
public void BindIndex() { 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_Search(txtCardNumber.Text != "" ? txtCardNumber.Text : null, (DataTable)Session["sVesselCode"], UDFLib.ConvertToDate(txtFromDate.Text).ToShortDateString(), UDFLib.ConvertToDate(txtToDate.Text).ToShortDateString(), ddlStatus.SelectedIndex == 0 ? null : ddlStatus.SelectedValue, sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } gvPhoneCardRequest.DataSource = dt; gvPhoneCardRequest.DataBind(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
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 btnSaveDetails_Click(object s, EventArgs e) { try { int Vsl_ID = 0; if (UDFLib.ConvertToInteger(hdfWelfare_ID.Value) == 0) { Vsl_ID = Convert.ToInt32(ddlVesselUpd.SelectedValue); } BLL_PB_PortageBill.UPD_Lib_Crew_Welfare(UDFLib.ConvertToInteger(hdfWelfare_ID.Value), UDFLib.ConvertToDecimal(txtWelfareAmount.Text), Vsl_ID, UDFLib.ConvertToDate(txtEffectiveDate.Text, UDFLib.GetDateFormat()), Convert.ToInt32(Session["userid"])); BindItems(); ScriptManager.RegisterStartupScript(this, this.GetType(), "close", "hideModal('dvWelfare')", true); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "MMCD", "showModal('dvWelfare')", true); UDFLib.WriteExceptionLog(ex); } }
protected void btnFinalize_Click(object sender, EventArgs e) { if (ISvalid()) { DataTable dt = new DataTable(); dt.Clear(); dt.Columns.Add("ITEM_REF_CODE"); dt.Columns.Add("ORDER_PRICE"); dt.Columns.Add("ORDER_DISCOUNT"); dt.Columns.Add("ORDER_RATE"); dt.Columns.Add("REQUESTED_QTY"); dt.Columns.Add("VAT"); dt.Columns.Add("WithHold"); for (int i = 0; i < rptMain.Items.Count; i++) { Repeater rptChild = (Repeater)rptMain.Items[i].FindControl("rptChild"); for (int j = 0; j < rptChild.Items.Count; j++) { TextBox txtPPU = (TextBox)rptChild.Items[j].FindControl("txt_PPU"); TextBox txtTP = (TextBox)rptChild.Items[j].FindControl("txtTP"); TextBox txtDiscount = (TextBox)rptChild.Items[j].FindControl("txt_Discount"); TextBox txtQnty = (TextBox)rptChild.Items[j].FindControl("txtQnty"); ImageButton btn = (ImageButton)rptChild.Items[j].FindControl("btnupdate"); DropDownList ddlItemvat = (DropDownList)rptChild.Items[j].FindControl("ddl_ItemVAT"); DropDownList ddlItemWithhod = (DropDownList)rptChild.Items[j].FindControl("ddl_item_Withhold"); DataRow dr = dt.NewRow(); dr["ITEM_REF_CODE"] = btn.CommandArgument.ToString(); dr["ORDER_PRICE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtTP.Text); dr["ORDER_DISCOUNT"] = Convert.ToDecimal(txtDiscount.Text.Length == 0 ? "0" : txtDiscount.Text); dr["ORDER_RATE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtPPU.Text); dr["REQUESTED_QTY"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtQnty.Text); dr["VAT"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemvat.SelectedValue) == 0 ? "0" : ddlItemvat.SelectedValue); dr["WithHold"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemWithhod.SelectedValue) == 0 ? "0" : ddlItemWithhod.SelectedValue); dt.Rows.Add(dr); } } //string DateFormat = UDFLib.GetDateFormat();//Get User date format //UDFLib.ConvertUserDateFormat(txtDeliveryDate.Text, DateFormat); string ReturnReq = string.Empty; IventoryItemData ItemData = new IventoryItemData(); ItemData.DocumentCode = DocCode; ItemData.Delivery_Date = UDFLib.ConvertToDate(txt_SuppDate.Text);; ItemData.Delivery_Port = Convert.ToInt32(ddlSupp_Port.SelectedValue); ItemData.Discount = Convert.ToInt32(txt_Discount.Text); ItemData.SupplierID = HD_SelectedSupplier.Value.ToString(); ItemData.WithHoldTax = ddlWithHoldTax.SelectedValue.ToString(); ItemData.VAT = ddlVAt.SelectedValue.ToString(); ItemData.Advance = Convert.ToInt32(txt_Advance.Text); ItemData.Currency = Session["CurrencyCode"].ToString(); if (ValidateQuestions() == true) { using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase()) { objTechService.SaveUpdate_Quotation(ItemData, Convert.ToInt32(Session["userid"]), Convert.ToDecimal(HD_TP.Value.Length < 1 ? "0" : HD_TP.Value), dt); } using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase()) { ReturnReq = objTechService.SaveUpdate_FinalQuotation(ItemData, Convert.ToInt32(Session["userid"])); } SaveQuestionnaire(ReturnReq); ClientScript.RegisterStartupScript(Page.GetType(), "alert", "alert('Requisition has been Finalized.\\n Please Note Requisition Number:" + ReturnReq + "');window.location='PendingRequisitionDetails.aspx?NOQUOTE=1';", true); } else { ClientScript.RegisterStartupScript(Page.GetType(), "alert", "alert('Please complete the Purchase Questionnaire to proceed with the purchase process');", true); BindItmPreviewRpt(); } } else { string msgtxt = string.Empty; if (HD_SelectedSupplier.Value.ToString() == string.Empty) { msgtxt = "Please Select The Supplier"; } else { msgtxt = "Please Fill all the Mandatory Fields"; } String msg = String.Format("alert('" + msgtxt + "'); "); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); } }
/// <summary> /// Bind all records of observation index /// </summary> public void Bind_ObservationIndex() { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); DataSet ds = new DataSet(); int rowcount = ucCustomPagerItemsObs.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataTable dtInspector = new DataTable(); dtInspector.Columns.Add("ID"); DataTable dtEXInspector = new DataTable(); dtEXInspector.Columns.Add("ID"); foreach (DataRow dr in DDLInspectorObs.SelectedValues.Rows) { if (dr[0].ToString().Split('_')[1] == "In") { dtInspector.Rows.Add(dr[0].ToString().Split('_')[0]); } if (dr[0].ToString().Split('_')[1] == "Ex") { dtEXInspector.Rows.Add(dr[0].ToString().Split('_')[0]); } } DateTime?LObsFromDate, LObsToDate; LObsFromDate = txtLObsFromDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLObsFromDate.Text)); LObsToDate = txtLObsToDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLObsToDate.Text)); ds = objBLLIndx.VET_Get_ObservationIndex(DDLQuestionnaire.SelectedValues, DDLSection.SelectedValues, DDLQuestion.SelectedValues, UDFLib.ConvertToInteger(rbtnType.SelectedValue), ViewState["Status"].ToString(), UDFLib.ConvertToInteger(DDLFleet.SelectedValue), DDLVesselObs.SelectedValues, DDLOilMajorObs.SelectedValues, dtInspector, dtEXInspector, DDLCategories.SelectedValues, DDLRiskLevel.SelectedValues, txtObservationVessel.Text != "" ? txtObservationVessel.Text.Trim() : null, LObsFromDate, LObsToDate, sortbycoloumn, sortdirection, ucCustomPagerItemsObs.CurrentPageIndex, ucCustomPagerItemsObs.PageSize, ref rowcount); if (ds.Tables.Count > 0) { ViewState["dtObsResponse"] = ds.Tables[1]; ViewState["dtObsJobsCount"] = ds.Tables[2]; ViewState["dtObsvationCount"] = ds.Tables[3]; } if (ucCustomPagerItemsObs.isCountRecord == 1) { ucCustomPagerItemsObs.CountTotalRec = rowcount.ToString(); ucCustomPagerItemsObs.BuildPager(); } gvObservationIndex.DataSource = ds.Tables[0]; gvObservationIndex.DataBind(); if (ds.Tables[0].Rows.Count > 0) { btnObsExport.Enabled = true; } else { btnObsExport.Enabled = false; } UpdPnlGridObs.Update(); UpdPnlFilterObs.Update(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
/// <summary> /// Fill the grid with Unassigned Crews according to filter /// </summary> protected void Search_UnAssigned() { try { int PAGE_SIZE = ucCustomPager_UnAssignedCrew.PageSize; int PAGE_INDEX = ucCustomPager_UnAssignedCrew.CurrentPageIndex; int SelectRecordCount = ucCustomPager_UnAssignedCrew.isCountRecord; int VesselId_OffSignner = int.Parse(ddlVessel_UA.SelectedValue.ToString()); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } //selected Vessel Type int i = 1; DataTable dtVesselTypes = new DataTable(); dtVesselTypes.Columns.Add("PID"); dtVesselTypes.Columns.Add("VALUE"); foreach (DataRow dr in ddlVesselType.SelectedValues.Rows) { DataRow dr1 = dtVesselTypes.NewRow(); dr1["PID"] = i; dr1["VALUE"] = dr[0]; dtVesselTypes.Rows.Add(dr1); i++; } DataTable dt = BLL_Crew_CrewList.Get_UnAssigned_CrewList(int.Parse(ddlManningOffice.SelectedValue), int.Parse(ddlNationality.SelectedValue), int.Parse(ddlRank_UA.SelectedValue), txtFromDt_UA.Text.Trim() == "" ? "" : UDFLib.ConvertToDate(txtFromDt_UA.Text).ToShortDateString(), txtToDt_UA.Text.Trim() == "" ? "" : UDFLib.ConvertToDate(txtToDt_UA.Text).ToShortDateString(), txtFreeText_UA.Text, int.Parse(ddlVessel_UA.SelectedValue), VesselId_OffSignner, int.Parse(UA_AvailableOptions.SelectedValue), GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection, int.Parse(ddlMinYearOperator.SelectedValue), int.Parse(ddlMinYearsRank.SelectedValue), int.Parse(ddlMinYearsAllTankers.SelectedValue), dtVesselTypes); if (ucCustomPager_UnAssignedCrew.isCountRecord == 1) { ucCustomPager_UnAssignedCrew.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_UnAssignedCrew.BuildPager(); } gvUnAssignedCrew.DataSource = dt; gvUnAssignedCrew.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "SaveAddError", "BindHeight();", 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; Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); //Startdate= Convert.ToDateTime(txtStartDate.Text); DateTime EndDate; EndDate = Convert.ToDateTime(UDFLib.ConvertToDate(txtEndDate.Text)); //EndDate = Convert.ToDateTime(txtEndDate.Text); int KPI_ID = 1; DropDownList ddlVoyage = (DropDownList)sender; GridDataItem item = (GridDataItem)ddlVoyage.NamingContainer; Label avg = (Label)item.FindControl("Vessel_Average"); HiddenField hdf = (HiddenField)item.FindControl("hdVesselID"); LinkButton lnkVessel = (LinkButton)item.FindControl("Item_Name"); item["Average"].BackColor = System.Drawing.Color.White; avg.Text = "0"; 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()); // hiddenVesselStartDate.Value = dtq.Rows[0][0].ToString(); // hiddenStartDate.Text = dtq.Rows[0][0].ToString(); hiddenStartDate.Value = Startdate.ToString("dd-MM-yyyy"); } if (dtq.Rows[dtq.Rows.Count - 1][0].ToString() != "") { EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1][1].ToString()); //hiddenVesselEndDate.Value = dtq.Rows[dtq.Rows.Count - 1][0].ToString(); //hiddenEndDate.Text = dtq.Rows[dtq.Rows.Count - 1][0].ToString(); hiddenEndDate.Value = EndDate.ToString("dd-MM-yyyy"); } } DataTable dt = BLL_TMSA_PI.GetVoyageData(ddlVoyage.SelectedValue.Trim(), Convert.ToInt32(hdf.Value), KPI_ID).Tables[0]; if (dt.Rows.Count > 0) { avg.Text = Math.Round(Convert.ToDouble(dt.Rows[0]["Value"].ToString()), 2).ToString(); if (Convert.ToDouble(avg.Text) == 0) { lnkVessel.Enabled = false; item["Vessel"].BackColor = System.Drawing.Color.White; } else { lnkVessel.Enabled = true; } } else { lnkVessel.Enabled = false; item["Vessel"].BackColor = System.Drawing.Color.White; } Label Vessel_Goal = (Label)item.FindControl("Vessel_Goal"); Label eedi = (Label)item.FindControl("eedi"); if (Convert.ToDouble(avg.Text) > 0 && Convert.ToDouble(eedi.Text) > 0) { if ((Convert.ToDouble(avg.Text) < Convert.ToDouble(Vessel_Goal.Text))) { item["Average"].BackColor = System.Drawing.Color.White; } if (Convert.ToDouble(avg.Text) > Convert.ToDouble(eedi.Text)) { item["Average"].BackColor = System.Drawing.ColorTranslator.FromHtml("#FFC7CE"); } else if ((Convert.ToDouble(avg.Text) > Convert.ToDouble(Vessel_Goal.Text)) && (Convert.ToDouble(avg.Text) < Convert.ToDouble(eedi.Text))) { item["Average"].BackColor = System.Drawing.ColorTranslator.FromHtml("#FABF8F"); } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Fill all the Items Detail in Datatable and sets the "IventoryItemData" properties . /// saves the Requisition /// </summary> protected void btnSave_Click(object sender, EventArgs e) // Save Requisition { if (ISvalid()) { DataTable dt = new DataTable(); dt.Clear(); dt.Columns.Add("ITEM_REF_CODE"); dt.Columns.Add("ORDER_PRICE"); dt.Columns.Add("ORDER_DISCOUNT"); dt.Columns.Add("ORDER_RATE"); dt.Columns.Add("REQUESTED_QTY"); dt.Columns.Add("VAT"); dt.Columns.Add("WithHold"); for (int i = 0; i < rptMain.Items.Count; i++) { Repeater rptChild = (Repeater)rptMain.Items[i].FindControl("rptChild"); for (int j = 0; j < rptChild.Items.Count; j++) { TextBox txtPPU = (TextBox)rptChild.Items[j].FindControl("txt_PPU"); TextBox txtTP = (TextBox)rptChild.Items[j].FindControl("txtTP"); TextBox txtDiscount = (TextBox)rptChild.Items[j].FindControl("txt_Discount"); TextBox txtQnty = (TextBox)rptChild.Items[j].FindControl("txtQnty"); ImageButton btn = (ImageButton)rptChild.Items[j].FindControl("btnupdate"); DropDownList ddlItemvat = (DropDownList)rptChild.Items[j].FindControl("ddl_ItemVAT"); DropDownList ddlItemWithhod = (DropDownList)rptChild.Items[j].FindControl("ddl_item_Withhold"); DataRow dr = dt.NewRow(); dr["ITEM_REF_CODE"] = btn.CommandArgument.ToString(); dr["ORDER_PRICE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtTP.Text); dr["ORDER_DISCOUNT"] = Convert.ToDecimal(txtDiscount.Text.Length == 0 ? "0" : txtDiscount.Text); dr["ORDER_RATE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtPPU.Text); dr["REQUESTED_QTY"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtQnty.Text); dr["VAT"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemvat.SelectedValue) == 0 ? "0" : ddlItemvat.SelectedValue); dr["WithHold"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemWithhod.SelectedValue) == 0 ? "0" : ddlItemWithhod.SelectedValue); dt.Rows.Add(dr); } } IventoryItemData ItemData = new IventoryItemData(); ItemData.DocumentCode = Session["DocumentCode"].ToString(); ItemData.RequisitionCode = Session["Requisitioncode"].ToString(); ItemData.Delivery_Port = Convert.ToInt32(ddlSupp_Port.SelectedValue); ItemData.Discount = Convert.ToInt32(txt_Discount.Text); ItemData.SupplierID = HD_SelectedSupplier.Value.ToString(); ItemData.WithHoldTax = ddlWithHoldTax.SelectedValue.ToString(); ItemData.VAT = ddlVAt.SelectedValue.ToString(); ItemData.Advance = Convert.ToInt32(txt_Advance.Text); ItemData.Currency = Session["CurrencyCode"].ToString(); ItemData.Delivery_Date = UDFLib.ConvertToDate(txt_SuppDate.Text); //bindprice(Convert.ToDecimal(Session["PreviousCurr"])); using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase()) { objTechService.SaveUpdate_Quotation(ItemData, Convert.ToInt32(Session["userid"]), Convert.ToDecimal(HD_TP.Value.Length < 1 ? "0" : HD_TP.Value), dt); } String msg = String.Format("alert('Requisition has been Saved sucessfully.'); "); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); } else { string msgtxt = string.Empty; if (HD_SelectedSupplier.Value.ToString() == string.Empty) { msgtxt = "Please Select The Supplier"; } else { msgtxt = "Please Fill all the Mandatory Fields"; } String msg = String.Format("alert('" + msgtxt + "'); "); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); } }