private void printPreviewDTRToolStripMenuItem_Click(object sender, EventArgs e)
{
tabControl1.SelectTab(1);
Thread.Sleep(200);
Application.DoEvents();
string SDuration = toolStripComboBoxMonth.Text.Trim() + " " + toolStripComboBoxDuration.Text.Trim();
ReportParameter p1 = new ReportParameter("EnrolleeName", textBoxName.Text.Trim());
ReportParameter p2 = new ReportParameter("DurationLabel", SDuration);
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2 });
if (System.Configuration.ConfigurationManager.AppSettings["PrintAll"] == "True")
{
DTRBindingSource.DataSource = lDTRSource;
}
else
{
var tempDTRSource = new List <DTR>();
foreach (var dtr in lDTRSource)
{
DTR d = dtr;
d.TotalHour = null;
d.TotalMinute = null;
tempDTRSource.Add(d);
}
DTRBindingSource.DataSource = tempDTRSource;
}
this.reportViewer1.RefreshReport();
}
private void InTR(string txt)
{
int tam = 0;
try
{
if (LUsuarios.InvokeRequired)
{
DTR MR = new DTR(InTR);
this.Invoke(MR, new object[] { txt });
}
else
{
if (pictureBox1.Visible)
{
SP.Play();
}
tam = TR.TextLength;
TR.AppendText(txt + "\n");
if (txt.IndexOf("dice:" + (char)31) > -1)
{
TR.Select(TR.GetFirstCharIndexFromLine(TR.GetLineFromCharIndex(TR.Find("dice:" + (char)31, tam, RichTextBoxFinds.MatchCase))), TR.GetFirstCharIndexFromLine(TR.GetLineFromCharIndex(TR.Find("dice:" + (char)31, tam, RichTextBoxFinds.MatchCase)) + 1) - TR.GetFirstCharIndexFromLine(TR.GetLineFromCharIndex(TR.Find("dice:" + (char)31, tam, RichTextBoxFinds.MatchCase))));
TR.SelectionColor = Color.Green;
}
TR.Refresh();
}
}
catch (Exception ex)
{
Funciones.Log(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase), ex.Message + ex.StackTrace.Substring(ex.StackTrace.Length - 11));
}
}
public static bool Delete(DTR dtr)
{
using (_d = new DataRepository <DTR>())
{
_d.Delete(dtr);
_d.SaveChanges();
}
return(true);
}
static IEnumerable <DTR> GetTransforms2(DTR ts)
{
yield return(ts);
foreach (Transform t in ts.transform)
{
foreach (var t2 in GetTransforms2(new DTR {
path = (ts.path + "/" + t.name), transform = t
}))
{
yield return(t2);
}
}
}
public static int Save(DTR dtr)
{
var a = new DTR
{
DTRId = dtr.DTRId,
EmployeeId = dtr.EmployeeId,
EmployeeNo = dtr.EmployeeNo,
DTRDate = dtr.DTRDate,
DTRDay = dtr.DTRDay,
TimeInAM = dtr.TimeInAM,
TimeOutAM = dtr.TimeOutAM,
TimeInPM = dtr.TimeInPM,
TimeOutPM = dtr.TimeOutPM,
TimeInOT = dtr.TimeInOT,
TimeOutOT = dtr.TimeOutOT,
TotalHours = dtr.TotalHours,
TotalHour = dtr.TotalHour,
TotalMinute = dtr.TotalMinute,
DTRStatus = dtr.DTRStatus,
IsSource = dtr.IsSource,
EditedBy = dtr.EditedBy,
EditedOn = dtr.EditedOn
};
using (_d = new DataRepository <DTR>())
{
if (dtr.DTRId > 0)
{
_d.Update(a);
}
else
{
_d.Add(a);
}
_d.SaveChanges();
}
return(a.DTRId);
}
private void dTRBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
if (dTRBindingSource != null)
{
this.Validate();
dTRBindingSource.EndEdit();
List <DTR> lDtr1 = ActionClass.FillDTRs(OEnrollee.EnrolleeId, IMonth, IYear);
var lDtr2 = new List <DTR>();
foreach (var dtr in lDTR)
{
DTR d = lDtr1.FirstOrDefault(dt => (dt.DTRDate == dtr.DTRDate));
if (d == null)
{
dtr.IsSource = false;
dtr.EditedBy = SUserName;
dtr.EditedOn = DateTime.Now;
lDtr2.Add(dtr);
}
else
{
string tempTimeInAM = (d.TimeInAM != null) ? d.TimeInAM.Trim() : null;
string tempTimeOutAM = (d.TimeOutAM != null) ? d.TimeOutAM.Trim() : null;
string tempTimeInPM = (d.TimeInPM != null) ? d.TimeInPM.Trim() : null;
string tempTimeOutPM = (d.TimeOutPM != null) ? d.TimeOutPM.Trim() : null;
string tempTimeInOT = (d.TimeInOT != null) ? d.TimeInOT.Trim() : null;
string tempTimeOutOT = (d.TimeOutOT != null) ? d.TimeOutOT.Trim() : null;
if ((tempTimeInAM != dtr.TimeInAM) || (tempTimeOutAM != dtr.TimeOutAM) ||
(tempTimeInPM != dtr.TimeInPM) || (tempTimeOutPM != dtr.TimeOutPM) ||
(tempTimeInOT != dtr.TimeInOT) || (tempTimeOutOT != dtr.TimeOutOT))
{
dtr.IsSource = false;
dtr.EditedBy = SUserName;
dtr.EditedOn = DateTime.Now;
dtr.DTRId = d.DTRId;
ActionClass.SaveDTR(dtr);
}
}
}
if (lDtr2.Count > 0)
{
int iResult = ActionClass.SaveDTR(lDtr2);
if (iResult > 0)
{
toolStripStatusLabel1.Text = "Record successfully saved. (" + lDtr2.Count.ToString() +
" record)";
Thread.Sleep(200);
Application.DoEvents();
}
else
{
toolStripStatusLabel1.Text = "Error Occured while saving data to database or duplicate record already exists.";
}
}
else
{
toolStripStatusLabel1.Text = "Record already exists.";
}
}
Cursor.Current = Cursors.Default;
}
public List <Stdf4Record> ReadStdf4(BinaryReader reader)
{
List <Stdf4Record> records;
if (this.OnlyParse)
{
records = null;
}
else
{
records = new List <Stdf4Record>(capacity: this.InitialListCapacity);
}
int pos = 0;
int recordNumber = 0;
Stdf4Record rec;
StdfValueConverter converter = new StdfValueConverter();
try
{
ushort recordLength;
while (true)
{
if (this.ReverseBytesOnRead)
{
this._twoBytes[1] = reader.ReadByte();
this._twoBytes[0] = reader.ReadByte();
recordLength = BitConverter.ToUInt16(_twoBytes, 0);
}
else
{
recordLength = reader.ReadUInt16();
}
var stdfMajorType = reader.ReadByte();
var stdfMinorType = reader.ReadByte();
int stdfRecordType = (((int)stdfMajorType) << 8) | (int)stdfMinorType;
// for a FAR record, always read 6 bytes since we don't know the byte order yet.
// Also avoiding a cast here.
byte[] bytes;
if (stdfRecordType == 10)
{
recordLength = 2;
}
bytes = reader.ReadBytes(recordLength);
pos += recordLength + 4;
recordNumber += 1;
//Three most common record types without a cast and outside the switch statement
if (this._debugLevel >= 3)
{
// Fall through to case statement for lots of printing.
}
else if (stdfRecordType == 3850)
{
if (this.OnlyParse)
{
var ignore_PTR = new PTR(bytes, converter);
}
else
{
records.Add(new PTR(bytes, converter));
}
continue;
}
else if (stdfRecordType == 1290)
{
if (this.OnlyParse)
{
var ignore_PIR = new PIR(bytes, converter);
}
else
{
records.Add(new PIR(bytes, converter));
}
continue;
}
if (this._debugLevel >= 3 || (this.Verbose && stdfMajorType != 5 && stdfMajorType != 10 && stdfMajorType != 15))
{
Console.WriteLine(string.Empty);
Console.WriteLine($" Record {recordNumber} is {recordLength} bytes long (0x{recordLength:X2}) of type {stdfMajorType} - {stdfMinorType} ({stdfRecordType}).");
if (this._debugLevel > 0)
{
Console.Write((new LavaData.Util.Debug.HexDump(bytes)).ToString());
if (this._debugLevel > 1)
{
// We want the record length and record type/sub-type.
var newBytes = new byte[bytes.Length + 4];
(newBytes[0], newBytes[1]) = converter.UshortToBytes(recordLength);
newBytes[2] = stdfMajorType;
newBytes[3] = stdfMinorType;
for (int i = 0; i < bytes.Length; i++)
{
newBytes[i + 4] = bytes[i];
}
Console.WriteLine((new LavaData.Util.Debug.HexDump(newBytes).ToHexByteString()));
}
}
}
rec = null;
if (Enum.IsDefined(typeof(Stdf4RecordType), stdfRecordType))
{
Stdf4RecordType recordType = (Stdf4RecordType)stdfRecordType;
switch ((Stdf4RecordType)stdfRecordType)
{
case Stdf4RecordType.PTR:
// UNREACHABLE CODE -- handled above, except with debug >=3
rec = new PTR(bytes, converter);
break;
case Stdf4RecordType.PIR:
// UNREACHABLE CODE -- handled above, except with debug >=3
rec = new PIR(bytes, converter);
break;
case Stdf4RecordType.PRR:
rec = new PRR(bytes, converter);
break;
case Stdf4RecordType.FAR:
var far = new FAR(bytes, converter);
converter.CpuType = far.CpuType;
this.ReverseBytesOnRead = converter.ReverseBytesOnRead;
rec = far;
break;
//Data collected on a per lot basis; 1-NN Records
case Stdf4RecordType.MIR:
rec = new MIR(bytes, converter);
break;
case Stdf4RecordType.MRR:
rec = new MRR(bytes, converter);
break;
case Stdf4RecordType.PCR:
rec = new PCR(bytes, converter);
break;
case Stdf4RecordType.HBR:
rec = new HBR(bytes, converter);
break;
case Stdf4RecordType.SBR:
rec = new SBR(bytes, converter);
break;
case Stdf4RecordType.PMR:
throw new Stdf4ParserException("PMR Not Implemented");
case Stdf4RecordType.PGR:
throw new Stdf4ParserException("PGR Not Implemented");
case Stdf4RecordType.RDR:
throw new Stdf4ParserException("RDR Not Implemented");
case Stdf4RecordType.SDR:
rec = new SDR(bytes, converter);
break;
// Data collected per Wafer; 2-NN Records.
case Stdf4RecordType.WIR:
rec = new WIR(bytes, converter);
break;
case Stdf4RecordType.WRR:
rec = new WRR(bytes, converter);
break;
case Stdf4RecordType.WCR:
rec = new WCR(bytes, converter);
break;
case Stdf4RecordType.TSR:
//throw new Stdf4ParserException("TSR Not Implemented");
break;
// Generic Data; 50-NN Records.
case Stdf4RecordType.GDR:
//throw new Stdf4ParserException("GDR Not Implemented");
break;
case Stdf4RecordType.DTR:
rec = new DTR(bytes, converter);
break;
default:
Console.WriteLine($" Unhandled STDF4 Record Type: {recordType} ({stdfMajorType} - {stdfMinorType}).");
break;
}
if (rec != null)
{
if (this._debugLevel >= 3 || (this.Verbose && stdfRecordType != 1300))
{
// Don't print PRR (1300), lots of them, except at a high debug level.
Console.WriteLine(rec.ToString());
}
if (!this.OnlyParse)
{
records.Add(rec);
}
}
}
else
{
Console.WriteLine($" No ENUM Defined for STDF4 Record Type: {stdfMajorType} - {stdfMinorType}.");
}
}
}
catch (EndOfStreamException)
{
if (this.Verbose)
{
Console.WriteLine("Read to the end of the stream!");
}
}
catch (Exception ex)
{
Console.WriteLine("Unhandled Exception: " + ex.Message);
Console.WriteLine(ex.StackTrace);
}
if (this.Verbose)
{
Console.WriteLine($"Read {recordNumber} records.");
}
return(records);
}
public bool Delete()
{
TA_TRX.Fill(DS_Master.TRX);
TA_ARRIVE.Fill(DS_Master.ARRIVE);
TA_DEPART.Fill(DS_Master.DEPART);
DTR_RESERV = DS_Master.Tables["RESERVATION"].Rows[BS_RESERVATION.Position];
int i = DTR_RESERV.GetChildRows("ARRIVE_FK_IdReser").Length;
int j = DTR_RESERV.GetChildRows("DEPART_FK_IdReser").Length;
// Pré-conditions
if (i != 0 && j != i)
{
MessageBox.Show("Le nombre d'arrivés n'est pas compatible avec le nombre de départs associés à cette réservation", "Impossible de suprimer");
return(false);
}
if (ir_Reserv.DTP_Fin.Value.AddDays(2) < DateTime.Today)
{
MessageBox.Show("Une réservation doit rester dans la base de donnée au moins 2 jours après sa date de fin.", "Impossible de suprimer");
return(false);
}
// Post-conditions
foreach (DataRow DTR in DTR_RESERV.GetChildRows("TRX_FK_IdReser"))
{
DTR["IdReser"] = DBNull.Value;
}
foreach (DataRow DTR in DTR_RESERV.GetChildRows("DE_FK_IdReser"))
{
DTR.Delete();
}
foreach (DataRow DTR in DTR_RESERV.GetChildRows("DEPART_FK_IdReser"))
{
DTR.Delete();
}
foreach (DataRow DTR in DTR_RESERV.GetChildRows("ARRIVE_FK_IdReser"))
{
DTR.Delete();
}
DTR_RESERV.Delete();
try
{
TA_TRX.Update(DS_Master.TRX);
TA_DE.Update(DS_Master.DE);
TA_ARRIVE.Update(DS_Master.ARRIVE);
TA_DEPART.Update(DS_Master.DEPART);
TA_RESERVATION.Update(DS_Master.RESERVATION);
Sync_ForeignTables();
MessageBox.Show("Reservation supprimé avec succès.", "Succès");
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(false);
}
