public List <AESLineItem> GetAESLineItems(int AESID, int ELT_ACCOUNT_NUMBER, string MAWB, string HAWB, string FileType)
{
SqlConnection conn = new SqlConnection(GetConnectionString(AppConstants.DB_CONN_PROD));
SqlCommand cmd = new SqlCommand()
{
Connection = conn, CommandType = CommandType.StoredProcedure, CommandText = "dbo.[GetAESLineItems]"
};
List <AESLineItem> list = new List <AESLineItem>();
try
{
cmd.Parameters.Add(new SqlParameter("@ELT_ACCOUNT_NUMBER", ELT_ACCOUNT_NUMBER));
cmd.Parameters.Add(new SqlParameter("@AESID", AESID));
cmd.Parameters.Add(new SqlParameter("@MAWB", MAWB));
cmd.Parameters.Add(new SqlParameter("@HAWB", HAWB));
cmd.Parameters.Add(new SqlParameter("@file_type", FileType));
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
AESLineItem item = new AESLineItem()
{
AesID = AESID,
ID = Convert.ToInt32(reader["ID"]),
Origin = Convert.ToString(reader["dfm"]),
VehicleID = Convert.ToString(reader["vin"]),
ScheduleB = Convert.ToString(reader["b_number"]),
Qty1 = Convert.ToInt32(reader["b_qty1"]),
Qty2 = Convert.ToInt32(reader["b_qty2"]),
Unit1 = Convert.ToString(reader["unit1"]),
Unit2 = Convert.ToString(reader["unit2"]),
GrossWeight = Convert.ToString(reader["gross_weight"]),
ItemValue = Convert.ToString(reader["item_value"]),
ItemDesc = Convert.ToString(reader["item_desc"]),
ExportCode = Convert.ToString(reader["export_code"]),
LicenseType = Convert.ToString(reader["license_type"]),
LicenseNumber = Convert.ToString(reader["license_number"]),
VehicleIDType = Convert.ToString(reader["vin_type"]),
VehicleTitle = Convert.ToString(reader["vc_title"]),
VihicleState = Convert.ToString(reader["vc_state"]),
ECCN = Convert.ToString(reader["eccn"]),
};
list.Add(item);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
public void UpdateAESLineItem(AESLineItem AESAirLineItem)
{
AirExportBL AirExportBL = new AirExportBL();
AESAirLineItem.ELT_ACCOUNT_NUMBER = ELT_ACCOUNT_NUMBER;
var AirAESLineItems = (List <AESLineItem>)HttpContext.Current.Session["AESLineItems"];
var item = (from c in AirAESLineItems where c.ID == AESAirLineItem.ID select c).Single();
item.IsModified = true;
item.GrossWeight = AESAirLineItem.GrossWeight;
item.ExportCode = AESAirLineItem.ExportCode;
item.ECCN = AESAirLineItem.ECCN;
item.ID = AESAirLineItem.ID;
item.ItemDesc = AESAirLineItem.ItemDesc;
item.ScheduleB = AESAirLineItem.ScheduleB;
item.Unit1 = AESAirLineItem.Unit1;
item.Unit2 = AESAirLineItem.Unit2;
item.VehicleID = AESAirLineItem.VehicleID;
item.VehicleIDType = AESAirLineItem.VehicleIDType;
item.VehicleTitle = AESAirLineItem.VehicleTitle;
item.VihicleState = AESAirLineItem.VihicleState;
item.Qty1 = AESAirLineItem.Qty1;
item.Qty2 = AESAirLineItem.Qty2;
item.Origin = AESAirLineItem.Origin;
item.LicenseType = AESAirLineItem.LicenseType;
item.LicenseNumber = AESAirLineItem.LicenseNumber;
item.ItemNo = AESAirLineItem.ItemNo;
item.ItemDesc = AESAirLineItem.ItemDesc;
item.VehicleID = AESAirLineItem.VehicleID;
item.VehicleIDType = AESAirLineItem.VehicleIDType;
item.ItemValue = AESAirLineItem.ItemValue;
}
public void InsertAESLineItem(AESLineItem AESAirLineItem)
{
AirExportBL AirExportBL = new AirExportBL();
AESAirLineItem.ELT_ACCOUNT_NUMBER = ELT_ACCOUNT_NUMBER;
var AirAESLineItems = (List <AESLineItem>)HttpContext.Current.Session["AESLineItems"];
AirAESLineItems.Add(AESAirLineItem);
}
public void DeleteAESLineItem(AESLineItem AESAirLineItem)
{
AirExportBL AirExportBL = new AirExportBL();
var AirAESLineItems = (List <AESLineItem>)HttpContext.Current.Session["AESLineItems"];
if (HttpContext.Current.Session["AESLineItemsToDelete"] == null)
{
HttpContext.Current.Session["AESLineItemsToDelete"] = new List <int>();
}
var AirAESLineItemsToDelete = (List <int>)HttpContext.Current.Session["AESLineItemsToDelete"];
var item = (from c in AirAESLineItems where c.ID == AESAirLineItem.ID select c).Single();
AirAESLineItemsToDelete.Add(item.ID);
AirAESLineItems.Remove(item);
}
public void UpdateAESLineItem(AESLineItem AESAirLineItem)
{
SqlConnection conn = new SqlConnection(GetConnectionString(AppConstants.DB_CONN_PROD));
SqlCommand cmd = new SqlCommand()
{
Connection = conn, CommandType = CommandType.StoredProcedure, CommandText = "dbo.[UpdateAESLineItem]"
};
try
{
cmd.Parameters.Add(new SqlParameter("@id", AESAirLineItem.ID));
cmd.Parameters.Add(new SqlParameter("@item_no", AESAirLineItem.ItemNo));
cmd.Parameters.Add(new SqlParameter("@dfm", AESAirLineItem.Origin));
cmd.Parameters.Add(new SqlParameter("@b_number", AESAirLineItem.ScheduleB));
cmd.Parameters.Add(new SqlParameter("@item_desc", AESAirLineItem.ItemDesc));
cmd.Parameters.Add(new SqlParameter("@b_qty1", AESAirLineItem.Qty1));
cmd.Parameters.Add(new SqlParameter("@unit1", AESAirLineItem.Unit1));
cmd.Parameters.Add(new SqlParameter("@b_qty2", AESAirLineItem.Qty2));
cmd.Parameters.Add(new SqlParameter("@unit2", AESAirLineItem.Unit2));
cmd.Parameters.Add(new SqlParameter("@gross_weight", AESAirLineItem.GrossWeight));
cmd.Parameters.Add(new SqlParameter("@vin_type", AESAirLineItem.VehicleIDType));
cmd.Parameters.Add(new SqlParameter("@vin", AESAirLineItem.VehicleID));
cmd.Parameters.Add(new SqlParameter("@vc_title", AESAirLineItem.VehicleTitle));
cmd.Parameters.Add(new SqlParameter("@vc_state", AESAirLineItem.VihicleState));
cmd.Parameters.Add(new SqlParameter("@item_value", AESAirLineItem.ItemValue));
cmd.Parameters.Add(new SqlParameter("@export_code", AESAirLineItem.ExportCode));
cmd.Parameters.Add(new SqlParameter("@license_type", AESAirLineItem.LicenseType));
cmd.Parameters.Add(new SqlParameter("@aes_id", AESAirLineItem.AesID));
cmd.Parameters.Add(new SqlParameter("@eccn", AESAirLineItem.ECCN));
cmd.Parameters.Add(new SqlParameter("@license_number", AESAirLineItem.LicenseNumber));
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
}
}
public void UpdateAESLineItem(AESLineItem AESAirLineItem)
{
AESDA AESDA = new AESDA();
AESDA.UpdateAESLineItem(AESAirLineItem);
}
public void InsertAESLineItem(AESLineItem AESAirLineItem)
{
AESDA AESDA = new AESDA();
AESDA.InsertAESLineItem(AESAirLineItem);
}
