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);
}
}
