private void InButton_Click(object sender, EventArgs e)
{
try
{
int delivery;
if (DeliveryNo.Checked)
{
delivery = 0;
}
else
{
delivery = 1;
}
if (!checkFields())
{
}
else
{
int Visiting = getWorker();
int res = -1;
res = getPerson();
if (res <= 0)
{
MessageBox.Show("-----");
addPerson();
res = getPerson();
}
int company = getCompany();
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO Visits(PersonID,CompanyID,Delivery,Entrance,Out,WorkerId,cardNumber,VisitingCompany,State,Address, Comment) " +
"VALUES(@PersonID,@CompanyID,@Delivery,@Entrance,@Out,@WorkerId,@cardNumber,@VisitingCompany,@State,@Address,@Comment)");
using (SqlCommand com = new SqlCommand(sb.ToString(), connection))
{
com.Parameters.Add("@PersonID", SqlDbType.Int).Value = res;
com.Parameters.Add("@CompanyID", SqlDbType.Int).Value = company;
com.Parameters.Add("@Delivery", SqlDbType.Bit).Value = delivery;
com.Parameters.Add("@Entrance", SqlDbType.DateTime).Value = DateTime.Now;
com.Parameters.Add("@Out", SqlDbType.DateTime).Value = DBNull.Value;
com.Parameters.Add("@WorkerId", SqlDbType.Int).Value = Visiting;
com.Parameters.Add("@cardNumber", SqlDbType.Int).Value = checkCard(cardNBox.Text);
com.Parameters.Add("@VisitingCompany", SqlDbType.NVarChar).Value = valuesCheck(Companybox.Text);
com.Parameters.Add("@State", SqlDbType.Bit).Value = 0;
com.Parameters.Add("@Address", SqlDbType.NVarChar).Value = addressBox.Text;
com.Parameters.Add("@Comment", SqlDbType.NVarChar).Value = commentBox.Text;
com.CommandType = CommandType.Text;
com.Connection = connection;
connection.Open();
String output = com.CommandText.ToString();
com.ExecuteNonQuery();
SqlTransaction trans = connection.BeginTransaction();
trans.Commit();
MessageBox.Show("Data Inserted!");
}
connection.Close();
clearFields();
groupBox1.Hide();
VisitingCombo.Hide();
VCompAdd.Hide();
CompCombo.Hide();
VisitingAdd.Hide();
VisitingLabel.Hide();
CompLabel.Hide();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connection.Close();
VisitorsLabel.Text = getVisitors();
}
public PostisVisitor()
{
this.Name = null;
using (StreamReader reader = new StreamReader("daysToReset.txt"))
{
String line = reader.ReadLine();
days = Int32.Parse(line.Split(null)[3]);
}
this.Name = null;
using (StreamReader reader = new StreamReader("connectDBstring.txt"))
{
string line = reader.ReadLine();
//line.Replace("/", "\\");
connectStr = line;
}
//connectStr = "Data Source=192.168.1.101"+@"\MSSQLSERVER01"+ ",1433;Network Library=DBMSSOCN;Initial Catalog=PostisVisitor;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
InitializeComponent();
connection = new SqlConnection(connectStr);
Login log = new Login(connection);
log.ShowDialog();
admin = log.getType();
log.Close();
visitorsTime();
if (!admin)
{
Configure.Hide();
Report.Hide();
}
groupBox1.Hide();
VCompAdd.Enabled = admin;
VisitingAdd.Enabled = admin;
fillCompany();
fillVisitor();
VisitingCombo.Hide();
VCompAdd.Hide();
CompCombo.Hide();
VisitingAdd.Hide();
VisitingLabel.Hide();
CompLabel.Hide();
fieldEnabler();
CompCombo.DropDownStyle = ComboBoxStyle.DropDownList;
VisitingCombo.DropDownStyle = ComboBoxStyle.DropDownList;
cardNBox.Text = null;
//ICAR
Iconstants = new IcarConstants.IcarConstants();
Icar = new ICAR();
Icar.initialize();
checkIcarError();
config = false;
Configurations conf = new Configurations(Icar, connection);
conf.configure();
this.Size = new Size(Screen.PrimaryScreen.Bounds.Width, Screen.PrimaryScreen.Bounds.Height);
this.MaximizeBox = false;
float Xratio = (float)(Screen.PrimaryScreen.Bounds.Width) / (float)(this.MinimumSize.Width);
float Yratio = (float)(Screen.PrimaryScreen.Bounds.Height) / (float)(this.MinimumSize.Height);
foreach (Control c in this.Controls)
{
float x = (float)c.Location.X * Xratio;
float y = (float)c.Location.Y * Yratio;
c.Location = new Point((int)x, (int)y);
int w = c.Width * (int)Xratio;
int h = c.Height * (int)Yratio;
c.Size = new Size(w, h);
}
Scan.Image = Image.FromFile("images/scan.png");
Exit.Image = Image.FromFile("images/exit.png");
InButton.Image = Image.FromFile("images/ok.png");
Configure.Image = Image.FromFile("images/config.png");
Visitors.Image = Image.FromFile("images/visitors.png");
Report.Image = Image.FromFile("images/report.png");
pictureBox1.Image = Image.FromFile("images/company.jpg");
groupBox2.Height = Height;
VisitorsLabel.Text = getVisitors();
}