private void port_DataReceived(object sender, SerialDataReceivedEventArgs s)
{
try
{
SyncLock.WaitOne();
BarcodeTransaction bt = new BarcodeTransaction();
SerialPort sp = (SerialPort)sender;
string ReadData = sp.ReadExisting();
string ModSerNum = ReadData.Substring(0, 14);
int ReaderID = 1;
//if (!Int32.TryParse(ReadData.Substring(15, 2), out ReaderID))
// throw new FormatException("Can not parse Barcode Reader ID" + ReadData.Substring(15, 2).ToString());
bt.ModuleSerialNumber = ModSerNum;
bt.LaminatorBarcodeReaderMappingID = brdao.GetBarcodeReaderLaminatorMappingIDByBarcodeReaderID(ReaderID);
bt.CreationTime = System.DateTime.Now;
btdao.InsertNewBarcodeReaderTransaction(bt);
SyncLock.ReleaseMutex();
}
catch (FormatException fe)
{
logger.Error(fe.Message.ToString());
}
catch (SqlException se)
{
logger.Error(se.Message.ToString());
}
catch (Exception ex)
{
logger.Error(ex.Message.ToString());
}
}
private void BarcodeTransDGV_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex >= 0 && e.RowIndex >= 0 && BarcodeTransDGV.Columns[e.ColumnIndex].Name == "Edit Transaction")
{
DataGridViewRow SelectedDgvr = BarcodeTransDGV.Rows[e.RowIndex];
BarcodeTransaction bt = new BarcodeTransaction();
bt.ID = Int64.Parse(SelectedDgvr.Cells[0].Value.ToString());
bt.ModuleSerialNumber = SelectedDgvr.Cells[1].Value.ToString();
bt.BarcodeReaderSerialNumber = SelectedDgvr.Cells[2].Value.ToString();
if (!string.IsNullOrEmpty(SelectedDgvr.Cells[5].Value.ToString()))
{
bt.ErrorID = Int32.Parse(SelectedDgvr.Cells[5].Value.ToString());
}
else
{
bt.ErrorID = 0;
}
BarcodeAdditionForm baf = new BarcodeAdditionForm(this, LoggedInUser, bt);
this.Hide();
baf.Show();
}
}
public BarcodeAdditionForm(BarcodeDetailsForm bdf, User user, BarcodeTransaction bt)
: this(bdf, user)
{
this.lbl_addbcdetails.Text = "Update Barcode Details";
this.txt_bcserial.Text = bt.ModuleSerialNumber.ToString();
this.dd_bcrserial.SelectedText = bt.BarcodeReaderSerialNumber.ToString();
BarcodeTransactionID = bt.ID;
BarcodeTransErrorID = bt.ErrorID;
BarcodeReaderSerialNumber = bt.BarcodeReaderSerialNumber;
if (!string.IsNullOrEmpty(BarcodeReaderSerialNumber))
{
this.dd_bcrserial.SelectedIndex = dd_bcrserial.FindStringExact(BarcodeReaderSerialNumber);
}
}
public int InsertNewBarcodeReaderTransaction(BarcodeTransaction bt)
{
int NumRowsAffected = 0;
try
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("sp_SaveBarcodeTransaction", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (bt.ID > 0)
{
cmd.Parameters.AddWithValue("@BarcodeTransactionID", bt.ID);
}
cmd.Parameters.AddWithValue("@ModSerNum", bt.ModuleSerialNumber);
cmd.Parameters.AddWithValue("@LaminatorBarcodeReaderMappingID", bt.LaminatorBarcodeReaderMappingID);
cmd.Parameters.AddWithValue("@CreationTime", bt.CreationTime);
if (bt.ErrorID > 0)
{
cmd.Parameters.AddWithValue("@ErrorID", bt.ErrorID);
cmd.Parameters.AddWithValue("@IsErrorResolved", bt.IsErrorResolved);
}
NumRowsAffected = Convert.ToInt32(cmd.ExecuteScalar());
}
}
catch (SqlException se)
{
throw se;
}
catch (Exception ex)
{
throw ex;
}
return(NumRowsAffected);
}
private void btn_submit_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txt_bcserial.Text))
{
MessageBox.Show("Please provide barcode serial number", "Validation:");
}
else
{
string BarcodeSerialNumber = txt_bcserial.Text;
int BarcodeReaderSerial = 0;
if (!Int32.TryParse(dd_bcrserial.SelectedValue.ToString(), out BarcodeReaderSerial))
{
throw new FormatException("Can not parse barcode reader serial number");
}
int bcrlamnummap = brdao.GetBarcodeReaderLaminatorMappingIDByBarcodeReaderID(BarcodeReaderSerial);
DateTime BarcodeCreationDate = System.DateTime.Now;
BarcodeTransaction bt = new BarcodeTransaction();
bt.ID = BarcodeTransactionID;
bt.ModuleSerialNumber = BarcodeSerialNumber;
bt.LaminatorBarcodeReaderMappingID = bcrlamnummap;
bt.CreationTime = BarcodeCreationDate;
if (BarcodeTransactionID > 0)
{
bt.IsErrorResolved = true;
bt.ErrorID = BarcodeTransErrorID;
}
long NumRowsAffected = btdao.InsertNewBarcodeReaderTransaction(bt);
bt.BarcodeReaderSerialNumber = brdao.GetReaderDetailsByReaderID(BarcodeReaderSerial).Rows[0]["SerialNumber"].ToString();
bt.LaminatorNumber = ldao.GetLaminatorDetailsByBarcodeReaderLaminatorMappingID(bcrlamnummap).Rows[0]["LaminatorNumber"].ToString();
if (BarcodeTransactionID > 0)
{
eru.EditExcelEntries(bt.ID.ToString(), bt.ModuleSerialNumber, bt.BarcodeReaderSerialNumber, bt.LaminatorNumber);
}
else
{
bt.ID = NumRowsAffected;
eru.UpdateExcelFromExternalApplications(bt.ID, bt.ModuleSerialNumber, bt.BarcodeReaderSerialNumber, bt.LaminatorNumber, bt.CreationTime.ToString());
}
MessageBox.Show("Barcode transaction saved successfully", "Success:");
}
}
catch (SqlException se)
{
if (se.Number == 2627)
{
MessageBox.Show("Entry with same module serial number already exists in database, duplicate entries are not allowed.", "Duplicates:");
}
else
{
MessageBox.Show("SQL Exception thrown at PopulateBarcodeReaderDD(): " + se.Message, "Database Exception:");
}
}
catch (Exception ex)
{
MessageBox.Show("Exception thrown at PopulateBarcodeReaderDD(): " + ex.Message, "Exception:");
}
}
