public void BookingReconSelectTest()
{
var booking = new clsBookingsABS();
booking.setConnectionString("server=Gawie-MW\\SQLEXPRESS ;DataBase=PAS_DNK_Syncromine ;user id=mineware ; password=corialanus;");
var meh = booking.LoadBookingRecon("201709", "RECCHHB", "2017/08/24");
}
public void BookingReconInsertTest()
{
var booking = new clsBookingsABS();
booking.setConnectionString("server=Gawie-MW\\SQLEXPRESS ;DataBase=PAS_DNK_Syncromine ;user id=mineware ; password=corialanus;");
var bookingModels = booking.LoadBookingRecon("201709", "RECCHHB", "2017/08/24").ToList();
var item = bookingModels.FirstOrDefault();
item.ReconFaceLength = Convert.ToDecimal(3.2);
item.ReconAdvance = Convert.ToDecimal(7.2);
item.ReconCubics = Convert.ToDecimal(9.2);
item.UserId = "Gawie";
var meh = booking.SaveBookingRecon(bookingModels);
}
private void LoadData()
{
var booking = new clsBookingsABS();
booking.setConnectionString(ConnectionString);
if (loaded == "N")
{
//_reconResult.Clear();
//gridgridControl1.Data();
_reconResult = booking.LoadBookingRecon(Prodmonth, SectionId, Calendardate).ToList();
gridControl1.DataSource = _reconResult;
loaded = "Y";
foreach (var recon in _reconResult)
{
if (recon.Activity == "Stoping")
{
gcReconAdvance.Visible = false;
gcProgAdvance.Visible = false;
gcProgFaceLength.Visible = true;
gcReconFaceLength.Visible = true;
}
else
{
gcProgFaceLength.Visible = false;
gcReconFaceLength.Visible = false;
//gcReconAdvance.Visible = true;
//gcProgAdvance.Visible = true;
//gcProgFaceLength.Visible = false;
//gcReconFaceLength.Visible = false;
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
btnSave.Focus();
// gridView1.PostEditor();
var booking = new clsBookingsABS();
booking.setConnectionString(ConnectionString);
string message = "";
string message2 = "";
string Validation = "Y";
foreach (var recon in _reconResult)
{
if (recon.MOComment == "" && recon.MOFC < recon.MonthPlan)
{
message = "Please provide a reason why you are forecasting less for " + recon.Workplace;
MessageBox.Show(message, "Unsuccessful", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error);
//LoadData();
Validation = "N";
return;
// recon.ReconFaceLength = recon.ProgressiveFaceLength;
}
}
foreach (var recon in _reconResult)
{
decimal reconsqm = 0;
//Validation = "Y";
string aa = "";
if (recon.MOComment == null)
{
aa = "";
recon.MOComment = "";
}
else
{
aa = recon.MOComment;
recon.MOComment = aa;
}
//if (recon.MOComment == "" && recon.MOFC < recon.MonthPlan)
//{
// message = "Please provide a reason why you are forecasting less for " + recon.Workplace;
// MessageBox.Show(message, "Unsuccessful", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error);
// //LoadData();
// Validation = "N";
// return;
// // recon.ReconFaceLength = recon.ProgressiveFaceLength;
//}
reconsqm = recon.ReconFaceLength - recon.ProgressiveFaceLength;
///Save bookings after validation
if (Validation == "Y")
{
if (reconsqm < 0)
{
//reconsqm = recon.ProgressiveFaceLength - recon.ReconFaceLength;
}
else if (reconsqm > 0)
{
//reconsqm = recon.ReconFaceLength - recon.ProgressiveFaceLength;
}
if (reconsqm != 0)
{
//recon.ReconFaceLength = recon.ReconFaceLength - reconsqm;
}
else
{
//recon.ReconFaceLength = recon.ReconFaceLength;
}
recon.ReconFaceLength = reconsqm;
if (recon.UserId == null)
{
recon.UserId = "";
}
else
{
recon.UserId = recon.UserId;
}
if (recon.MOComment == null)
{
recon.MOComment = "";
}
// recon.ReconFaceLength = recon.ReconFaceLength + reconsqm;
recon.ReconFaceLength = reconsqm;
if (ValidateRecon())
{
// if (ValidateRecon.)
recon.Approved = BlastBar;
}
}
else
{
if (reconsqm < 0)
{
reconsqm = recon.ProgressiveFaceLength - recon.ReconFaceLength;
}
else if (reconsqm > 0)
{
reconsqm = recon.ReconFaceLength - recon.ProgressiveFaceLength;
}
if (reconsqm != 0)
{
recon.ReconFaceLength = recon.ReconFaceLength - reconsqm;
}
else
{
//recon.ReconFaceLength = recon.ReconFaceLength;
}
//recon.ReconFaceLength = reconsqm;
recon.ReconFaceLength = recon.ProgressiveFaceLength + reconsqm;
}
}
if (Validation == "Y")
{
Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Successful", "Recon Updated Succesfully", Color.CornflowerBlue);
booking.SaveBookingRecon(_reconResult);
//_reconResult.Clear();
this.Close();
}
//if (Validation == "Y")
//{
// // Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Successful", "Recon Updated Succesfully", Color.CornflowerBlue);
// booking.SaveBookingRecon(_reconResult);
// //_reconResult.Clear();
// //this.Close();
//}
}
