//--- Save Details --
protected void btnSaveDetails_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
CrewProperties objCrw = new CrewProperties();
if (!ValidateDetails())
{
return;
}
try
{
objCrw.CrewID = GetCrewID();
objCrw.RankID = int.Parse(ddlRankAppliedFor.SelectedValue);
objCrw.Available_From_Date = DateTime.Parse(txtDateAvailable.Text, iFormatProvider);
objCrw.Surname = txtPD_Surname.Text;
objCrw.GivenName = txtPD_Givenname.Text;
objCrw.Alias = txtPD_Alias.Text;
objCrw.DateOfBirth = DateTime.Parse(txtPD_DOB.Text, iFormatProvider);
objCrw.PlaceofBirth = txtPD_PlaceOfBirth.Text;
objCrw.Nationality = int.Parse(ddlPD_Nationality.SelectedValue);
objCrw.MaritalStatus = ddlPD_MaritalStatus.SelectedValue;
objCrw.Telephone = txtPD_Phone.Text;
objCrw.Mobile = txtPD_Mobile.Text;
objCrw.Address = txtPD_Address.Text;
objCrw.Fax = txtPD_Fax.Text;
objCrw.EMail = txtPD_Email.Text;
objCrw.NearestInternationalAirport = txtPD_Airport.Text;
objCrw.NearestInternationalAirportID = UDFLib.ConvertToInteger(txtPD_Airport.SelectedValue);
objCrw.Passport_Number = txtPassport_No.Text;
DateTime dtCDCExpiry;
DateTime dtCDCIssue;
DateTime dtPassport_IssueDate;
DateTime dtPassportExpDate;
if (DateTime.TryParse(txtPassport_IssueDate.Text, out dtPassport_IssueDate))
{
objCrw.Passport_Issue_Date = dtPassport_IssueDate;
}
else
{
objCrw.Passport_Issue_Date = DateTime.Parse("1900/01/01");
}
if (DateTime.TryParse(txtPassport_ExpDate.Text, out dtPassportExpDate))
{
objCrw.Passport_Expiry_Date = dtPassportExpDate;
}
else
{
objCrw.Passport_Expiry_Date = DateTime.Parse("1900/01/01");
}
//objCrw.Passport_Issue_Date = DateTime.Parse(txtPassport_IssueDate.Text, iFormatProvider);
//objCrw.Passport_Expiry_Date = DateTime.Parse(txtPassport_ExpDate.Text, iFormatProvider);
objCrw.Passport_PlaceOf_Issue = txtPassport_Place.Text;
objCrw.Seaman_Book_Number = txtSeamanBk_No.Text;
if (DateTime.TryParse(txtSeamanBk_IssueDate.Text, out dtCDCIssue))
{
objCrw.Seaman_Book_Issue_Date = dtCDCIssue;
}
else
{
objCrw.Seaman_Book_Issue_Date = DateTime.Parse("1900/01/01");
}
if (DateTime.TryParse(txtSeamanBk_ExpDate.Text, out dtCDCExpiry))
{
objCrw.Seaman_Book_Expiry_Date = dtCDCExpiry;
}
else
{
objCrw.Seaman_Book_Expiry_Date = DateTime.Parse("1900/01/01");
}
objCrw.Seaman_Book_PlaceOf_Issue = txtSeamanBk_Place.Text;
objCrw.Workedwith_Multinational_Crew = 0;
objCrw.MultinationalCrew_Nationalities = "";
objCrw.ManningOfficeID = int.Parse(ddlManningOffice.SelectedValue);
objCrw.USVisa_Flag = UDFLib.ConvertToInteger(rdoUSVisaFlag.SelectedValue);
objCrw.USVisa_Number = txtPD_USVisaNo.Text;
if (txtPD_USVisaExpiry.Text != "")
{
objCrw.USVisa_Expiry = DateTime.Parse(txtPD_USVisaExpiry.Text);
}
else
{
objCrw.USVisa_Expiry = DateTime.Parse("1900/01/01");
}
objCrw.Created_By = GetSessionUserID();
objCrw.Modified_By = GetSessionUserID();
if (HiddenField_AccType.Value == "")
{
objCrw.Allotment_AccType = "BOTH";
}
else
{
objCrw.Allotment_AccType = HiddenField_AccType.Value.ToString();
}
int iNewCrewID = 0;
if (GetCrewID() > 0)
{
objBLLCrew.UPDATE_CrewPersonalDetails(objCrw);
objBLLCrew.UPDATE_CrewPassportAndSeamanDetails(objCrw.CrewID, objCrw.Passport_Number, txtPassport_IssueDate.Text, txtPassport_ExpDate.Text, objCrw.Passport_PlaceOf_Issue, objCrw.Seaman_Book_Number, txtSeamanBk_IssueDate.Text, txtSeamanBk_ExpDate.Text, objCrw.Seaman_Book_PlaceOf_Issue, GetSessionUserID());
objBLLCrew.UPDATE_HeightWaistWeight(GetCrewID(), txtHeight.Text, txtWaist.Text, txtWeight.Text, GetSessionUserID());
if (hdnNOKID.Value != "" && hdnNOKID.Value != "0")
{
objBLLCrew.UPDATE_Crew_DependentDetails(int.Parse(hdnNOKID.Value), txtNOKName.Text, ddlNOKRelationship.SelectedValue, txtNOKAddress.Text, txtNOKPhone.Text, 1, GetSessionUserID());
}
}
else
{
//-- NEW CREW ADDED --
DataTable dtCrew = objBLLCrew.GetCrewIfCrewExists(objCrw.GivenName, objCrw.Surname, objCrw.DateOfBirth.ToString("dd/MM/yyyy"), objCrw.Passport_Number);
if (dtCrew.Rows.Count == 0)
{
iNewCrewID = objBLLCrew.INS_NewCrewDetails(objCrw);
HiddenField_CrewID.Value = iNewCrewID.ToString();
if (iNewCrewID > 0)
{
objBLLCrew.UPDATE_HeightWaistWeight(iNewCrewID, txtHeight.Text, txtWaist.Text, txtWeight.Text, GetSessionUserID());
//English Proficiency
if (ddlEngProficiency.SelectedIndex > 0)
{
objCrewAdmin.InsertEnglishProficiency(iNewCrewID, ddlEngProficiency.SelectedValue, GetSessionUserID());
}
DataTable dt = objCrewAdmin.getEnglishProficiency(iNewCrewID).Tables[0];
if (dt.Rows.Count > 0)
{
lblEngProficiency.Text = dt.Rows[0]["English_Proficiency"].ToString();
}
}
}
else
{
grdExistingCrew.DataSource = dtCrew;
grdExistingCrew.DataBind();
string js = "alert('Staff with Same Name OR Same Passport number exists.');showModal('dvExistingCrew');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "CrewExists", js, true);
}
}
if (iNewCrewID > 0)
{
Session["NewCrew"] = "NewCrew";
Load_CrewPersonalDetails(iNewCrewID);
Load_Next_Of_Kin(iNewCrewID);
Load_CrewHeightWaiseWeight();
pnlView_PersonalDetails.Visible = true;
pnlEdit_PersonalDetails.Visible = false;
pnlView_Passport.Visible = true;
pnlEdit_Passport.Visible = false;
pnlEdit_NextOfKin.Visible = true;
lnkAddDependents.Visible = true;
btnSaveDetails.Enabled = false;
lblMessage.Text = "Crew details Added !! Please add the Next of Kin and Dependent Details";
Response.Redirect("AddEditCrew.aspx?ID=" + iNewCrewID.ToString());
}
else
{
//lblMessage.Text = "Crew details updated !!";
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
finally
{
objCrw = null;
}
}
public void UpdateCrewPersonalDetails()
{
CrewProperties objCrw = new CrewProperties();
objCrw.CrewID = GetCrewID();
objCrw.Surname = txtPD_Surname.Text;
objCrw.GivenName = txtPD_Givenname.Text;
objCrw.DateOfBirth = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtPD_DOB.Text));
objCrw.Nationality = int.Parse(ddlPD_Nationality.SelectedValue);
objCrw.Telephone = txtPD_Phone.Text;
objCrw.ManningOfficeID = int.Parse(ddlManningOffice.SelectedValue);
objCrw.Available_From_Date = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtDateAvailableFrom.Text));
objCrw.RankID = int.Parse(ddlRankAppliedFor.SelectedValue);
objCrw.Modified_By = GetSessionUserID();
if (!string.IsNullOrEmpty(txtHireDates.Text))
{
objCrw.HireDate = DateTime.Parse(UDFLib.ConvertToDefaultDt(txtHireDates.Text));
}
else
{
objCrw.HireDate = null;
}
objCrw.Mobile = txtMobilePhone.Text;
objCrw.EMail = txtEmailID.Text;
objCrw.UnionID = int.Parse(ddlUnion.SelectedValue);
objCrw.UnionBook = int.Parse(ddlUnionBook.SelectedValue);
objCrw.UnionBranch = int.Parse(ddlUnionBranch.SelectedValue);
objCrw.Permanent = int.Parse(ddlPermamnent.SelectedValue);
objCrw.Modified_By = GetSessionUserID();
//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++;
}
int result = 0;
if (!lblCode.Text.Equals("") && dtVesselTypes.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "alert('Select at least one Vessel Type!');", true);
}
else
{
result = objBLLCrew.UPDATE_CrewPersonalDetails(objCrw, dtVesselTypes);
objCrw = null;
Load_CrewPersonalDetails(GetCrewID());
pnlEdit_PersonalDetails.Visible = false;
pnlView_PersonalDetails.Visible = true;
divCrewAction.Visible = true;
lblMessagePersonalDetails.Text = "";
if (result == 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "alert('Personal Details Updated Successfully..!');", true);
}
else
{
string js = "ShowNotification('Alert','Personal Details Updating Unsuccessful..', true);";
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true);
}
}
string jss = "funHitMap();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "msgs", jss, true);
lnkEditPersonalDetails.Visible = true;
}
protected void btnSavePersonalDetails_Click(object sender, EventArgs e)
{
CrewProperties objCrw = new CrewProperties();
try
{
if (!ValidateDetails())
{
return;
}
objCrw.CrewID = GetCrewID();
objCrw.RankID = int.Parse(ddlRankAppliedFor.SelectedValue);
objCrw.Available_From_Date = DateTime.Parse(txtDateAvailable.Text, iFormatProvider);
objCrw.Surname = txtPD_Surname.Text;
objCrw.GivenName = txtPD_Givenname.Text;
objCrw.Alias = txtPD_Alias.Text;
objCrw.DateOfBirth = DateTime.Parse(txtPD_DOB.Text, iFormatProvider);
objCrw.PlaceofBirth = txtPD_PlaceOfBirth.Text;
objCrw.Nationality = int.Parse(ddlPD_Nationality.SelectedValue);
objCrw.MaritalStatus = ddlPD_MaritalStatus.SelectedValue;
objCrw.Telephone = txtPD_Phone.Text;
objCrw.Mobile = txtPD_Mobile.Text;
objCrw.Address = txtPD_Address.Text;
objCrw.Fax = txtPD_Fax.Text;
objCrw.EMail = txtPD_Email.Text;
objCrw.NearestInternationalAirport = txtPD_Airport.SelectedText;
objCrw.NearestInternationalAirportID = UDFLib.ConvertToInteger(txtPD_Airport.SelectedValue);
objCrw.ManningOfficeID = int.Parse(ddlManningOffice.SelectedValue);
objCrw.USVisa_Flag = UDFLib.ConvertToInteger(rdoUSVisaFlag.SelectedValue);
objCrw.USVisa_Number = txtPD_USVisaNo.Text;
if (txtPD_USVisaExpiry.Text != "")
{
objCrw.USVisa_Expiry = DateTime.Parse(txtPD_USVisaExpiry.Text);
}
else
{
objCrw.USVisa_Expiry = DateTime.Parse("1900/01/01");
}
objCrw.Modified_By = GetSessionUserID();
int result = objBLLCrew.UPDATE_CrewPersonalDetails(objCrw);
objBLLCrew.UPDATE_HeightWaistWeight(GetCrewID(), txtHeight.Text, txtWaist.Text, txtWeight.Text, GetSessionUserID());
if (result == 1)
{
pnlEdit_PersonalDetails.Visible = false;
pnlView_PersonalDetails.Visible = true;
lblMessage.Text = "Personal details updated.";
Load_CrewPersonalDetails(objCrw.CrewID);
Load_CrewHeightWaiseWeight();
}
objCrewAdmin.InsertEnglishProficiency(GetCrewID(), ddlEngProficiency.SelectedValue.ToString() == "0" ? "" : ddlEngProficiency.SelectedValue, GetSessionUserID());
DataTable dt = objCrewAdmin.getEnglishProficiency(GetCrewID()).Tables[0];
if (dt.Rows.Count > 0)
{
lblEngProficiency.Text = dt.Rows[0]["English_Proficiency"].ToString();
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
finally
{
objCrw = null;
}
}
protected void btnSavePersonalDetails_Click(object sender, EventArgs e)
{
Boolean Valid = ValidatePersonalDetails();
string response = "";
CrewProperties objCrw = new CrewProperties();
try
{
if (Valid == true)
{
//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++;
}
int VesselTypeId = 0, isOnboard = 0;
if (!lblCode.Text.Equals("") && dtVesselTypes.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "alert('Select at least one Vessel Type!');", true);
}
else
{
if (dtVesselTypes.Rows.Count > 0)
{
DataTable dtSavedVesselType = objBLLCrew.GET_VesselTypeForCrew(int.Parse(CID));
DataTable dtVesselType = objBLLCrew.CheckVesselTypeForCrew(int.Parse(CID), 0);
if (dtSavedVesselType != dtVesselType)
{
if (dtVesselType.Rows.Count > 0)
{
if (dtVesselType.Rows[0][0].ToString() != "-1") //Crew has no open assignment
{
VesselTypeId = int.Parse(dtVesselType.Rows[0][0].ToString());
isOnboard = int.Parse(dtVesselType.Rows[0]["Onboard"].ToString());
dtVesselTypes.DefaultView.RowFilter = "VALUE = " + VesselTypeId;
if (dtVesselTypes.DefaultView.Count == 0)
{
if (isOnboard == 1)
{
response = dtVesselType.Rows[0]["StaffName"].ToString() + " is currently onboard on " + dtVesselType.Rows[0]["VesselName"].ToString() + " having " + dtVesselType.Rows[0]["VesselTypeName"].ToString() + " as vessel type. Would you like to continue?";
}
else
{
response = dtVesselType.Rows[0]["StaffName"].ToString() + " is having a open assignment on " + dtVesselType.Rows[0]["VesselName"].ToString() + " having " + dtVesselType.Rows[0]["VesselTypeName"].ToString() + " as vessel type. Would you like to continue?";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "confirmation('" + response + "');", true);
}
}
}
}
}
if (response.Equals(""))
{
UpdateCrewPersonalDetails();
}
}
}
}
catch (Exception ex)
{
lblMessagePersonalDetails.Text = ex.Message;
}
}
