private void SaveData(string portId) { BLL.DBInteraction dbinteract = new BLL.DBInteraction(); bool isedit = portId != "-1" ? true : false; if (!isedit) { // if (dbinteract.GetPort(-1, txtPortCode.Text.Trim(), "").Tables[0].Rows.Count > 0) if (!dbinteract.IsUnique("DSR.dbo.mstPort", "PortCode", txtPortCode.Text.Trim())) { GeneralFunctions.RegisterAlertScript(this, "Port Code must be unique. The given code has already been used for another port. Please try with another one."); return; } } int result = dbinteract.AddEditPort(_userId, Convert.ToInt32(portId), txtPortName.Text.Trim().ToUpper(), txtPortCode.Text.Trim().ToUpper(), ddlICD.SelectedIndex == 0 ? false : true, txtPortAddressee.Text.ToUpper(), txtAdd1.Text.ToUpper(), txtAdd2.Text.ToUpper(), txtExportPort.Text.ToUpper(), isedit); if (result > 0) { Response.Redirect("~/MasterModule/ManagePort.aspx"); } else { GeneralFunctions.RegisterAlertScript(this, "Error Occured"); } }
private void SaveData(string NVOCCId) { BLL.DBInteraction dbinteract = new BLL.DBInteraction(); bool isedit = NVOCCId != "-1" ? true : false; if (!isedit) { if (!dbinteract.IsUnique("exp.mstSlotOperator", "SlotOperatorName", txtSlotOperatorName.Text.Trim())) { GeneralFunctions.RegisterAlertScript(this, "Operator Name must be unique. The given name has already been used for another Line. Please try with another one."); return; } } int result = dbinteract.AddEditSlotOperator(_userId, Convert.ToInt32(NVOCCId), txtSlotOperatorName.Text.Trim(), isedit); if (result > 0) { Response.Redirect("~/Export/ManageSlotOperator.aspx"); } else { GeneralFunctions.RegisterAlertScript(this, "Error Occured"); } }
private void SaveCountry(string countryId) { BLL.DBInteraction dbinteract = new BLL.DBInteraction(); bool isedit = countryId != "-1" ? true : false; bool s = dbinteract.IsUnique("mstCountry", "CountryAbbr", txtAbbr.Text.Trim()); if (!dbinteract.IsUnique("mstCountry", "CountryAbbr", txtAbbr.Text.Trim()) && !isedit) { GeneralFunctions.RegisterAlertScript(this, "Country Abbr Must Be unique"); return; } int result = dbinteract.AddEditCountry(_userId, Convert.ToInt32(countryId), txtCountryName.Text.Trim().ToUpper(), txtAbbr.Text.Trim().ToUpper(), txtGMT.Text.ToUpper(), txtISD.Text.ToUpper(), txtSector.Text.ToUpper(), isedit); if (result > 0) { Response.Redirect("~/MasterModule/ManageCountry.aspx"); } else { GeneralFunctions.RegisterAlertScript(this, "Error Occured"); } }
private void SaveData(string NVOCCId) { BLL.DBInteraction dbinteract = new BLL.DBInteraction(); bool isedit = NVOCCId != "-1" ? true : false; if (!isedit) { if (!dbinteract.IsUnique("mstNVOCC", "NVOCCName", txtLineName.Text.Trim())) { GeneralFunctions.RegisterAlertScript(this, "Line Name must be unique. The given name has already been used for another Line. Please try with another one."); return; } } if (fuLogo.HasFile) { hdnLogo.Value = "~/MasterModule/Image/" + fuLogo.GetImageFileName(); fuLogo.PostedFile.SaveAs(Server.MapPath(hdnLogo.Value)); } else { hdnLogo.Value = ""; } decimal impComm = 0; decimal rBuffer = 0; decimal.TryParse(txtImpCommsn.Text, out impComm); decimal.TryParse(txtRBuffer.Text, out rBuffer); decimal expCommsn = 0; decimal.TryParse(txtExportCommission.Text, out expCommsn); char ExpBook = ddlExpBook.SelectedValue == "y"?'1':'0'; int result = dbinteract.AddEditLine(_userId, Convert.ToInt32(NVOCCId), txtLineName.Text.Trim(), string.IsNullOrEmpty(txtFreeDays.Text) ? -1 : Convert.ToInt32(txtFreeDays.Text), txtContact.Text, impComm, expCommsn, ExpBook, rBuffer, hdnLogo.Value, isedit); if (result > 0) { Response.Redirect("~/MasterModule/ManageLine.aspx"); } else { GeneralFunctions.RegisterAlertScript(this, "Error Occured"); } }
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"); } }