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