public DataTable sendDeliveryToSQL(GrainLoadPickup u) { DataTable dt = new DataTable(); return(dt); }
public DataTable sendPickupToSQL(GrainLoadPickup u) { DataTable dt = new DataTable(); using (var conn = new SqlConnection(Properties.Settings.Default.SqlConQuery)) try { using (var command = new SqlCommand("Update_GrainLoads_Pickup", conn) { CommandType = CommandType.StoredProcedure }) { conn.Open(); command.Parameters.Clear(); command.Parameters.AddWithValue("@id_GrainLoad", (object)u.id_grainload ?? DBNull.Value); command.Parameters.AddWithValue("id_customer", u.id_customer); command.Parameters.AddWithValue("@ID_Pickup_Location", u.id_pickup_location); command.Parameters.AddWithValue("@ID_GrainType", u.id_grainType); command.Parameters.AddWithValue("@ID_Driver", u.id_driver); command.Parameters.AddWithValue("@who", u.id_who); command.Parameters.AddWithValue("@regdate", u.regdate); command.Parameters.AddWithValue("@Release", u.release); command.Parameters.AddWithValue("@Factura", u.factura); command.Parameters.AddWithValue("@Pickup_Date", u.pickup_date); command.Parameters.AddWithValue("@Pickup_Ticket", u.pickup_ticket); command.Parameters.AddWithValue("@Gross_Pickup", u.gross_pickup); command.Parameters.AddWithValue("@Tare_Pickup", u.tare_pickup); command.Parameters.AddWithValue("@Neto_Pickup ", u.neto_pickup); var Smsg = command.Parameters.Add("msg", SqlDbType.VarChar); Smsg.Direction = ParameterDirection.ReturnValue; var IDS = command.Parameters.Add("ID", SqlDbType.VarChar); IDS.Direction = ParameterDirection.ReturnValue; var Val = command.Parameters.Add("Validacion", SqlDbType.VarChar); Val.Direction = ParameterDirection.ReturnValue; using (SqlDataReader dr = command.ExecuteReader()) { dt.Load(dr); } conn.Close(); } //Console.WriteLine(dt.Rows[0].ItemArray[1].ToString()+"+"); } catch (SqlException a) { Console.WriteLine("The process failed: {0}", a.ToString()); } return(dt); }
private void btn_SavePickup_Click(object sender, EventArgs e) { newentry = new GrainLoadPickup(); newentry.release = edt_release.Text; newentry.factura = edt_factura.Text; newentry.id_driver = (Guid)lue_driver.EditValue; newentry.pickup_date = (DateTime)dte_Pickup.EditValue; newentry.id_customer = (Guid)lue_customer.EditValue; newentry.pickup_ticket = edt_pickupticket.Text; newentry.id_pickup_location = (Guid)lue_locationPickup.EditValue; newentry.id_grainType = (Guid)lue_GrainType.EditValue; newentry.gross_pickup = Convert.ToInt32(edt_grossPickup.Text); newentry.tare_pickup = Convert.ToInt32(edt_tarePickup.Text); newentry.neto_pickup = Convert.ToInt32(edt_netoPickup.Text); newentry.regdate = DateTime.Now; this.DialogResult = DialogResult.OK; this.Close(); }
private GrainLoadPickup setPickupLoad() { if (grv_Grainloads.SelectedRowsCount == 1) { ne = new GrainLoadPickup(); ne.id_grainload = (Guid)grv_Grainloads.GetFocusedRowCellValue("ID_GrainLoad"); ne.release = grv_Grainloads.GetFocusedRowCellValue("Release").ToString(); ne.factura = grv_Grainloads.GetFocusedRowCellValue("Factura").ToString(); ne.id_driver = (Guid)grv_Grainloads.GetFocusedRowCellValue("ID_Driver"); ne.pickup_date = (DateTime)grv_Grainloads.GetFocusedRowCellValue("Pickup_Date"); ne.id_customer = (Guid)grv_Grainloads.GetFocusedRowCellValue("ID_Customer"); ne.pickup_ticket = grv_Grainloads.GetFocusedRowCellValue("Pickup_Ticket").ToString(); ne.id_pickup_location = (Guid)grv_Grainloads.GetFocusedRowCellValue("ID_Pickup_Location"); ne.id_grainType = (Guid)grv_Grainloads.GetFocusedRowCellValue("ID_GrainType"); ne.gross_pickup = Convert.ToInt32(grv_Grainloads.GetFocusedRowCellValue("Gross_Pickup")); ne.tare_pickup = Convert.ToInt32(grv_Grainloads.GetFocusedRowCellValue("Tare_Pickup")); ne.neto_pickup = Convert.ToInt32(grv_Grainloads.GetFocusedRowCellValue("Neto_Pickup")); ne.regdate = DateTime.Now; } Console.WriteLine(ne.release); return(ne); }
public frm_DeliveryCapt(GrainLoadPickup sglp) { InitializeComponent(); Console.WriteLine(sglp.id_grainload); GLP = sglp; }