private void LoadData(string VesselId)
{
ClearText();
int intVesselId = 0;
if (VesselId == "" || !Int32.TryParse(VesselId, out intVesselId))
{
return;
}
BLL.DBInteraction dbinteract = new BLL.DBInteraction();
System.Data.DataSet ds = dbinteract.GetVessel(Convert.ToInt32(VesselId), 0, "", 0);
if (!ReferenceEquals(ds, null) && ds.Tables[0].Rows.Count > 0)
{
txtAgentCode.Text = ds.Tables[0].Rows[0]["AgentCode"].ToString();
txtIMO.Text = ds.Tables[0].Rows[0]["IMONumber"].ToString();
txtMasterCode.Text = ds.Tables[0].Rows[0]["MasterName"].ToString();
txtPan.Text = ds.Tables[0].Rows[0]["PAN"].ToString();
txtShipLineCode.Text = ds.Tables[0].Rows[0]["ShippingLineCode"].ToString();
((TextBox)AutoCompleteCountry1.FindControl("txtCountry")).Text = ds.Tables[0].Rows[0]["flag"].ToString();
txtVesselName.Text = ds.Tables[0].Rows[0]["VesselName"].ToString();
TxtCallSign.Text = ds.Tables[0].Rows[0]["CallSign"].ToString();
ddlVesselPrefix.SelectedValue = ds.Tables[0].Rows[0]["fk_VesselPrefixID"].ToString();
txtVesselAbbr.Text = ds.Tables[0].Rows[0]["VesselAbbr"].ToString();
}
}
private void LoadData(string SortExp, string direction)
{
BLL.DBInteraction dbinteract = new BLL.DBInteraction();
int VesselPrefix = Convert.ToInt32(ddlVesselPrefix.SelectedValue);
string VesselName = string.IsNullOrEmpty(txtVesselName.Text) ? "" : txtVesselName.Text.Trim();
int vesselFlag = dbinteract.GetId("Country", ((TextBox)AutoCompleteCountry1.FindControl("txtCountry")).Text);
// int countryId=Convert.ToInt32(ddlLocation.SelectedValue);
lblErrorMsg.Text = "";
if (!ReferenceEquals(Session[Constants.SESSION_SEARCH_CRITERIA], null))
{
SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA];
if (!ReferenceEquals(searchCriteria, null))
{
BuildSearchCriteria(searchCriteria);
gvwLoc.PageIndex = searchCriteria.PageIndex;
if (searchCriteria.PageSize > 0)
{
gvwLoc.PageSize = searchCriteria.PageSize;
}
try
{
System.Data.DataSet ds = dbinteract.GetVessel(-1, VesselPrefix, VesselName, vesselFlag);
System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]);
if (!string.IsNullOrEmpty(SortExp) && !string.IsNullOrEmpty(direction) && SortExp != "Location")
{
dv.Sort = SortExp + " " + direction;
}
gvwLoc.DataSource = dv;
}
catch (Exception ex)
{
gvwLoc.DataSource = null;
lblErrorMsg.Text = "Error Occured.Please try again.";
}
gvwLoc.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
((AjaxControlToolkit.TextBoxWatermarkExtender)AutoCompleteCountry1.FindControl("txtWMEName")).WatermarkText = "TYPE VESSEL FLAG";
SetAttributes();
RetriveParameters();
CheckUserAccess();
if (!IsPostBack)
{
RetrieveSearchCriteria();
DBInteraction dbInteract = new DBInteraction();
//GeneralFunctions.PopulateDropDownList(ddlLocation, dbInteract.PopulateDDLDS("mstCountry", "pk_countryid", "CountryName"));
//ddlLocation.Items[0].Text = "Select Country";
GeneralFunctions.PopulateDropDownList(ddlVesselPrefix, dbInteract.PopulateDDLDS("mstVesselPrefix", "pk_VesselPrefixID", "VesselPrefix"));
ddlVesselPrefix.Items[0].Text = "Select Prefix";
SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA];
LoadData(searchCriteria.SortExpression, searchCriteria.SortDirection);
}
}
private void SaveData(string VesselId)
{
BLL.DBInteraction dbinteract = new BLL.DBInteraction();
bool isedit = VesselId != "-1" ? true : false;
if (!isedit)
{
// if (dbinteract.GetPort(-1, txtPortCode.Text.Trim(), "").Tables[0].Rows.Count > 0)
if (!dbinteract.IsUnique("trnVessel", "VesselName", txtVesselName.Text.Trim()))
{
GeneralFunctions.RegisterAlertScript(this, "Vessel Name must be unique. Please try with another one.");
return;
}
}
Entity.Vessel vessel = new Entity.Vessel();
vessel.VesselID = Convert.ToInt32(VesselId);
vessel.AgentCode = txtAgentCode.Text.ToUpper();
//vessel.CallSign = txtCallSign.Text;
vessel.IMONumber = txtIMO.Text.ToUpper();
//string port = ((TextBox)AutoCompletepPort1.FindControl("txtPort")).Text;
//port = port.Contains(',') && port.Split(',').Length >= 1 ? port.Split(',')[1].Trim() : "";
//vessel.LastPortCalled = dbinteract.GetId("Port", port);
vessel.MasterName = txtMasterCode.Text.ToUpper();
vessel.PANNo = txtPan.Text.ToUpper();
vessel.ShippingLineCode = txtShipLineCode.Text.ToUpper();
vessel.VesselFlag = dbinteract.GetId("Country", ((TextBox)AutoCompleteCountry1.FindControl("txtCountry")).Text);
vessel.VesselName = txtVesselName.Text.ToUpper();
vessel.VesselPrefix = Convert.ToInt32(ddlVesselPrefix.SelectedValue);
vessel.CallSign = TxtCallSign.Text.ToUpper();
vessel.VesselAbbr = txtVesselAbbr.Text.ToUpper();
//if (vessel.LastPortCalled == 0)
//{
// GeneralFunctions.RegisterAlertScript(this, "Last_Port_Called is Invalid. Please rectify.");
// return;
//}
if (vessel.VesselFlag == 0)
{
GeneralFunctions.RegisterAlertScript(this, "Vessel_Flag is Invalid. Please rectify.");
return;
}
else if (ddlVesselPrefix.SelectedValue == "0")
{
GeneralFunctions.RegisterAlertScript(this, "Please Select a vessel prefix first");
return;
}
int result = dbinteract.AddEditVessel(_userId, isedit, vessel);
if (result > 0)
{
Response.Redirect("~/MasterModule/ManageVessel.aspx");
}
else
{
GeneralFunctions.RegisterAlertScript(this, "Error Occured");
}
}
