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