protected void btnSave_Click(object sender, EventArgs e)
{
var import_Shipment_Header_Model = new Import_Shipment_Header_Model
{
Brokerage = Convert.ToDecimal(txtBrokerage.Text),
CEDEC = Convert.ToDecimal(txtCEDEC.Text),
CustomsStamps = Convert.ToDecimal(txtCustomsStamps.Text),
DeliveryCharges = Convert.ToDecimal(txtDeliveryCharges.Text),
DocumentaryStamps = Convert.ToDecimal(txtDocumentaryStamps.Text),
DocumentationCharges = Convert.ToDecimal(txtDocumentationCharges.Text),
ForkliftCost = Convert.ToDecimal(txtForkliftCost.Text),
FreightCharges = Convert.ToDecimal(txtFreightCharges.Text),
HandlingFee = Convert.ToDecimal(txtHandlingFee.Text),
ImportationInsurance = Convert.ToDecimal(txtImportationInsurance.Text),
ImportDuties = Convert.ToDecimal(txtImportDuties.Text),
ImportProcessingFee = Convert.ToDecimal(txtImportProcessingFee.Text),
Miscellaneous = Convert.ToDecimal(txtMiscellaneous.Text),
NotarialFee = Convert.ToDecimal(txtNotarialFee.Text),
OtherCharges = Convert.ToDecimal(txtOtherCharges.Text),
ProcessingFee = Convert.ToDecimal(txtProcessingFee.Text),
WarehouseStorageCharges = Convert.ToDecimal(txtWarehouseStorageCharges.Text),
Xerox = Convert.ToDecimal(txtXerox.Text),
ImportShipmentNumber = txtImpShipNum.Text,
Total_Charges = Convert.ToDecimal(txtTotalCharges.Text)
};
var ismHead = Import_Shipment_Header.Save(oCon, import_Shipment_Header_Model);
DataTable dt = (DataTable)Session["Data"];
for (int x = 0; x <= dt.Rows.Count - 1; x++)
{
var detail = new Import_Shipment_Detail_Model
{
idImpShpHead = ismHead,
idPOHeader = Convert.ToInt32(dt.Rows[x][0].ToString()),
POCharge = Convert.ToDecimal(dt.Rows[x][2].ToString())
};
Import_Shipment_Detail.Save(oCon, detail);
}
defaultSettings();
clearFlds();
//Session.Remove("Data");
GetIS();
}
public static bool Update(SqlConnection connection, Import_Shipment_Detail_Model model)
{
bool returnValue = true;
var GUID = SQL_Transact.GenerateGUID();
SQL_Transact.BeginTransaction(connection, GUID);
StringBuilder sQuery = new StringBuilder();
sQuery.Append(@"UPDATE a_Import_Shipment_Detail SET
idImpShpHead = @idImpShpHead
,idPOHeader = @idPOHeader
,POCharge = @POCharge
WHERE idImpShpDet = @idImpShpDet ");
using (SqlCommand cmd = new SqlCommand())
{
try
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter parm1 = new SqlParameter
{
ParameterName = "@idImpShpDet",
SqlDbType = SqlDbType.Int,
Value = model.idImpShpDet
};
cmd.Parameters.Add(parm1);
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@idImpShpHead",
SqlDbType = SqlDbType.Int,
Value = model.idImpShpHead
};
cmd.Parameters.Add(parm2);
SqlParameter parm3 = new SqlParameter
{
ParameterName = "@idPOHeader",
SqlDbType = SqlDbType.Int,
Value = model.idPOHeader
};
cmd.Parameters.Add(parm3);
SqlParameter parm4 = new SqlParameter
{
ParameterName = "@POCharge",
SqlDbType = SqlDbType.Decimal,
Value = model.POCharge
};
cmd.Parameters.Add(parm4);
if (cmd.ExecuteNonQuery() >= 1)
{
returnValue = true;
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.CommitTransaction(connection, GUID);
}
}
catch
{
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.RollbackTransaction(connection, GUID);
}
}
return(returnValue);
}
public static List <Import_Shipment_Detail_Model> RetrieveData(SqlConnection connection, int idImpShpHead, int idPOHeader)
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append(@"SELECT idImpShpDet
,idImpShpHead
,idPOHeader
,POCharge
FROM a_Import_Shipment_Detail
WHERE idImpShpHead = @idImpShpHead AND idPOHeader = @idPOHeader
");
var lmodel = new List <Import_Shipment_Detail_Model>();
DataTable dataTable = new DataTable();
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
//if (impshphead != 0)
//{
SqlParameter parm1 = new SqlParameter
{
ParameterName = "@idImpShpHead",
SqlDbType = SqlDbType.Int,
Value = idImpShpHead
};
cmd.Parameters.Add(parm1);
//}
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@idPOHeader",
SqlDbType = SqlDbType.Int,
Value = idPOHeader
};
cmd.Parameters.Add(parm2);
var oreader = cmd.ExecuteReader();
while (oreader.Read())
{
Import_Shipment_Detail_Model oModel = new Import_Shipment_Detail_Model
{
idImpShpDet = (int)oreader["idImpShpDet"],
idImpShpHead = (int)oreader["idImpShpHead"],
idPOHeader = (int)oreader["idPOHeader"],
POCharge = (decimal)oreader["POCharge"]
};
lmodel.Add(oModel);
}
oreader.Close();
cmd.Dispose();
}
connection.Close();
return(lmodel);
}
