public string UpdateFHLinfoImport(Int32 AWBSNo, Int32 ArrivedShipmentSNo, Int32 HAWBSNo, ImportHAWBInformation HAWBInformation, ImportShipperInformation ShipperInformation, ImportConsigneeInformation ConsigneeInformation, ImportChargeDeclarations ChargeDeclarationsInformation, List <ImportAWBOCIModel> OCIInformation, Int32 UpdatedBy, Int32 ShipperSno, Int32 ConsigneeSno, string HSCode, string CreateShipperTaxParticipants, string CreateConsigneeTaxParticipants, string CreateShipperTaxId, string CreateConsigneeTaxId) { List <ImportHAWBInformation> lstHAWBInformation = new List <ImportHAWBInformation>(); lstHAWBInformation.Add(HAWBInformation); DataTable dtHAWBInformation = CollectionHelper.ConvertTo(lstHAWBInformation, ""); List <ImportShipperInformation> lstShipperInformation = new List <ImportShipperInformation>(); lstShipperInformation.Add(ShipperInformation); DataTable dtShipperInformation = CollectionHelper.ConvertTo(lstShipperInformation, ""); List <ImportConsigneeInformation> lstConsigneeInformation = new List <ImportConsigneeInformation>(); lstConsigneeInformation.Add(ConsigneeInformation); DataTable dtConsigneeInformation = CollectionHelper.ConvertTo(lstConsigneeInformation, ""); List <ImportChargeDeclarations> lstChargeDeclarationsInformation = new List <ImportChargeDeclarations>(); lstChargeDeclarationsInformation.Add(ChargeDeclarationsInformation); DataTable dtChargeDeclarationsInformation = CollectionHelper.ConvertTo(lstChargeDeclarationsInformation, ""); DataTable dtOCIInformation = CollectionHelper.ConvertTo(OCIInformation, ""); BaseBusiness baseBusiness = new BaseBusiness(); SqlParameter paramHAWBInformation = new SqlParameter(); paramHAWBInformation.ParameterName = "@HAWBInformation"; paramHAWBInformation.SqlDbType = System.Data.SqlDbType.Structured; paramHAWBInformation.Value = dtHAWBInformation; SqlParameter paramShipperInformation = new SqlParameter(); paramShipperInformation.ParameterName = "@ShipperInformation"; paramShipperInformation.SqlDbType = System.Data.SqlDbType.Structured; paramShipperInformation.Value = dtShipperInformation; SqlParameter paramConsigneeInformation = new SqlParameter(); paramConsigneeInformation.ParameterName = "@ConsigneeInformation"; paramConsigneeInformation.SqlDbType = System.Data.SqlDbType.Structured; paramConsigneeInformation.Value = dtConsigneeInformation; SqlParameter paramChargeDeclarationsInformation = new SqlParameter(); paramChargeDeclarationsInformation.ParameterName = "@ChargeDeclarationsInformation"; paramChargeDeclarationsInformation.SqlDbType = System.Data.SqlDbType.Structured; paramChargeDeclarationsInformation.Value = dtChargeDeclarationsInformation; SqlParameter paramOCIInformation = new SqlParameter(); paramOCIInformation.ParameterName = "@OCIInformation"; paramOCIInformation.SqlDbType = System.Data.SqlDbType.Structured; paramOCIInformation.Value = dtOCIInformation; DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@AWBSNo", AWBSNo), new SqlParameter("@ArrivedShipmentSNo", ArrivedShipmentSNo), new SqlParameter("@HAWBSNo", HAWBSNo), paramHAWBInformation, paramShipperInformation, paramConsigneeInformation, paramChargeDeclarationsInformation, paramOCIInformation, new SqlParameter("@UpdatedBy", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()), new SqlParameter("@ShipperSno", ShipperSno), new SqlParameter("@ConsigneeSno", ConsigneeSno), new SqlParameter("@HSCodeSNo", HSCode) , new SqlParameter("@CreateShipperTaxParticipants", CreateShipperTaxParticipants), new SqlParameter("@CreateConsigneeTaxParticipants", CreateConsigneeTaxParticipants), new SqlParameter("@CreateShipperTaxId", CreateShipperTaxId), new SqlParameter("@CreateConsigneeTaxId", CreateConsigneeTaxId) }; //SqlParameter[] Parameters = { new SqlParameter("@AWBSNo", AWBSNo), paramHAWBInformation, new SqlParameter("@UpdatedBy", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()), new SqlParameter("@ShipperSno", ShipperSno), new SqlParameter("@ConsigneeSno", ConsigneeSno) }; DataSet ds1 = new DataSet(); try { ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, "UpdateFHLinfoExport", Parameters); return(ds.Tables[ds.Tables.Count - 1].Rows[0][0].ToString()); } catch (Exception ex) // (Exception ex) { return(ex.Message); } }
public string UpdateShipperAndConsigneeInformation(Int32 AWBSNo, ImportShipperInformation ShipperInformation, ImportConsigneeInformation ConsigneeInformation, ImportNotifyDetails NotifyModel, ImportNominyDetails NominyModel, ImportAgentModelDetail AgentModel, Int32 UpdatedBy, Int32 ShipperSno, Int32 ConsigneeSno) { List <ImportShipperInformation> lstShipperInformation = new List <ImportShipperInformation>(); lstShipperInformation.Add(ShipperInformation); DataTable dtShipperInformation = CollectionHelper.ConvertTo(lstShipperInformation, ""); BaseBusiness baseBusiness = new BaseBusiness(); List <ImportConsigneeInformation> lstConsigneeInformation = new List <ImportConsigneeInformation>(); lstConsigneeInformation.Add(ConsigneeInformation); DataTable dtConsigneeInformation = CollectionHelper.ConvertTo(lstConsigneeInformation, ""); List <ImportNotifyDetails> lstNotifyInformation = new List <ImportNotifyDetails>(); lstNotifyInformation.Add(NotifyModel); DataTable dtNotifyDetails = CollectionHelper.ConvertTo(lstNotifyInformation, ""); List <ImportNominyDetails> lstNominyInformation = new List <ImportNominyDetails>(); lstNominyInformation.Add(NominyModel); DataTable dtNominyDetails = CollectionHelper.ConvertTo(lstNominyInformation, ""); List <ImportAgentModelDetail> lstImportAgentModelDetail = new List <ImportAgentModelDetail>(); lstImportAgentModelDetail.Add(AgentModel); DataTable dtImportAgentModelDetail = CollectionHelper.ConvertTo(lstImportAgentModelDetail, ""); SqlParameter paramShipperInformation = new SqlParameter(); paramShipperInformation.ParameterName = "@ShipperInformation"; paramShipperInformation.SqlDbType = System.Data.SqlDbType.Structured; paramShipperInformation.Value = dtShipperInformation; SqlParameter paramConsigneeInformation = new SqlParameter(); paramConsigneeInformation.ParameterName = "@ConsigneeInformation"; paramConsigneeInformation.SqlDbType = System.Data.SqlDbType.Structured; paramConsigneeInformation.Value = dtConsigneeInformation; SqlParameter paramNotifyDetails = new SqlParameter(); paramNotifyDetails.ParameterName = "@NotifyDetails"; paramNotifyDetails.SqlDbType = System.Data.SqlDbType.Structured; paramNotifyDetails.Value = dtNotifyDetails; SqlParameter paramNominyDetails = new SqlParameter(); paramNominyDetails.ParameterName = "@NominyDetails"; paramNominyDetails.SqlDbType = System.Data.SqlDbType.Structured; paramNominyDetails.Value = dtNominyDetails; SqlParameter paramImportAgentModelDetail = new SqlParameter(); paramImportAgentModelDetail.ParameterName = "@ImportAgentModelDetail"; paramImportAgentModelDetail.SqlDbType = System.Data.SqlDbType.Structured; paramImportAgentModelDetail.Value = dtImportAgentModelDetail; DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@AWBSNo", AWBSNo), paramShipperInformation, paramConsigneeInformation, paramNotifyDetails, paramNominyDetails, paramImportAgentModelDetail, new SqlParameter("@UpdatedBy", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()), new SqlParameter("@ShipperSno", ShipperSno), new SqlParameter("@ConsigneeSno", ConsigneeSno) }; DataSet ds1 = new DataSet(); try { ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, "UpdateShipperAndConsigneeInformationImport", Parameters); return(ds.Tables[ds.Tables.Count - 1].Rows[0][0].ToString()); } catch (Exception ex) // (Exception ex) { return(ex.Message); } }