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