private void button1_Click(object sender, EventArgs e)
{
int griafikId;
string nomerDoc = null;
string naimenovanie = null;
DateTime?srokVypolneniya = null;
DateTime?data = null;
DateTime?dataVypolneniya = null;
int? ord = null;
outToLog(DateTime.Now + " " + " - cтарт");
using (NpgsqlConnection conPg = new NpgsqlConnection(Properties.Settings.Default.pgConStr))
{
try
{
NpgsqlCommand cmdPg = new NpgsqlCommand("insert into grafiki_meropriyatij(griafik_id, nomer_doc, naimenovanie, srok_vypolneniya, data, data_vypolneniya, ord) values (@griafik_id, @nomer_doc, @naimenovanie, @srok_vypolneniya, @data, @data_vypolneniya, @ord);", conPg);
conPg.Open();
using (OleDbConnection conOLE = new OleDbConnection(Properties.Settings.Default.connStr))
{
OleDbCommand cmdOLE = new OleDbCommand("SELECT ГрафикN, Nдокумента, НаименованиеГрафика, СрокВыполнения, Дата, ДатаВыполнения, Ord FROM ГрафикиМероприятий;", conOLE);
try
{
conOLE.Open();
OleDbDataReader reader = cmdOLE.ExecuteReader();
while (reader.Read())
{
griafikId = reader.GetInt32(0);
if (DBNull.Value != reader[1])
{
nomerDoc = reader.GetString(1);
}
if (DBNull.Value != reader[2])
{
naimenovanie = reader.GetString(2);
}
if (DBNull.Value != reader[3])
{
srokVypolneniya = reader.GetDateTime(3);
}
if (DBNull.Value != reader[4])
{
data = reader.GetDateTime(4);
}
if (DBNull.Value != reader[5])
{
dataVypolneniya = reader.GetDateTime(5);
}
if (DBNull.Value != reader[6])
{
ord = reader.GetInt32(6);
}
cmdPg.Parameters.Clear();
cmdPg.Parameters.AddWithValue("@griafik_id", griafikId);
cmdPg.Parameters.AddWithValue("@nomer_doc", nomerDoc);
cmdPg.Parameters.AddWithValue("@naimenovanie", naimenovanie);
cmdPg.Parameters.AddWithValue("@srok_vypolneniya", srokVypolneniya);
cmdPg.Parameters.AddWithValue("@data", data);
cmdPg.Parameters.AddWithValue("@data_vypolneniya", dataVypolneniya);
cmdPg.Parameters.AddWithValue("@ord", ord);
cmdPg.ExecuteScalar();
}
}
catch (Exception ex)
{
outToLog(ex.Message);
}
}
}
catch (Exception ex)
{
outToLog(ex.Message);
}
}
outToLog(DateTime.Now + " " + " - готово");
}
private void getLinkedDatabase()
{
try
{
//try 2
System.Data.OleDb.OleDbConnection conn = new OleDbConnection();
ADODB.Connection conJCMS = new ADODB.Connection();
string strConx = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;Data Source=" + updateDir.Text + ";";
conJCMS.Mode = ADODB.ConnectModeEnum.adModeReadWrite;
conJCMS.Open(strConx, "", "", 0);
ADODB.Recordset tables = new ADODB.Recordset();
tables.Open("SELECT * FROM Mouse;", conJCMS, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockBatchOptimistic, 0);
ADOX.Catalog catalog = new ADOX.Catalog();
catalog.ActiveConnection = conJCMS;
foreach (ADOX.Table tbl in catalog.Tables)
{
if (tbl.Type == "LINK")
{
string strSourceDbFullPath = tbl.Properties["Jet OLEDB:Link DataSource"].Value.ToString();
string strSourceDbPath = strSourceDbFullPath.Substring(0, strSourceDbFullPath.LastIndexOf("\\") + 1);
string strSourceDbName = strSourceDbFullPath.Substring(strSourceDbFullPath.LastIndexOf("\\") + 1);
break;
}
}
//try one
if (Environment.Is64BitOperatingSystem)
{
conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data Source=" + updateDir.Text + ";";
}
else
{
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=" + updateDir.Text + ";";
}
conn.Open();
ADOX.Catalog theCatalog = new ADOX.Catalog();
theCatalog.ActiveConnection = conn;
string databaseQuery = "SELECT * FROM Mouse;";
OleDbCommand theCommand = new OleDbCommand(databaseQuery);
theCommand.Connection = conn;
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow row in schemaTable.Rows)
{
foreach (var item in row.ItemArray)
{
Console.WriteLine(item);
}
}
OleDbDataReader theReader = theCommand.ExecuteReader();
while (theReader.Read())
{
Console.WriteLine(theReader.GetString(1));
}
conn.Close();
}
catch (Exception e) { Console.WriteLine(e); }
}
private void Hard_picturebox_Click(object sender, EventArgs e)
{
//for table 2
connection.Open();
query2 = "SELECT * FROM Table2";
OleDbCommand cmd2 = new OleDbCommand(query2, connection);
OleDbDataReader rdr2 = cmd2.ExecuteReader();
while (rdr2.Read())
{
arithmos++;
}
//for table 3
connection.Close();
connection.Open();
query3 = "SELECT * FROM Table3";
OleDbCommand cmd3 = new OleDbCommand(query3, connection);
OleDbDataReader rdr3 = cmd3.ExecuteReader();
while (rdr3.Read())
{
arithmos2++;
}
connection.Close();
level = "hard";
Random r = new Random();
int k = 0;
for (int i = 0; i < 5; i++)
{
bool f = false;
while (f == false)
{
k = r.Next(1, arithmos);
if (!x.Contains(k))
{
x[i] = k;
f = true;
}
}
}
for (int i = 5; i < x.Length; i++)
{
bool f = false;
while (f == false)
{
k = r.Next(1, arithmos2);
if (!x.Contains(k))
{
x[i] = k;
f = true;
}
}
}
connection.Open();
query = "SELECT * FROM Table2 where ID=" + x[0] + "";
OleDbCommand cmd = new OleDbCommand(query, connection);
OleDbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
question_richtextbox.Text = rdr.GetString(1);
answer_1.Text = rdr.GetString(2);
answer_2.Text = rdr.GetString(3);
answer_3.Text = rdr.GetString(4);
answer_4.Text = rdr.GetString(5);
correctAnswers[0] = Int32.Parse(rdr.GetString(6));
}
connection.Close();
timer1.Start();
// do function to start the test !
Select_difficulty_label.Text = "Difficulty : " + level;
Easy_label.Visible = false;
Medium_label.Visible = false;
Hard_label.Visible = false;
Easy_picturebox.Visible = false;
Medium_picturebox.Visible = false;
Hard_picturebox.Visible = false;
Next_picturebox.Visible = true;
Previous_picturebox.Visible = false;
question_number_label.Visible = true;
timer_count_label.Visible = true;
timer1.Enabled = true;
question_label_title.Visible = true;
question_label.Visible = true;
question_richtextbox.Visible = true;
Answer_label.Visible = true;
answer_1.Visible = true;
answer_2.Visible = true;
answer_3.Visible = true;
answer_4.Visible = true;
}
public override void ExecuteQuery(CommerceQueryOperation queryOperation, OperationCacheDictionary operationCache, CommerceQueryOperationResponse response)
{
int numToTake = 2000;
lock (_addressLoaderLock) {
for (int i = 0; i < response.CommerceEntities.Count && response.CommerceEntities.Count < numToTake; i += numToTake) // only load addresses if we have less than 2000; any more than that will require a incoming filter
{
List <string> preferredAddressIds = new List <string>();
Dictionary <string, string> addressToParentIdMap = new Dictionary <string, string>();
List <CommerceEntity> currentBatch = response.CommerceEntities.Skip(i).Take(numToTake).ToList();
foreach (var entity in currentBatch)
{
string preferredAddressId = entity.GetPropertyValue("GeneralInfo.preferred_address") as string;
if (!String.IsNullOrEmpty(preferredAddressId) && !addressToParentIdMap.ContainsKey(preferredAddressId))
{
preferredAddressIds.Add("'" + preferredAddressId + "'");
addressToParentIdMap.Add(preferredAddressId, entity.Id);
}
}
// query them out
if (preferredAddressIds.Count == 0)
{
continue;
}
CommerceResourceCollection csResources = SiteHelper.GetCsConfig();
String connStr = csResources["Biz Data Service"]["s_BizDataStoreConnectionString"].ToString();
//ProfileContext pContext = CommerceSiteContexts.Profile[GetSiteName()];
string fields = string.Join(", ", Array.ConvertAll(this.ProfileEntityMappings.PropertyMappings.ToArray(), p => p.Value));
string keys = string.Join(", ", Array.ConvertAll(this.ProfileEntityMappings.PropertyMappings.ToArray(), p => p.Key));
ProfileContext ctxt = CommerceSiteContexts.Profile[SiteHelper.GetSiteName()];
string dataSQLText = "SELECT * FROM [BEK_Commerce_profiles].[dbo].[Addresses] WHERE u_address_id in (" + String.Join(",", preferredAddressIds.ToArray()) + ")";
try {
using (OleDbConnection conn = new OleDbConnection(connStr)) {
conn.Open();
using (OleDbCommand cmdRead = new OleDbCommand(dataSQLText, conn)) {
using (OleDbDataReader dataReader = cmdRead.ExecuteReader()) {
while (dataReader.Read())
{
CommerceEntity entity = new CommerceEntity("Address");
entity.Id = dataReader.GetString("u_address_id");
entity.SetPropertyValue("LastName", dataReader.GetString("u_last_name"));
entity.SetPropertyValue("FirstName", dataReader.GetString("u_first_name"));
entity.SetPropertyValue("AddressName", dataReader.GetString("u_address_name"));
entity.SetPropertyValue("AddressType", dataReader.GetNullableInt("i_address_type"));
entity.SetPropertyValue("Description", dataReader.GetString("u_description"));
entity.SetPropertyValue("Line1", dataReader.GetString("u_address_line1"));
entity.SetPropertyValue("Line2", dataReader.GetString("u_address_line2"));
entity.SetPropertyValue("City", dataReader.GetString("u_city"));
entity.SetPropertyValue("StateProvinceCode", dataReader.GetString("u_region_code"));
entity.SetPropertyValue("StateProvinceName", dataReader.GetString("u_region_name"));
entity.SetPropertyValue("ZipPostalCode", dataReader.GetString("u_postal_code"));
entity.SetPropertyValue("CountryRegionCode", dataReader.GetString("u_country_code"));
entity.SetPropertyValue("CountryRegionName", dataReader.GetString("u_country_name"));
entity.SetPropertyValue("Telephone", dataReader.GetString("u_tel_number"));
entity.SetPropertyValue("TelephoneExtension", dataReader.GetString("u_tel_extension"));
entity.SetPropertyValue("LocaleId", dataReader.GetString("i_locale"));
entity.SetPropertyValue("DateModified", dataReader.GetNullableDateTime("dt_date_last_changed"));
entity.SetPropertyValue("DateCreated", dataReader.GetNullableDateTime("dt_date_created"));
currentBatch.Where(x => x.Id == (addressToParentIdMap[entity.Id])).FirstOrDefault()
.Properties.Add("PreferredAddress", new CommerceRelationship(entity));
}
dataReader.Close();
}
}
}
} catch (Exception ex) {
throw new ApplicationException("Error loading organization addresses", ex);
}
}
}
}
}//public void ButtonReset_Click()
/// <summary>ButtonOpen_Click().</summary>
public void ButtonOpen_Click
(
Object sender,
EventArgs e
)
{
StringBuilder sb = null;
OleDbCommand oleDbCommand = null;
OleDbConnection oleDbConnection = null;
OleDbDataReader oleDbDataReader = null;
string medicalRecordPatientNo = null;
string accountNo = null;
bool databaseSelect = false;
try
{
medicalRecordPatientNo = MedicalRecordPatientNo.Trim();
accountNo = AccountNo.Trim();
if
(
medicalRecordPatientNo == string.Empty || medicalRecordPatientNo == null ||
accountNo == string.Empty || accountNo == null
)
{
Feedback = "Required columns Medical record patient No and Account No";
return;
}
sb = new StringBuilder();
sb.AppendFormat
(
CoreDataRecordSelect,
medicalRecordPatientNo,
accountNo
);
oleDbConnection = new OleDbConnection
(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
serverMapPath + @"\" + AccessDatabaseFileName +
";Persist Security Info=False"
);
oleDbConnection.Open();
oleDbCommand = new OleDbCommand( sb.ToString(), oleDbConnection);
oleDbDataReader = oleDbCommand.ExecuteReader();
databaseSelect = false;
while(oleDbDataReader.Read())
{
MedicalRecordPatientNo = oleDbDataReader.GetString(0);
AccountNo = oleDbDataReader.GetString(1);
AltMRN = oleDbDataReader.GetString(2);
NameLast = oleDbDataReader.GetString(3);
NameFirst = oleDbDataReader.GetString(4);
/*
UtilityDebug.Write(string.Format("medicalRecordPatientNo: {0}", medicalRecordPatientNo));
UtilityDebug.Write(string.Format("account: {0}", accountNo));
*/
databaseSelect = true;
}
//close the reader
oleDbDataReader.Close();
if ( databaseSelect == false )
{
Feedback = "Record Not Found";
UtilityDebug.Write("Record Not Found");
}
}
catch ( Exception exception )
{
UtilityDebug.Write(string.Format("Exception: {0}", exception.Message));
}//catch
finally
{
if (oleDbConnection.State == System.Data.ConnectionState.Open)
{
oleDbConnection.Close();
}//if (oleDbConnection.State == System.Data.ConnectionState.Open)
}//finally
}//public void ButtonOpen_Click()
private static void GetSearchResults(OleDbCommand command
, StringBuilder commandText
, SearchHeader header
, Boolean isPending)
{
command.CommandText = commandText.ToString();
using (OleDbDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
Dictionary <Int32, List <SearchResult> > results = new Dictionary <Int32, List <SearchResult> >();
while (reader.Read())
{
Int32 castId = reader.GetInt32(6);
List <SearchResult> resultList;
if (results.TryGetValue(castId, out resultList) == false)
{
resultList = new List <SearchResult>();
results.Add(castId, resultList);
}
SearchResult result = new SearchResult();
if (isPending)
{
result.CastId = CastListControl.NewId + castId.ToString();
}
else
{
result.CastId = castId.ToString();
}
if (reader.IsDBNull(0) == false)
{
String temp = reader.GetString(0);
MainForm.ClearNull(ref temp);
result.FirstName = temp;
}
if (reader.IsDBNull(1) == false)
{
String temp = reader.GetString(1);
MainForm.ClearNull(ref temp);
result.MiddleName = temp;
}
if (reader.IsDBNull(2) == false)
{
String temp = reader.GetString(2);
MainForm.ClearNull(ref temp);
result.LastName = temp;
}
if (reader.IsDBNull(3) == false)
{
String temp = reader.GetString(3);
MainForm.ClearNull(ref temp);
result.Title = temp;
}
if (String.IsNullOrEmpty(result.Title))
{
if (reader.IsDBNull(4) == false)
{
String temp = reader.GetString(4);
MainForm.ClearNull(ref temp);
result.Title = temp;
}
}
if (reader.IsDBNull(5) == false)
{
result.ProductionYear = reader.GetInt32(5).ToString();
}
if (isPending == false)
{
if (reader.IsDBNull(7) == false)
{
String temp = reader.GetString(7);
MainForm.ClearNull(ref temp);
result.CreditedAs = temp;
}
}
resultList.Add(result);
}
header.ResultList = new List <SearchResult>(results.Count);
foreach (KeyValuePair <Int32, List <SearchResult> > kvp in results)
{
SearchResult subHeader = new SearchResult();
subHeader.FirstName = kvp.Value[0].FirstName;
subHeader.MiddleName = kvp.Value[0].MiddleName;
subHeader.LastName = kvp.Value[0].LastName;
subHeader.CastId = kvp.Value[0].CastId;
subHeader.Title = "(CastId: " + kvp.Key.ToString() + ")";
subHeader.ResultList = new List <SearchResult>(kvp.Value);
header.ResultList.Add(subHeader);
}
}
}
}
public static int Membership_UpdateUserInfo(DbConnection connection, string applicationName, string username, bool isPasswordCorrect, bool updateLastLoginActivityDate, int maxInvalidPasswordAttempts, int passwordAttemptWindow, DateTime currentTimeUtc, DateTime lastLoginDate, DateTime lastActivityDate)
{
string querySelect = "SELECT usr.UserId, mbr.IsApproved, mbr.IsLockedOut, mbr.LastLockoutDate, " +
"mbr.FailedPasswordAttemptCount, mbr.FailedPwdAttemptWindowStart " +
"FROM aspnet_Applications app, aspnet_Users usr, aspnet_Membership mbr " +
"WHERE app.LoweredApplicationName = ? AND usr.ApplicationId = app.ApplicationId " +
"AND usr.UserId = mbr.UserId AND usr.LoweredUserName = ?";
OleDbCommand cmdSelect = new OleDbCommand(querySelect, (OleDbConnection)connection);
AddParameter(cmdSelect, "LoweredApplicationName", applicationName.ToLowerInvariant());
AddParameter(cmdSelect, "LoweredUserName", username.ToLowerInvariant());
string dbUserId = string.Empty;
bool dbIsApproved = false;
bool dbLockedOut = false;
DateTime dbLastLockoutDate;
int dbFailedPasswordAttemptCount = 0;
DateTime dbFailedPasswordAttemptWindowStart;
using (OleDbDataReader reader = cmdSelect.ExecuteReader()) {
if (reader.Read())
{
dbUserId = reader.GetString(0);
dbIsApproved = reader.GetInt32(1) > 0;
dbLockedOut = reader.GetInt32(2) > 0;
dbLastLockoutDate = reader.GetDateTime(3);
dbFailedPasswordAttemptCount = reader.GetInt32(4);
dbFailedPasswordAttemptWindowStart = reader.GetDateTime(5);
}
else
{
return(1); // user not found
}
}
if (dbLockedOut)
{
return(2); // locked out
}
if (!isPasswordCorrect)
{
if (currentTimeUtc > dbFailedPasswordAttemptWindowStart.AddMinutes(passwordAttemptWindow))
{
dbFailedPasswordAttemptWindowStart = currentTimeUtc;
dbFailedPasswordAttemptCount = 1;
}
else
{
dbFailedPasswordAttemptWindowStart = currentTimeUtc;
dbFailedPasswordAttemptCount++;
}
if (dbFailedPasswordAttemptCount > maxInvalidPasswordAttempts)
{
dbLockedOut = true;
dbLastLockoutDate = currentTimeUtc;
}
}
else
{
dbFailedPasswordAttemptCount = 0;
dbFailedPasswordAttemptWindowStart = DefaultDateTime;
}
if (updateLastLoginActivityDate)
{
string queryUpdUserActivity = "UPDATE aspnet_Users SET LastActivityDate = ? WHERE UserId = ?";
OleDbCommand cmdUpdUserActivity = new OleDbCommand(queryUpdUserActivity, (OleDbConnection)connection);
AddParameter(cmdUpdUserActivity, "LastActivityDate", currentTimeUtc);
AddParameter(cmdUpdUserActivity, "UserId", dbUserId);
cmdUpdUserActivity.ExecuteNonQuery();
string queryUpdMemberActivity = "UPDATE aspnet_Membership SET LastLoginDate = ? WHERE UserId = ?";
OleDbCommand cmdUpdMemberActivity = new OleDbCommand(queryUpdMemberActivity, (OleDbConnection)connection);
AddParameter(cmdUpdMemberActivity, "LastLoginDate", currentTimeUtc);
AddParameter(cmdUpdMemberActivity, "UserId", dbUserId);
cmdUpdMemberActivity.ExecuteNonQuery();
}
string queryUpdate = "UPDATE aspnet_Membership SET IsLockedOut = ?, LastLockoutDate = ?, " +
"FailedPasswordAttemptCount = ?, FailedPwdAttemptWindowStart = ? " +
"WHERE UserId = ?";
OleDbCommand cmdUpdate = new OleDbCommand(queryUpdate, (OleDbConnection)connection);
AddParameter(cmdUpdate, "IsLockedOut", dbLockedOut);
AddParameter(cmdUpdate, "LastLockoutDate", dbLastLockoutDate);
AddParameter(cmdUpdate, "FailedPasswordAttemptCount", dbFailedPasswordAttemptCount);
AddParameter(cmdUpdate, "FailedPwdAttemptWindowStart", dbFailedPasswordAttemptWindowStart);
AddParameter(cmdUpdate, "UserId", dbUserId);
cmdUpdate.ExecuteNonQuery();
return(0);
}
public ActionResult Edituser(string userid)
{
string usuario = Server.HtmlEncode(userid);
List <SelectListItem> li = new List <SelectListItem>();
List <SelectListItem> empresas = new List <SelectListItem>();
OleDbConnection cn = new OleDbConnection(cadena);
cn.Open();
string query = "exec sp_getinfo_usuario '" + usuario + "'";
var model = new PagosApp.Models.User();
OleDbCommand cmd = new OleDbCommand(query, cn);
OleDbDataReader reader = cmd.ExecuteReader();
string querylist = "exec getroles_combobox '" + usuario + "'";
OleDbCommand cmd2 = new OleDbCommand(querylist, cn);
OleDbDataReader reader2 = cmd2.ExecuteReader();
string querylistempresas = "exec getempresas_combobox '" + usuario + "'";
OleDbCommand cmd3 = new OleDbCommand(querylistempresas, cn);
OleDbDataReader reader3 = cmd3.ExecuteReader();
if (reader2.HasRows)
{
while (reader2.Read())
{
li.Add(new SelectListItem {
Text = reader2.GetString(1), Value = reader2.GetValue(0).ToString()
});
}
ViewData["Rol"] = li;
}
if (reader3.HasRows)
{
while (reader3.Read())
{
empresas.Add(new SelectListItem {
Text = reader3.GetString(1), Value = reader3.GetValue(0).ToString()
});
}
}
ViewData["Empresa"] = empresas;
String nombre;
String rol;
String Status;
bool deleted;
if (reader.HasRows)
{
while (reader.Read())
{
nombre = reader.GetString(0);
ViewData["UserName"] = nombre;
Status = reader.GetString(1);
rol = reader.GetString(2);
model.Usuario = usuario;
model.Nombre = nombre;
model.rol = rol;
model.id_rol = reader.GetInt32(3);
deleted = reader.GetBoolean(4);
model.Estado = deleted;
}
}
reader.Close();
cmd.Dispose();
cn.Close();
cmd.Dispose();
cmd2.Dispose();
return(View(model));
}
private void button3_Click(object sender, EventArgs e)
{
//--------------------DEĞİŞKEN ALANI----------------------------
// label5.Visible = true;
if (kontroldeger == 1)
{
int sayac2 = 1; int baglantisayaci = 0; int asci = 0; int sayac = 0;
string pr_sql = ""; string sonuc = "";
string sifrelenentext = ""; string[] sifreDizi = new string[4];
Random rastgele = new Random();
baglanti.Open();
while (sayac < textBox1.TextLength)
{
asci = Convert.ToInt32(Convert.ToChar(textBox1.Text.Substring(sayac, 1)));
pr_sql = "SELECT SIFRE_METNI FROM sifrelemeTablosu WHERE ASCI = " + asci;
OleDbCommand komut = new OleDbCommand(pr_sql, baglanti);
OleDbDataReader dr = komut.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
sifreliMetin = dr.GetString(0);
}
}
for (int i = 0; i < 4; i++)
{
sifreDizi[i] = sifreliMetin.Substring(sayac2, 4);
sayac2 = sayac2 + 6;
}
sayac2 = 1;
sonuc = Convert.ToChar(rastgele.Next(33, 127)) + sifreDizi[rastgele.Next(4)] + Convert.ToChar(rastgele.Next(33, 127));
sifrelenentext += sonuc;
if (baglantisayaci > 500)
{
dr.Close();
}
baglantisayaci++;
sayac++;
}
//string gun = tarih.Substring(15, tarih.Length - 15);
// string ay = tarih.Substring(
OleDbCommand eklemekomut = new OleDbCommand("insert into Gunlukler (K_ID,Metin,Gun,Yil,Ay) values (@kid,@metin,@gun,@yil,@ay)", baglanti);
eklemekomut.Parameters.AddWithValue("@kid", id1);
eklemekomut.Parameters.AddWithValue("@metin", sifrelenentext);
eklemekomut.Parameters.AddWithValue("@gun", gun);
eklemekomut.Parameters.AddWithValue("@yil", DateTime.Now.Year);
eklemekomut.Parameters.AddWithValue("@ay", ay);
eklemekomut.ExecuteNonQuery();
baglanti.Close();
textBox2.Text = sifrelenentext;
MessageBox.Show("Günlük Kayıt İşlemi Başarılı");
}
label5.Visible = false;
}
public void Liste_des_propositions_Load(object sender, EventArgs e)
{
listView1.Items.Clear();
listView2.Items.Clear();
//string nomBase = "IMMOBILLY_JACKYTEAM";
string ChaineBd = "Provider=SQLOLEDB;Data Source=INFO-joyeux;Initial Catalog=IMMOBILLY_JACKYTEAM;Persist Security Info=True; Integrated Security=sspi;";
OleDbConnection dbConnection = new OleDbConnection(ChaineBd);
dbConnection.Open();
string sql2 = "SELECT nom_Acheteur, prénom_Acheteur FROM Acheteur where Num_Acheteur = '" + ApplicationState.id_acheteur + "' ";
OleDbCommand cmd = new OleDbCommand(sql2, dbConnection);
OleDbDataReader reader2 = cmd.ExecuteReader();
while (reader2.Read())
{
textBox1.Text = ApplicationState.id_acheteur;
textBox2.Text = reader2.GetString(0);
textBox4.Text = reader2.GetString(1);
}
reader2.Close();
string sql1 = "select p.CODE_PROPOSITION, a.NOM_ACHETEUR, a.PRÉNOM_ACHETEUR, c.NOM, c.PRENOM, b.CODE_BIEN, p.DATE from PROPOSITION p join bien b on b.CODE_BIEN = p.CODE_BIEN join souhait s on s.CODE_SOUHAIT = p.CODE_SOUHAIT join acheteur a on s.NUM_ACHETEUR = a.NUM_ACHETEUR join COMMERCIAL c on c.NUM_COMMERCIAL = a.NUM_COMMERCIAL where a.NUM_ACHETEUR = '" + textBox1.Text + "' ";
OleDbCommand cmd1 = new OleDbCommand(sql1, dbConnection);
OleDbDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
string[] row = { reader1.GetValue(0).ToString(), reader1.GetString(1), reader1.GetString(2), reader1.GetString(3), reader1.GetString(4), reader1.GetValue(5).ToString(), reader1.GetValue(6).ToString() };
ListViewItem proposition = new ListViewItem(row);
listView1.Items.Add(proposition);
}
reader1.Close();
string sql3 = "SELECT v.CODE_VISITE, v.date,c.nom, c.PRENOM, p.CODE_PROPOSITION from VISITE v join PROPOSITION p on p.CODE_PROPOSITION = v.CODE_PROPOSITION join souhait s on s.CODE_SOUHAIT = p.CODE_SOUHAIT join ACHETEUR a on a.NUM_ACHETEUR = s.NUM_ACHETEUR join COMMERCIAL c on c.NUM_COMMERCIAL = a.NUM_COMMERCIAL where a.NUM_ACHETEUR = '" + textBox1.Text + "'";
OleDbCommand cmd3 = new OleDbCommand(sql3, dbConnection);
OleDbDataReader reader3 = cmd3.ExecuteReader();
while (reader3.Read())
{
string[] row = { reader3.GetInt32(0).ToString(), reader3.GetValue(1).ToString(), reader3.GetString(2), reader3.GetString(3), reader3.GetValue(4).ToString() };
ListViewItem visites = new ListViewItem(row);
listView2.Items.Add(visites);
}
reader3.Close();
}
public ActionResult Updateuser(Models.User user)
{
//OleDbConnection cn = new OleDbConnection(cadena);
//cn.Open();
OleDbConnection cn = new OleDbConnection(cadena);
cn.Open();
string name = user.Nombre;
string password = user.Password;
string rol = user.rol;
bool deleted = user.Estado;
string activo = "";
if (deleted)
{
activo = "1";
}
else
{
activo = "0";
}
int id_rol = Convert.ToInt32(user.rol);
ViewData["UserName"] = name;
string query = "exec sp_editusuario '" + user.Usuario + "','" + name + "','" + password + "'," + activo + "," + id_rol + "," + user.id_empresa;
List <SelectListItem> li = new List <SelectListItem>();
List <SelectListItem> empresas = new List <SelectListItem>();
ViewData["error"] = "Customer Data Update successfully";
string querylist = "select * from roles";
OleDbCommand cmd2 = new OleDbCommand(querylist, cn);
OleDbDataReader reader2 = cmd2.ExecuteReader();
string querylistempresas = "exec getempresas_combobox '" + user.Usuario + "'";
OleDbCommand cmd3 = new OleDbCommand(querylistempresas, cn);
OleDbDataReader reader3 = cmd3.ExecuteReader();
int result = 0;
OleDbCommand cmd = new OleDbCommand(query, cn);
OleDbDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
result = reader.GetInt32(0);
}
}
if (reader3.HasRows)
{
while (reader3.Read())
{
empresas.Add(new SelectListItem {
Text = reader3.GetString(1), Value = reader3.GetValue(0).ToString()
});
}
}
ViewData["Empresa"] = empresas;
if (result == 1)
{
ViewData["error"] = "Usuario actualizado Satisfactoriamente";
}
else
{
ViewData["error"] = "Error al actualizar Usuario";
}
while (reader2.Read())
{
li.Add(new SelectListItem {
Text = reader2.GetString(1), Value = reader2.GetValue(0).ToString()
});
}
ViewData["Rol"] = li;
reader2.Close();
return(View(user));
}
private void ClassMessage_Load(object sender, EventArgs e)
{
tryOpenConnection();
string sql;
if (!isTeacher(mid))
{
OleDbCommand command = new OleDbCommand();
command.Connection = connection;
command.CommandText = "SELECT class FROM stuLogin WHERE id='" + mid + "'";
OleDbDataReader reader = command.ExecuteReader();
reader.Read();
sql = "SELECT stuLogin.id as 工号, fullName as 姓名, class as 部门, sex as 性别, yearOld as 年龄, partyOrNot as 党员否, address as 住址, phone as 电话 FROM student INNER JOIN stuLogin ON student.id = stuLogin.id WHERE stuLogin.class='" + reader.GetString(0).ToString() + "'";
reader.Close();
}
else
{
sql = "SELECT stuLogin.id as 工号, stuLogin.fullName as 姓名, stuLogin.class as 部门, sex as 性别, yearOld as 年龄, partyOrNot as 党员否, address as 住址, phone as 电话 FROM teaLogin INNER JOIN (student INNER JOIN stuLogin ON student.id = stuLogin.id) ON teaLogin.class = stuLogin.class WHERE teaLogin.id='" + mid + "'";
}
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, connection);
dataSet = new DataSet();
adapter.Fill(dataSet);
dataGridView1.DataSource = dataSet.Tables[0];
connection.Close();
}
private void btnSrchWorksheet_Click_1(object sender, EventArgs e)
{
try
{
string dateTxt = txtDate.Text;
OleDbConnection conn = DbConnection.Instance;
ConnectionState oriConnState = conn.State;
if ((conn.State & ConnectionState.Open) != ConnectionState.Open)
{
conn.Open();
}
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
if (dateTxt != string.Empty)
{
//cmd.CommandText = "SELECT 單號 FROM 工作單 WHERE 單號 LIKE '" + dateTxt + "%'";
cmd.CommandText = "SELECT 單號 FROM 工作單";
//產生日期條件
List <string> dateFilter = new List <string>();
string[] dateFunc = new string[] { "YEAR", "MONTH", "DAY" };
string[] dateTxtArr = dateTxt.Split('-');
for (int i = 0; i < 3; i++)
{
if (!string.IsNullOrEmpty(dateTxtArr[i].Trim()))
{
int val = int.Parse(dateTxtArr[i]);
dateFilter.Add(dateFunc[i] + "(單據日期)=" + val);
}
}
if (dateFilter.Count > 0)
{
cmd.CommandText += " WHERE " + string.Join(" AND ", dateFilter.ToArray());
}
}
else
{
cmd.CommandText = "SELECT 單號 FROM 工作單";
}
OleDbDataReader reader = cmd.ExecuteReader();
List <string> worksheetNumbers = new List <string>();
while (reader.Read())
{
worksheetNumbers.Add(reader.GetString(0));
}
reader.Close();
if (oriConnState == ConnectionState.Closed)
{
conn.Close();
}
cbbWorksheetNubmerS.SelectedIndex = -1;
cbbWorksheetNubmerS.DataSource = worksheetNumbers;
}
catch (Exception ex)
{
Global.ShowError(ex);
}
}
void copyOrderTable()
{
string sql = "SELECT NППЗаказа, NЗаказаЗавода, NЗаказа, ГрафикN, ВидГрафика, ОснованиеЗаказа, ДатаПолученияЗаказа, ОбозначениеТО, КодТО, NИзделия, NДетали, Кол_во, ФКол_во, Заказчик, ПланДатаИзготовления, КодПриоритета, ПланТП, ДатаТП, ДатаПоступленияЦех, ФактДатаИзготовления, ПланТрудоемкость, ЦехИсполнитель, Отчет, ДатаОтчета, Технолог, Слесарь, СодержаниеЗаявки, ФактТрудоемкость, NНакладной, NАкта, СкладПолуч, НеодноврВыпЗак, Конструктор, p_unit, pause, OrderCards, Life, Lifeday, ObjectType, Quckly, MaterialDate, Запчасть, Стойкость, Доп_заказ, TNVED, PriceDate, PeoDate, OtizDate FROM Заказы";// where NППЗаказа=1";
OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.connStr);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader r = cmd.ExecuteReader();
while (r.Read())
{
Order o = new Order();
o.orderId = r.GetInt32(0);
o.orderNumber = r.GetString(1);
o.orderFullNumber = r.GetString(2);
if (r[3] != DBNull.Value)
{
o.graphId = r.GetInt32(3);
}
if (r[4] != DBNull.Value)
{
o.graphTypeId = r.GetByte(4);
}
if (r[5] != DBNull.Value)
{
o.reasonOrder = r.GetByte(5);
}
if (r[6] != DBNull.Value)
{
o.orderDate = r.GetDateTime(6);
}
if (r[7] != DBNull.Value)
{
o.obozTo = r.GetString(7);
}
if (r[8] != DBNull.Value)
{
o.kodTO = r.GetInt16(8);
}
o.productNumber = r.GetString(9);
o.partNumber = r.GetString(10);
if (r[11] != DBNull.Value)
{
o.qty = r.GetInt32(11);
}
if (r[12] != DBNull.Value)
{
o.realQty = r.GetInt32(12);
}
if (r[13] != DBNull.Value)
{
o.customerId = r.GetInt32(13);
}
if (r[14] != DBNull.Value)
{
o.planDate = r.GetDateTime(14);
}
if (r[15] != DBNull.Value)
{
o.priorityId = r.GetByte(15);
}
if (r[16] != DBNull.Value)
{
o.planTechDate = r.GetDateTime(16);
}
if (r[17] != DBNull.Value)
{
o.techDate = r.GetDateTime(17);
}
if (r[18] != DBNull.Value)
{
o.shopDate = r.GetDateTime(18);
}
if (r[19] != DBNull.Value)
{
o.factReadyDate = r.GetDateTime(19);
}
if (r[20] != DBNull.Value)
{
o.planLabourIntensity = r.GetDouble(20);
}
if (r[21] != DBNull.Value)
{
o.performerShop = r.GetInt32(21);
}
if (r[22] != DBNull.Value)
{
o.includeInReport = r.GetBoolean(22);
}
if (r[23] != DBNull.Value)
{
o.reportDate = r.GetDateTime(23);
}
if (r[24] != DBNull.Value)
{
o.technologistId = r.GetInt32(24);
}
if (r[25] != DBNull.Value)
{
o.locksmithId = r.GetInt32(25);
}
if (r[26] != DBNull.Value)
{
o.orderNote = r.GetString(26);
}
if (r[27] != DBNull.Value)
{
o.factLabourIntensity = r.GetDouble(27);
}
if (r[28] != DBNull.Value)
{
o.consignmentNote = r.GetString(28);
}
if (r[29] != DBNull.Value)
{
o.actNumber = r.GetString(29);
}
if (r[30] != DBNull.Value)
{
o.destinationStore = r.GetString(30);
}
if (r[31] != DBNull.Value)
{
o.anotherTimeReady = r.GetBoolean(31);
}
if (r[32] != DBNull.Value)
{
o.designerId = -1; //// !!!!!!!!!!!! r.GetInt32(32);
}
if (r[33] != DBNull.Value)
{
o.unitOfMeasureId = -1;/// r.GetInt32(33);
}
if (r[34] != DBNull.Value)
{
o.stopped = r.GetBoolean(34);
}
if (r[35] != DBNull.Value)
{
o.orderCard = r.GetInt32(35);
}
if (r[36] != DBNull.Value)
{
o.serviceLifeYear = r.GetInt16(36);
}
if (r[37] != DBNull.Value)
{
o.serviceLifeDay = r.GetInt32(37);
}
if (r[38] != DBNull.Value)
{
o.objectType = r.GetByte(38);
}
if (r[39] != DBNull.Value)
{
o.urgent = r.GetBoolean(39);
}
if (r[40] != DBNull.Value)
{
o.materialDate = r.GetDateTime(40);
}
if (r[41] != DBNull.Value)
{
o.spare = r.GetBoolean(41);
}
if (r[42] != DBNull.Value)
{
o.resistance = r.GetInt32(42);
}
if (r[43] != DBNull.Value)
{
o.additionalOrder = r.GetBoolean(43);
}
if (r[44] != DBNull.Value)
{
o.classifier = r.GetDecimal(44).ToString();
}
if (r[45] != DBNull.Value)
{
o.priceDate = r.GetDateTime(45);
}
if (r[46] != DBNull.Value)
{
o.peoDate = r.GetDateTime(46);
}
if (r[47] != DBNull.Value)
{
o.otizDate = r.GetDateTime(47);
}
/*
*
* string json = JsonConvert.SerializeObject(o, Formatting.None, new JsonSerializerSettings
* {
* NullValueHandling = NullValueHandling.Ignore
* });
*
*/
Order o2 = rest.saveEntity <Order>(o);
if (o2.orderId < 1)
{
break;
}
// MessageBox.Show(json);
}
r.Close();
cmd.Dispose();
conn.Close();
MessageBox.Show("Done!");
}
public void ProcessRequest(HttpContext context)
{
Response = context.Response;
string appId = context.Request.QueryString["app"];
int groupId;
if (!String.IsNullOrEmpty(appId) && Int32.TryParse(context.Request.QueryString["group"], out groupId))
{
Response.Clear();
List <String> placemarks = new List <String>();
Dictionary <String, String> styles = new Dictionary <String, String>();
string appName = null;
string groupName = null;
using (OleDbConnection connection = AppContext.GetDatabaseConnection())
{
string sql = String.Format("update {0}MarkupGroup set DateLastAccessed = ? where GroupID = ?", AppSettings.ConfigurationTablePrefix);
using (OleDbCommand command = new OleDbCommand(sql, connection))
{
command.Parameters.Add("@1", OleDbType.Date).Value = DateTime.Now;
command.Parameters.Add("@2", OleDbType.Integer).Value = groupId;
command.ExecuteNonQuery();
command.CommandText = String.Format("select Shape, Color, Text from {0}Markup where GroupID = ? and Deleted = 0", AppSettings.ConfigurationTablePrefix);
command.Parameters.Clear();
command.Parameters.Add("@1", OleDbType.Integer).Value = groupId;
WKTReader wktReader = new WKTReader();
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
IGeometry geometry = wktReader.Read(reader.GetString(0));
string coordinates = GetCoordinates(geometry);
string color = reader.GetString(1);
bool isText = !reader.IsDBNull(2);
string styleId = GetStyle(geometry.OgcGeometryType, color, isText, styles);
switch (geometry.OgcGeometryType)
{
case OgcGeometryType.Point:
string name = isText ? String.Format("<name>{0}</name>", reader.GetString(2)) : "";
placemarks.Add(String.Format("<Placemark>{0}<styleUrl>#{1}</styleUrl><Point>{2}</Point></Placemark>", name, styleId, coordinates));
break;
case OgcGeometryType.LineString:
placemarks.Add(String.Format("<Placemark><styleUrl>#{0}</styleUrl><LineString>{1}</LineString></Placemark>", styleId, coordinates));
break;
case OgcGeometryType.Polygon:
placemarks.Add(String.Format("<Placemark><styleUrl>#{0}</styleUrl><Polygon><outerBoundaryIs><LinearRing>{1}</LinearRing></outerBoundaryIs></Polygon></Placemark>", styleId, coordinates));
break;
}
}
}
Configuration config = AppContext.GetConfiguration();
Configuration.ApplicationRow application = config.Application.Select(String.Format("ApplicationID = '{0}'", appId))[0] as Configuration.ApplicationRow;
appName = application.DisplayName;
command.CommandText = String.Format("select DisplayName from {0}MarkupGroup where GroupID = ?", AppSettings.ConfigurationTablePrefix);
groupName = command.ExecuteScalar() as string;
}
}
string timeStamp = DateTime.Now.ToString("yyyyMMddHHmmssff");
string kmzName = String.Format("Markup_{0}.kmz", timeStamp);
string kmlName = String.Format("Markup_{0}.kml", timeStamp);
string kml = @"<?xml version=""1.0"" encoding=""UTF-8""?>
<kml xmlns=""http://earth.google.com/kml/2.2"">
<Folder>
<name>{0}</name>
<Document>
<name>Markup: {1}</name>
{2}
{3}
</Document>
</Folder>
</kml>";
string[] styleArray = new string[styles.Values.Count];
styles.Values.CopyTo(styleArray, 0);
kml = String.Format(kml, appName, groupName, String.Join("", styleArray), String.Join("", placemarks.ToArray()));
Response.ContentType = "application/vnd.google-earth.kmz";
Response.AddHeader("Content-Disposition", "attachment; filename=" + kmzName);
ZipOutputStream zipStream = new ZipOutputStream(Response.OutputStream);
MemoryStream memoryStream = new MemoryStream();
byte[] buffer = (new UTF8Encoding()).GetBytes(kml);
ZipEntry entry = new ZipEntry(kmlName);
entry.Size = buffer.Length;
zipStream.PutNextEntry(entry);
zipStream.Write(buffer, 0, buffer.Length);
zipStream.Finish();
Response.End();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedItem == null || comboBox2.SelectedItem == null || comboBox3.SelectedItem == null)
{
MessageBox.Show("Lütfen tarih bilgilerini eksiksiz girin!");
}
else
{
OleDbCommand metinkomut = new OleDbCommand("select Metin from Gunlukler where K_ID = @pkid and Yil=@yil and Ay = @ay and Gun=@gun", baglanti);
metinkomut.Parameters.AddWithValue("@pkid", id1);
metinkomut.Parameters.AddWithValue("@yil", comboBox1.SelectedItem);
metinkomut.Parameters.AddWithValue("@ay", comboBox2.SelectedItem);
metinkomut.Parameters.AddWithValue("@gun", comboBox3.SelectedItem);
baglanti.Open();
string icerik = (string)metinkomut.ExecuteScalar();
for (int i = 1; i < 87; i++)
{
OleDbCommand komut = new OleDbCommand("SELECT SIFRE_METNI FROM sifrelemeTablosu WHERE Id = " + i + "", baglanti);
OleDbCommand komut2 = new OleDbCommand("SELECT karakterler FROM isaretciler WHERE Kimlik = " + i + "", baglanti);
OleDbDataReader dr = komut.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
sifreliMetin = dr.GetString(0);
}
}
dr = komut2.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
karakter = dr.GetString(0);
}
}
if (i == 86)
{
dr.Close();
}
for (int j = 0; j < 4; j++)
{
sifre = sifreliMetin.Substring(sayacCoz, 4);
sayacCoz = sayacCoz + 6;
icerik = icerik.Replace(sifre, karakter);
}
sayacCoz = 1;
}
int deneme = 1;
while (deneme < icerik.Length)
{
ametin += icerik.Substring(deneme, 1);
deneme = deneme + 3;
}
textBox1.Text = ametin;
if (ametin.Length < 510)
{
btnsayfa1.Text = ametin;
}
else if (ametin.Length > 510 && ametin.Length < 1020)
{
btnsayfa1.Text = ametin.Substring(0, 510);
btnsayfa2.Text = ametin.Substring(510, ametin.Length - 510);
}
else if (ametin.Length > 1020 && ametin.Length < 1530)
{
btnsayfa1.Text = ametin.Substring(1019, ametin.Length - 1019);
btnGeri.Visible = true;
sayfagecis = 1;
}
else if (ametin.Length > 1530 && ametin.Length < 2040)
{
btnsayfa1.Text = ametin.Substring(1019, 510);
btnsayfa2.Text = ametin.Substring(1529, ametin.Length - 1529);
btnGeri.Visible = true;
sayfagecis = 1;
}
else if (ametin.Length > 2040 && ametin.Length < 2550)
{
btnsayfa1.Text = ametin.Substring(2039, ametin.Length - 2039);
btnGeri.Visible = true;
sayfagecis = 2;
}
else if (ametin.Length > 2550)
{
btnsayfa1.Text = ametin.Substring(2039, 510);
btnsayfa2.Text = ametin.Substring(2549, ametin.Length - 2549);
btnGeri.Visible = true;
sayfagecis = 2;
}
ametin = "";
baglanti.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
data = textBox1.Text;
bool ok = CheckRadio();
//Stringbuilder object creation
StringBuilder builder = new StringBuilder();
if (ok)
{
player.controls.stop();
pictureBox1.ImageLocation = "";
connection.Open();
//If the user chooses the first radiobutton
if (rchecked.Equals("radiobutton1"))
{
//Query select based on name
String query = "Select ContactName,ContactFullName,TelephoneNumber,EmailAddress,Country,City,Address,BirthDate,FavoriteSong,Picture from Contacts Where ContactName=?";
//Command creation in order to execute the query
OleDbCommand command = new OleDbCommand(query, connection);
command.Parameters.AddWithValue("ContactName", data);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//Initialize picturebox imagelocation,player.Url songs path and add data to stringBuilder
pictureBox1.ImageLocation = reader.GetString(9);
builder.AppendLine("Name " + reader.GetString(0) +
Environment.NewLine + "Last Name " + reader.GetString(1) + Environment.NewLine + "Telephone Number " + reader.GetString(2)
+ Environment.NewLine + "EmailAddress " + reader.GetString(3) + Environment.NewLine +
"Country " + reader.GetString(4) + Environment.NewLine + "City " + reader.GetString(5) +
Environment.NewLine + "Address " + reader.GetString(6) + Environment.NewLine + "Birth Date "
+ reader.GetString(7) + Environment.NewLine + "Favorite song " + reader.GetString(8)
+ Environment.NewLine + "Picture " + reader.GetString(9) + Environment.NewLine + "------------------");
String song = reader.GetString(8);
player.URL = song;
player.controls.play();
}
}
else if (rchecked.Equals("radiobutton2"))
{
//Query select based on Lastname
String query = "Select ContactName,ContactFullName,TelephoneNumber,EmailAddress,Country,City,Address,BirthDate,FavoriteSong,Picture from Contacts Where ContactFullName=?";
//Command creation in order to execute the query
OleDbCommand command = new OleDbCommand(query, connection);
command.Parameters.AddWithValue("ContactFullName", data);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//Initialize picturebox imagelocation,player.Url songs path and add data to stringBuilder
pictureBox1.ImageLocation = reader.GetString(9);
builder.AppendLine("Name " + reader.GetString(0) +
Environment.NewLine + "Last Name " + reader.GetString(1) + Environment.NewLine + "Telephone Number " + reader.GetString(2)
+ Environment.NewLine + "EmailAddress " + reader.GetString(3) + Environment.NewLine +
"Country " + reader.GetString(4) + Environment.NewLine + "City " + reader.GetString(5) +
Environment.NewLine + "Address " + reader.GetString(6) + Environment.NewLine + "Birth Date "
+ reader.GetString(7) + Environment.NewLine + "Favorite song " + reader.GetString(8)
+ Environment.NewLine + "Picture " + reader.GetString(9) + Environment.NewLine + "------------------");
String song = reader.GetString(8);
player.URL = song;
player.controls.play();
}
}
else if (rchecked.Equals("radiobutton3"))
{
//Query select based on telephoneNumber
String query = "Select ContactName,ContactFullName,TelephoneNumber,EmailAddress,Country,City,Address,BirthDate,FavoriteSong,Picture from Contacts Where TelephoneNumber=?";
//Initialize picturebox imagelocation,player.Url songs path and add data to stringBuilder
OleDbCommand command = new OleDbCommand(query, connection);
command.Parameters.AddWithValue("TelephoneNumber", data);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//Initialize picturebox imagelocation,player.Url songs path and add data to stringBuilder
pictureBox1.ImageLocation = reader.GetString(9);
builder.AppendLine("Name " + reader.GetString(0) +
Environment.NewLine + "Last Name " + reader.GetString(1) + Environment.NewLine + "Telephone Number " + reader.GetString(2)
+ Environment.NewLine + "EmailAddress " + reader.GetString(3) + Environment.NewLine +
"Country " + reader.GetString(4) + Environment.NewLine + "City " + reader.GetString(5) +
Environment.NewLine + "Address " + reader.GetString(6) + Environment.NewLine + "Birth Date "
+ reader.GetString(7) + Environment.NewLine + "Favorite song " + reader.GetString(8)
+ Environment.NewLine + "Picture " + reader.GetString(9) + Environment.NewLine + "------------------");
String song = reader.GetString(8);
player.URL = song;
player.controls.play();
}
}
//close connection
connection.Close();
richTextBox1.Clear();
//Add stringbuilder contents to richtextbox and show
richTextBox1.AppendText(builder.ToString());
//If stringbuilder is empty then the procdures above failed
if (builder.ToString().Equals(""))
{
MessageBox.Show("The contact based on fields you gave does not exist!!!");
}
}
}
} // end Delete
// ********** Select Method **********
// Select records from Person, Client, Employee, Manager, and Worker tables that match integer parameter personID
// Uses strConnection to open a connection with the database
// Selects Person with given ID from every table in the database
// If a person with the given ID is not in a table, the Select command does nothing
// Code written by Christopher Tither and Frank Branigan, CIS 3309 Section 1, April 2017
public void Select(int personID, ref int id, ref string name,
ref DateTime birthDate, ref string type, ref string title, ref decimal salary, ref decimal bonus, ref decimal hourlyPay,
ref bool isPerson, ref bool isClient, ref bool isEmployee, ref bool isManager, ref bool isWorker)
{
using (OleDbConnection connection = new OleDbConnection(strConnection))
{
try
{
connection.Open();
using (OleDbCommand command1 = new OleDbCommand("SELECT fldID, fldName, fldBirthDate FROM Person WHERE fldID = " + personID, connection))
{
OleDbDataReader reader = command1.ExecuteReader();
if (reader.Read())
{
isPerson = true;
id = Convert.ToInt32(reader.GetValue(0).ToString());
name = Convert.ToString(reader.GetValue(1));
birthDate = Convert.ToDateTime(reader.GetValue(2));
}
}
using (OleDbCommand command2 = new OleDbCommand("SELECT fldType FROM Client WHERE fldID = " + personID, connection))
{
OleDbDataReader reader = command2.ExecuteReader();
if (reader.Read())
{
isClient = true;
type = reader.GetString(0);
}
}
using (OleDbCommand command3 = new OleDbCommand("SELECT fldTitle FROM Employee WHERE fldID = " + personID, connection))
{
OleDbDataReader reader = command3.ExecuteReader();
if (reader.Read())
{
isEmployee = true;
title = reader.GetString(0);
}
}
using (OleDbCommand command4 = new OleDbCommand("SELECT fldSalary, fldBonus FROM Manager WHERE fldID = " + personID, connection))
{
OleDbDataReader reader = command4.ExecuteReader();
if (reader.Read())
{
isManager = true;
salary = Convert.ToDecimal(reader.GetValue(0).ToString());
bonus = Convert.ToDecimal(reader.GetValue(1).ToString());
}
}
using (OleDbCommand command5 = new OleDbCommand("SELECT fldHourlyPay FROM Worker WHERE fldID = " + personID, connection))
{
OleDbDataReader reader = command5.ExecuteReader();
if (reader.Read())
{
isWorker = true;
hourlyPay = Convert.ToDecimal(reader.GetValue(0).ToString());
}
}
connection.Close();
}
catch (OleDbException ex)
{
Console.Write("Error: " + ex.Message);
connection.Close();
}
} // end using block
} // end Select
public static int Membership_ResetPassword(DbConnection connection, string applicationName, string username, string newPassword, string passwordAnswer, int passwordFormat, string passwordSalt, int maxInvalidPasswordAttempts, int passwordAttemptWindow, DateTime currentTimeUtc)
{
string querySelect = "SELECT usr.UserId, mbr.Password, mbr.PasswordAnswer, mbr.IsLockedOut, " +
"mbr.LastLockoutDate, mbr.FailedPwdAnswerAttemptCount, mbr.FailedPwdAnswerAttWindowStart " +
"FROM aspnet_Applications app, aspnet_Users usr, aspnet_Membership mbr " +
"WHERE app.LoweredApplicationName = ? AND usr.ApplicationId = app.ApplicationId " +
"AND usr.UserId = mbr.UserId AND usr.LoweredUserName = ?";
OleDbCommand cmdSelect = new OleDbCommand(querySelect, (OleDbConnection)connection);
AddParameter(cmdSelect, "LoweredApplicationName", applicationName.ToLowerInvariant());
AddParameter(cmdSelect, "LoweredUserName", username.ToLowerInvariant());
string dbUserId = null;
string dbPassword = null;
string dbPasswordAns = null;
bool dbLockedOut = false;
DateTime dbLastLockoutDate;
int dbFailedPasswordAnswerAttemptCount = 0;
DateTime dbFailedPasswordAnswerAttemptWindowStart;
using (OleDbDataReader reader = cmdSelect.ExecuteReader()) {
if (reader.Read())
{
dbUserId = reader.GetString(0);
dbPassword = reader.GetString(1);
dbPasswordAns = reader.GetString(2);
dbLockedOut = reader.GetInt32(3) > 0;
dbLastLockoutDate = reader.GetDateTime(4);
dbFailedPasswordAnswerAttemptCount = reader.GetInt32(5);
dbFailedPasswordAnswerAttemptWindowStart = reader.GetDateTime(6);
}
else
{
return(1); // user not found
}
}
if (dbLockedOut)
{
return(2); // locked out
}
if (dbPasswordAns != passwordAnswer)
{
if (currentTimeUtc > dbFailedPasswordAnswerAttemptWindowStart.AddMinutes(passwordAttemptWindow))
{
dbFailedPasswordAnswerAttemptWindowStart = currentTimeUtc;
dbFailedPasswordAnswerAttemptCount = 1;
}
else
{
dbFailedPasswordAnswerAttemptWindowStart = currentTimeUtc;
dbFailedPasswordAnswerAttemptCount++;
}
if (dbFailedPasswordAnswerAttemptCount > maxInvalidPasswordAttempts)
{
dbLockedOut = true;
dbLastLockoutDate = currentTimeUtc;
}
return(3); // passwrod answer is wrong
}
else
{
dbFailedPasswordAnswerAttemptCount = 0;
dbFailedPasswordAnswerAttemptWindowStart = DefaultDateTime;
}
return(Membership_SetPasswordUserId(connection, dbUserId, newPassword, passwordSalt, passwordFormat, currentTimeUtc));
}
public string SearchPlaysUpdate(string input, DateTime dateInput)
{
DateTime inputDateTime = dateInput;
string Inputstring = input;
string returnAllPlays = "";
string initialreturn = "";
string addString = "";
string previousTitle = "";
string connString;
connString = @"Provider=Microsoft.JET.OLEDB.4.0;Data Source = L:\Comp-1632-System Development Project\TicketBookingSystem\TicketBookingSystem\TicketSysDB.mdb";
OleDbConnection myConnection = new OleDbConnection(connString);
myConnection.Open();
if (input != "" || input != null)
{
OleDbCommand myCommand = new OleDbCommand("SELECT Title, DateofPlay, TimeofPlay FROM Plays WHERE DateofPlay = @InputDate AND Title = @InputTitle ", myConnection);
myCommand.Parameters.AddWithValue("@InputDate", inputDateTime);
myCommand.Parameters.AddWithValue("@InputTitle", input);
OleDbDataReader reader = myCommand.ExecuteReader();
while (reader.Read())
{
initialreturn = reader.GetString(0);
addString += "Title: " + initialreturn + " ";
initialreturn = reader.GetDateTime(1).ToShortDateString();
addString += "Date: " + initialreturn + " ";
initialreturn = reader.GetString(2);
addString += "Time: " + initialreturn + "\n";
addString += "\n";
addString += "\n";
title = reader.GetString(0);
time = reader.GetString(2);
if (title != previousTitle)
{
comboValue.Add(title);
previousTitle = title;
}
timeBoxValue.Add(time);
}
}
else if (input == "" || input == null)
{
OleDbCommand myCommand = new OleDbCommand("SELECT Title, DateofPlay, TimeofPlay FROM Plays WHERE DateOfPlay = @Iputdate", myConnection);
myCommand.Parameters.AddWithValue("@InputDate", inputDateTime);
OleDbDataReader reader = myCommand.ExecuteReader();
while (reader.Read())
{
initialreturn = reader.GetString(0);
addString += "Title: " + initialreturn + " ";
initialreturn = reader.GetDateTime(1).ToShortDateString();
addString += "Date: " + initialreturn + " ";
initialreturn = reader.GetString(2);
addString += "Time: " + initialreturn + "\n";
addString += "\n";
addString += "\n";
title = reader.GetString(0);
if (title != previousTitle)
{
comboValue.Add(title);
previousTitle = title;
}
}
}
myConnection.Close();
returnAllPlays = addString;
//AllPlaysl.Text = returnAllPlays;
return(returnAllPlays);
}
public static int Users_CreateUser(DbConnection connection, DbTransaction trans, string applicationId, string username, bool isAnonymous, DateTime lastActivityDate, ref object userId)
{
string selectQuery = "SELECT UserId FROM aspnet_Users WHERE LoweredUserName = ? AND ApplicationId = ?";
OleDbCommand selectCmd = new OleDbCommand(selectQuery, (OleDbConnection)connection);
AddParameter(selectCmd, "LoweredUserName", username.ToLowerInvariant());
AddParameter(selectCmd, "ApplicationId", applicationId);
if (trans != null)
{
selectCmd.Transaction = (OleDbTransaction)trans;
}
string existingUserId = null;
using (OleDbDataReader reader = selectCmd.ExecuteReader()) {
if (reader.Read())
{
existingUserId = reader.GetString(0);
}
}
if (existingUserId != null && existingUserId.Length > 0)
{
userId = existingUserId;
return(1); // user with such username and appid already exists
}
if (userId != null)
{
string querySelectUserId = "SELECT UserId FROM aspnet_Users WHERE UserId = ?";
OleDbCommand cmdSelectUserId = new OleDbCommand(querySelectUserId, (OleDbConnection)connection);
AddParameter(cmdSelectUserId, "UserId", userId);
if (trans != null)
{
cmdSelectUserId.Transaction = (OleDbTransaction)trans;
}
using (OleDbDataReader reader = cmdSelectUserId.ExecuteReader()) {
if (reader.Read())
{
return(2); // user with such userId already exists
}
}
}
if (userId == null)
{
userId = Guid.NewGuid().ToString();
}
string insertQuery = "INSERT INTO aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate) VALUES (?, ?, ?, ?, ?, ?)";
OleDbCommand insertCmd = new OleDbCommand(insertQuery, (OleDbConnection)connection);
AddParameter(insertCmd, "ApplicationId", applicationId);
AddParameter(insertCmd, "UserId", userId);
AddParameter(insertCmd, "UserName", username);
AddParameter(insertCmd, "LoweredUserName", username.ToLowerInvariant());
AddParameter(insertCmd, "IsAnonymous", isAnonymous);
AddParameter(insertCmd, "LastActivityDate", lastActivityDate);
if (trans != null)
{
insertCmd.Transaction = (OleDbTransaction)trans;
}
insertCmd.ExecuteNonQuery();
return(0);
}
public void SearchPlays(string titleInput, DateTime dateInput)
{
string connString;
string previousTitle = "";
connString = @"Provider=Microsoft.JET.OLEDB.4.0;Data Source = L:\Comp-1632-System Development Project\TicketBookingSystem\TicketBookingSystem\TicketSysDB.mdb";
OleDbConnection myConnection = new OleDbConnection(connString);
myConnection.Open();
if (titleInput != "" || titleInput != null)
{
OleDbCommand myCommand = new OleDbCommand("SELECT Title, DateofPlay, TimeofPlay FROM Plays WHERE Title = @InputTitle AND DateofPlay = @InputDate", myConnection);
myCommand.Parameters.AddWithValue("@InputTitle", titleInput);
myCommand.Parameters.AddWithValue("@InputDate", dateInput);
OleDbDataReader reader = myCommand.ExecuteReader();
while (reader.Read())
{
title = reader.GetString(0);
time = reader.GetString(2);
if (title != previousTitle)
{
comboValue.Add(title);
previousTitle = title;
}
timeBoxValue.Add(time);
}
}
else if (titleInput == "" || titleInput == null)
{
OleDbCommand myCommand = new OleDbCommand("SELECT Title, DateofPlay, TimeofPlay FROM Plays WHERE DateofPlay = @InputDate", myConnection);
myCommand.Parameters.AddWithValue("@InputDate", dateInput);
OleDbDataReader reader = myCommand.ExecuteReader();
while (reader.Read())
{
title = reader.GetString(0);
time = reader.GetString(2);
if (title != previousTitle)
{
comboValue.Add(title);
previousTitle = title;
}
timeBoxValue.Add(time);
}
}
myConnection.Close();
}
public List <OrderDto> ReadAllEodOrderDataToRepository()
{
OleDbConnection conn = new OleDbConnection();
List <OrderDto> listOfOrders = new List <OrderDto>();
try
{
conn = connection.GetOrdersRepositoryConnection();
conn.Open();
OleDbCommand cmd = conn.CreateCommand();
// 'DEFAULT' is used
cmd.CommandText = "Select * From MyEODShipment";
OleDbDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
while (reader.Read())
{
try
{
if (reader.GetString(1) != null && !String.IsNullOrEmpty(reader.GetString(1)))
{
OrderDto dto = new OrderDto
{
InvoiceNumber = reader.GetString(1),
TrackingCode = reader.GetString(2)
};
listOfOrders.Add(dto);
}
}
catch (Exception)
{
//
}
}
reader.Close();
}
conn.Close();
return(listOfOrders);
}
catch (InvalidOperationException exc)
{
AccessConnectionHandler.log.Error(exc);
return(listOfOrders);
}
catch (ArgumentNullException exc)
{
AccessConnectionHandler.log.Error(exc);
return(listOfOrders);
}
catch (OleDbException exc)
{
AccessConnectionHandler.log.Error(exc);
return(listOfOrders);
}
finally
{
// Close the connection
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public void ImportarPlanilha()
{
_olecon = new OleDbConnection(_StringConexao);
_olecon.Open();
_oleCmd = new OleDbCommand();
_oleCmd.Connection = _olecon;
_oleCmd.CommandType = CommandType.Text;
try
{
_oleCmd.CommandText = "SELECT * FROM [Plan1$] ";
OleDbDataReader reader = _oleCmd.ExecuteReader();
while (reader.Read())
{
string codigoEmitente = reader.GetValue(0).ToString();
Domain.Model.Conta conta = new Domain.Servicos.ContaService(this.OrganizationName, false).BuscarPorCodigoEmitente(codigoEmitente);
string unidadeNeg = reader.GetString(1).ToString();
//if (!unidadeNeg.ToUpper().Contains("ISEC"))
// continue;
Domain.Model.UnidadeNegocio unidadeNegocio = new Domain.Servicos.UnidadeNegocioService(this.OrganizationName, false).BuscaUnidadeNegocioPorNome(unidadeNeg);//"ISEC/MG");
List <Domain.Model.CompromissosDoCanal> lstCompromissosDoCanal = new List <Domain.Model.CompromissosDoCanal>();
if (conta != null && unidadeNegocio != null)
{
//lstBeneficioCanal = new Domain.Servicos.BeneficioDoCanalService(this.OrganizationName, false).ListarPorContaUnidadeNegocio(conta.ID.Value, unidadeNegocio.ID.Value);
lstCompromissosDoCanal = new Domain.Servicos.CompromissosDoCanalService(this.OrganizationName, false).ListaCompromissoCanalPorContaUnidade(conta.ID.Value, unidadeNegocio.ID.Value);
//if (lstCompromissosDoCanal.Count == 0 && unidadeNeg.Contains("ISEC"))
//{
// unidadeNegocio = new Domain.Servicos.UnidadeNegocioService(this.OrganizationName, false).BuscaUnidadeNegocioPorNome("ISEC/MG");
// if(unidadeNegocio != null)
// lstCompromissosDoCanal = new Domain.Servicos.CompromissosDoCanalService(this.OrganizationName, false).ListaCompromissoCanalPorContaUnidade(conta.ID.Value, unidadeNegocio.ID.Value);
//}
}
string linhaDeCorte = reader.GetString(2).ToString().ToUpper();
string meta = reader.GetString(3).ToString().ToUpper();
if (lstCompromissosDoCanal != null && lstCompromissosDoCanal.Count > 0)
{
foreach (var compromissoCanal in lstCompromissosDoCanal)
{
try
{
if (meta.Equals("SIM"))
{
compromissoCanal.StatusCompromisso = new SDKore.DomainModel.Lookup(new Guid("31FFD7FA-74ED-E311-9407-00155D013D38"), "");// Cumprido
}
else
{
compromissoCanal.StatusCompromisso = new SDKore.DomainModel.Lookup(new Guid("41725811-75ED-E311-9407-00155D013D38"), ""); // NaoCumprido
}
new Domain.Servicos.CompromissosDoCanalService(this.OrganizationName, false).Atualizar(compromissoCanal);
//logProcessamento.WriteLine("Conta : " + conta.ID.Value.ToString() + "/" + conta.RazaoSocial +
// " - Compromisso : " + compromissoCanal.ID.Value.ToString() + "/" + compromissoCanal.Nome +
// "Meta :" + meta);
}
catch (Exception ex)
{
logProcessamento.WriteLine("Conta : " + conta.ID.Value.ToString() + " / " + conta.RazaoSocial);
logProcessamento.WriteLine("Compromisso : " + compromissoCanal.ID.Value.ToString() + " / " + compromissoCanal.Nome);
logProcessamento.WriteLine("Meta :" + meta + " - Erro : " + ex.Message);
logProcessamento.WriteLine();
logProcessamento.WriteLine("----------------------------------------------------------------------------");
logProcessamento.WriteLine();
}
//if (!beneficioCanal.UnidadeDeNegocio.Name.ToUpper().Equals("ISEC/MG"))
// continue;
//if (meta.Equals("SIM"))
//beneficioCanal.StatusBeneficio = new SDKore.DomainModel.Lookup(new Guid("35FC4A26-75ED-E311-9407-00155D013D38"), ""); // Ativo
//else
//beneficioCanal.StatusBeneficio = new SDKore.DomainModel.Lookup(new Guid("E1654A30-75ED-E311-9407-00155D013D38"), ""); // Suspenso
//new Domain.Servicos.BeneficioDoCanalService(this.OrganizationName, false).Salvar(beneficioCanal);
}
}
}
logProcessamento.Close();
logProcessamento.Dispose();
reader.Close();
}
catch { }
}
//This method just f****d me up but I finally nailed it (Mostly :P)
//Planning to add multithreading later for better performance
public void FillButtons(Int32 theCatID, SPOSDBDataSet.ItemsDataTable theTable)
{
//needed to determine the number of items, (may get ommitted later for memory purposes)
int numOfItems = 0;
//OleDb commands needed to send queries via OleDbConnection
OleDbCommand theCmd = new OleDbCommand
{
CommandText = "SELECT COUNT(*) FROM Items WHERE CatID = " + theCatID,
CommandType = CommandType.Text,
CommandTimeout = 2,
Connection = oLEConnection
};
OleDbCommand theCmd2 = new OleDbCommand
{
CommandText = "SELECT ItemID, ItemName FROM Items where CatID = " + theCatID,
CommandType = CommandType.Text,
CommandTimeout = 2,
Connection = oLEConnection
};
try
{
//This will return the first value in first column and colses the reader by it self
//numOfItems may not get ommitted after all
numOfItems = (int)theCmd.ExecuteScalar();
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
//This will clean the buttons in order to rearrange them, maybe needs a better coding will think of a better way later
//Added try since at first the array will be empty so that it does not send an error, so this is normal, will check what the catch do later
try
{
//Will just clean the buttons
//First it will check if the length > 0 which if true then it means there are buttons inside the tab view
if (abu.Length > 0)
{
for (int i = 0; i < abu.GetLength(0); i++)
{
for (int j = 0; j < abu.GetLength(1); j++)
{
//Will remove each button maybe will try using for each
//Will also check Dispose function if better but for now this is a working code :D
tab_buy.Controls.Remove(abu[i, j]);
}
}
}
}
catch (Exception ex) {
}
//Stepepr is actually my fav variable :P
//It represents the spacing between each button, did not try changin the value to check if it will work with other values
//maybe later, at least it worked right?...right ;-;
int stepper = 6;
//Default stuff blah, blah, blahhh
int defWidth = 120;
int defHeight = 120;
//Represents the next position for each coords for each button
int nextPosX = 0;
int nextPosY = 6;
//Default used colors will optimize it later
Color defColor = Color.Aquamarine;
Color nextColor = Color.Lime;
Color ChosenColor = defColor;
//not sure where I used this but will keep it for now
int n = 0;
//this took most of my time to calculate but finally nailed it :D
//it column count represents how many columns are used
//row count is calculated by dividing how many items we have by the column count then ceiling it
//for example if we have 12 items and the window width is 577
//column count would be 4
//then row count will be 12/4 = 3
int columnCount = tab_buy.Width / (defWidth + (stepper * 2));
double rowCount = Math.Ceiling((double)numOfItems / columnCount);
//this will help in stopping at the last item in the last row
int itemsCount = 0;
//added try since it is giving an error when we resize the window too much
//will check why later
try
{
//declare the array of buttons objects with the first dimension being the rowCount and the second dimension columnCount
abu = new Button[(int)rowCount, columnCount];
try
{
//This is where most of the db magic happens, this makes a link to the db using the query in theCmd2
//Needs a .Read() to get to the first and next elements
theReader = theCmd2.ExecuteReader();
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
//start showing the buttons
for (int i = 0; i < rowCount; i++)
{
//show buttons for each row
for (int j = 0; j < columnCount && itemsCount != numOfItems; j++)
{
theReader.Read();
//give the new button its characteristics
//location is calculated according to a variable stepper which is the distance between each button
//and a nextPos(X/Y) with nextPosX is the X position of the button
//nextPosY is the Y position of the button
//Colors needs a revamp and will be based on the selected theme with themes becoming customizable
abu[i, j] = new Button
{
Location = new Point(nextPosX, nextPosY),
Size = new Size(defWidth, defHeight),
Font = new Font("Montserrat", 11.25f, FontStyle.Bold),
//This one will contain the ID of the Item, needed a lot to access the ID of the Item from the button
Name = "" + theReader.GetInt32(0),
FlatStyle = FlatStyle.Flat,
BackColor = ChosenColor,
//Gets the name of the Item
Text = theReader.GetString(1)
};
//could not be used inside the button's characteristics had to use it outside, not sure why yet
abu[i, j].FlatAppearance.BorderSize = 0;
//nextPosX increasing by button's width and the stepper
nextPosX += (defWidth + stepper);
//add the charactirized button
tab_buy.Controls.Add(abu[i, j]);
abu[i, j].Click += new System.EventHandler(this.AButtonClicked);
//increase the sum of items
itemsCount++;
}
//nextPosY increasing by button's height and the stepper
nextPosY += (defHeight + stepper);
nextPosX = 0;
//color switcher for each n, will be changed for sure later...
if (n == 1)
{
ChosenColor = defColor;
n = 0;
}
else
{
ChosenColor = nextColor;
n = 1;
}
}
}
//Used for error reporting
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
}
public List <Auto> GetCars()
{
OleDbTransaction trans = null;
OleDbDataReader kapReader = null;
List <Auto> ret = new List <Auto>();
Auto tmp;
try
{
if (connection == null)
{
GetConnection();
}
trans = connection.BeginTransaction();
allCars.Transaction = trans;
kapReader = allCars.ExecuteReader();
while (kapReader.Read())
{
tmp = new Auto(kapReader.GetString(0));
tmp.Kapacitas = kapReader.GetByte(1);
tmp.Fogyasztas = kapReader.GetFloat(3);
tmp.Lizingdij = kapReader.GetFloat(2);
ret.Add(tmp);
}
trans.Commit();
}
catch (OleDbException ex)
{
MessageBox.Show("Adatbázis elérési hiba.\nKérem ellenőrizze, hogy az adatbázist más alkalmazás nem használja-e!", "Hiba", MessageBoxButtons.OK, MessageBoxIcon.Error);
AppLogger.WriteException(ex);
AppLogger.WriteEvent("A kivétel elkapva.");
trans.Rollback();
}
catch (InvalidOperationException inv)
{
}
catch (Exception e)
{
AppLogger.WriteException(e);
AppLogger.WriteEvent("A kivétel elkapva.");
trans.Rollback();
}
finally
{
if (kapReader != null)
{
kapReader.Close();
}
trans = null;
}
return(ret);
}
public override void DoWork(object idTaskStatus)
{
var session = Db <WebEnvironmentFiact> .NSession;
var status = session.Get <StatusTask>((int)idTaskStatus);
try
{
cls_IPSIAPI api = new PSI_API.cls_IPSIAPIClass();
var loginInfo = new typLoginInfo
{
strUser = ConfigurationManager.AppSettings["psiLogin"],
strPassword = ConfigurationManager.AppSettings["psiPassword"],
strUserClass = ConfigurationManager.AppSettings["psiUserClass"],
strView = ConfigurationManager.AppSettings["psiView"]
};
api.vbLogin(loginInfo);
using (OleDbConnection excelConnection = new OleDbConnection(String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}; Extended Properties=Excel 12.0;", ConfigurationManager.AppSettings["eitpConfigFile"])))
{
excelConnection.Open();
using (OleDbCommand excelCommand = new OleDbCommand(String.Format("select * from [{0}$]", ConfigurationManager.AppSettings["configSheetName"]), excelConnection))
{
using (OleDbDataReader excelReader = excelCommand.ExecuteReader())
{
while (excelReader.Read())
{
if (excelReader.GetValue(5) == DBNull.Value)
{
continue;
}
String pbTag = excelReader.GetString(5) +
ConfigurationManager.AppSettings["pbTagSuffix"];
String pTag = excelReader.GetString(5) + ConfigurationManager.AppSettings["ptagSuffix"];
String qTag = excelReader.GetString(5) + ConfigurationManager.AppSettings["qTagSuffix"];
String tTag = excelReader.GetString(5) + ConfigurationManager.AppSettings["tTagSuffix"];
String internalTag = excelReader.GetString(1);
if (String.IsNullOrEmpty(internalTag))
{
continue;
}
using (NpgsqlConnection connection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["eitp"].ConnectionString))
{
String sql = String.Format(ConfigurationManager.AppSettings["eitpRTsql"],
internalTag);
try
{
using (NpgsqlCommand command = new NpgsqlCommand(sql, connection))
{
var tag = String.Format("SY.SNMP.{0}.PKOPET...LINK4", ConfigurationManager.AppSettings["lpuKey"]);
try
{
connection.Open();
api.vbSetPAValue(ref tag, new typeValue {
Wert = 1
});
}
catch (Exception e)
{
api.vbSetPAValue(ref tag, new typeValue {
Wert = 1
});
}
using (NpgsqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
if (reader.GetValue(1) != DBNull.Value)
{
api.vbSetPAValue(pbTag,
new typeValue
{
Wert = reader.GetDouble(1),
Zeit = reader.GetDateTime(0)
});
}
if (reader.GetValue(2) != DBNull.Value)
{
api.vbSetPAValue(pTag,
new typeValue
{
Wert = reader.GetDouble(2),
Zeit = reader.GetDateTime(0)
});
}
if (reader.GetValue(3) != DBNull.Value)
{
api.vbSetPAValue(qTag,
new typeValue
{
Wert = reader.GetDouble(3),
Zeit = reader.GetDateTime(0)
});
}
if (reader.GetValue(4) != DBNull.Value)
{
api.vbSetPAValue(tTag,
new typeValue
{
Wert = reader.GetDouble(4),
Zeit = reader.GetDateTime(0)
});
}
}
}
}
}
catch (COMException ex)
{
}
}
}
}
}
}
api.vbLogout();
session.Evict(status);
status = session.Get <StatusTask>(idTaskStatus);
status.TaskExecType = TaskExecType.Succeed;
}
catch (Exception e)
{
session.Evict(status);
status = session.Get <StatusTask>(idTaskStatus);
status.Error = e.ToString();
status.TaskExecType = TaskExecType.Failure;
}
status.EndRun = DateTime.Now;
session.Save(status);
session.Flush();
}
protected string ReadAsString(OleDbDataReader reader, int index)
{
return(!reader.IsDBNull(index) ? reader.GetString(index) : null);
}
private void Next_picturebox_Click(object sender, EventArgs e)
{
/* BEFORE GOES TO NEXT LEVEL */
//Put it in array
foreach (RadioButton btn in quiz_panel.Controls.OfType <RadioButton>())
{
if (btn.Checked == true)
{
tag_answer[metritis] = Int32.Parse(btn.Tag.ToString());
btn.Checked = false; //uncheck
}
}
if (readyForsubmit)
{
timer1.Stop();
Next_picturebox.Enabled = false;
Previous_picturebox.Enabled = false;
MessageBox.Show("Quiz successfully completed !");
//submit score and bla bla
time = timer_count_label.Text;
int pointer = 0;
foreach (int correctAnswer in correctAnswers)
{
if (correctAnswer == tag_answer[pointer])
{
score++;
}
pointer++;
}
MessageBox.Show("Your score is : " + score.ToString() + "/10");
int lvl = 0;
DateTime now = DateTime.Now;
String last = now.ToString();
connection.Open();
OleDbCommand cmd1 = new OleDbCommand();//+score+" '" + password_textbox.Text + "','" + email_textbox.Text + "')";
cmd1.Connection = connection;
if (level == "easy")
{
lvl = 1;
cmd1.CommandText = "insert into Table4(username,score,levelPlayed,datePlayed,timescore1) values('" + username + "'," + score + "," + lvl + ",'" + last + "','" + time + "')";
}
else if (level == "medium")
{
lvl = 2;
cmd1.CommandText = "insert into Table4(username,score,levelPlayed,datePlayed,timescore1) values('" + username + "'," + score + "," + lvl + ",'" + last + "','" + time + "')";
}
else
{
lvl = 3;
cmd1.CommandText = "insert into Table4(username,score,levelPlayed,datePlayed,timescore1) values('" + username + "'," + score + "," + lvl + ",'" + last + "','" + time + "')";
}
cmd1.ExecuteNonQuery();
connection.Close();
}
//goes next
if (question_number < 10)
{
Next_picturebox.Visible = true;
question_number++;
question_number_label.Text = question_number + "/10";
}
if (question_number == 10)
{
Next_picturebox.Image = Properties.Resources.check;
readyForsubmit = true;
}
if (question_number != 1)
{
Previous_picturebox.Visible = true;
}
metritis++;
connection.Open();
if (metritis >= 0 && metritis < 10)
{
if (level == "easy")
{
query = "SELECT * FROM Table2 where ID=" + x[metritis] + "";
}
else if (level == "medium")
{
query = "SELECT * FROM Table3 where ID=" + x[metritis] + "";
}
else if (level == "hard")
{
if (metritis >= 0 && metritis < 5)
{
query = "SELECT * FROM Table2 where ID=" + x[metritis] + "";
}
else
{
query = "SELECT * FROM Table3 where ID=" + x[metritis] + "";
}
}
OleDbCommand cmd = new OleDbCommand(query, connection);
OleDbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
question_richtextbox.Text = rdr.GetString(1);
answer_1.Text = rdr.GetString(2);
answer_2.Text = rdr.GetString(3);
answer_3.Text = rdr.GetString(4);
answer_4.Text = rdr.GetString(5);
correctAnswers[metritis] = Int32.Parse(rdr.GetString(6));
}
}
connection.Close();
//next level show the answer if it was answered before
if (!readyForsubmit)
{
if (tag_answer[metritis] == 1)
{
answer_1.Checked = true;
}
else if (tag_answer[metritis] == 2)
{
answer_2.Checked = true;
}
else if (tag_answer[metritis] == 3)
{
answer_3.Checked = true;
}
else if (tag_answer[metritis] == 4)
{
answer_4.Checked = true;
}
}
}
void copyEmployeeTable()
{
string sql = "SELECT id, NТабельный, Подразделение, Звено, Имя, Фамилия, ФИО, ПрофессияДолжность, Разряд, Операция, ВыполняемыеОперации, ДатаНайма, Работает, Категория, Адрес, ДомашнийТелефон, ДатаРождения, МестоРождения, МестоУчебы, ГодОкУЗ, Факультет, Специальность, ПредМР, Примечания, УслТруда, КТУ, WORKERSUM, UserLogin, Руководитель, PassportSeria, RealAdress, FamilyStatus, PassportNumber, PassportDate, PassportOffice, PersonalNumber, MobilePhoneZone, MobilePhone, Profession1, Profession2, Profession3, Profession4, Profession5, Profession6, Rost, Razmer, RazmerObuvi, ПрофессияСИЗ, КодРазмера, Sex FROM РаботникиЦеха";// where NТабельный=11980";
OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.connStr);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader r = cmd.ExecuteReader();
while (r.Read())
{
Employee emp = new Employee();
emp.employeeId = r.GetInt32(0);
emp.nTabelnyj = r.GetInt32(1);
emp.deptId = r.GetInt16(2);
if (r[3] != DBNull.Value)
{
emp.zveno = r.GetString(3);
}
if (r[4] != DBNull.Value)
{
emp.firstName = r.GetString(4);
}
if (r[5] != DBNull.Value)
{
emp.secondName = r.GetString(5);
}
if (r[6] != DBNull.Value)
{
emp.fullName = r.GetString(6);
}
if (r[7] != DBNull.Value)
{
emp.position = r.GetInt16(7);
}
if (r[8] != DBNull.Value)
{
emp.rank = r.GetByte(8);
}
if (r[11] != DBNull.Value)
{
emp.dateOfEmployment = r.GetDateTime(11);
}
if (r[12] != DBNull.Value)
{
emp.working = r.GetBoolean(12);
}
if (r[13] != DBNull.Value)
{
emp.categoryId = r.GetByte(13);
}
if (r[14] != DBNull.Value)
{
emp.address = r.GetString(14);
}
if (r[15] != DBNull.Value)
{
emp.homePhone = r.GetString(15);
}
if (r[16] != DBNull.Value)
{
emp.birthday = r.GetDateTime(16);
}
if (r[17] != DBNull.Value)
{
emp.birthplace = r.GetString(17);
}
if (r[18] != DBNull.Value)
{
emp.education = r.GetString(18);
}
if (r[19] != DBNull.Value)
{
emp.eduYear = r.GetInt16(19);
}
if (r[20] != DBNull.Value)
{
emp.faculty = r.GetString(20);
}
if (r[21] != DBNull.Value)
{
emp.specialty = r.GetString(21);
}
if (r[22] != DBNull.Value)
{
emp.previousEmployment = r.GetString(22);
}
if (r[23] != DBNull.Value)
{
emp.note = r.GetString(23);
}
if (r[24] != DBNull.Value)
{
emp.workingConditions = r.GetDouble(24);
}
if (r[25] != DBNull.Value)
{
emp.salary = r.GetDouble(25);
}
if (r[27] != DBNull.Value)
{
emp.userLogin = r.GetString(27);
}
if (r[28] != DBNull.Value)
{
emp.managerId = r.GetInt32(28);
}
if (r[29] != DBNull.Value)
{
emp.passportSeries = r.GetString(29);
}
if (r[30] != DBNull.Value)
{
emp.realAddress = r.GetString(30);
}
if (r[31] != DBNull.Value)
{
emp.familyStatus = r.GetString(31);
}
if (r[32] != DBNull.Value)
{
emp.passportNumber = r.GetString(32);
}
if (r[33] != DBNull.Value)
{
emp.passportDate = r.GetDateTime(33);
}
if (r[34] != DBNull.Value)
{
emp.passportOffice = r.GetString(34);
}
if (r[35] != DBNull.Value)
{
emp.personalNumber = r.GetString(35);
}
if (r[36] != DBNull.Value)
{
emp.mobilePhoneZone = r.GetString(36);
}
if (r[37] != DBNull.Value)
{
emp.mobilePhone = r.GetString(37);
}
if (r[38] != DBNull.Value)
{
emp.professionId1 = r.GetInt16(38);
}
if (r[39] != DBNull.Value)
{
emp.professionId2 = r.GetInt16(39);
}
if (r[40] != DBNull.Value)
{
emp.professionId3 = r.GetInt16(40);
}
if (r[41] != DBNull.Value)
{
emp.professionId4 = r.GetInt16(41);
}
if (r[42] != DBNull.Value)
{
emp.professionId5 = r.GetInt16(42);
}
if (r[43] != DBNull.Value)
{
emp.professionId6 = r.GetInt16(43);
}
if (r[44] != DBNull.Value)
{
emp.height = r.GetInt32(44);
}
if (r[45] != DBNull.Value)
{
emp.clothingSize = r.GetInt32(45);
}
if (r[46] != DBNull.Value)
{
emp.shoeSize = r.GetInt32(46);
}
if (r[47] != DBNull.Value)
{
emp.meansOfProtectionByPosition = r.GetInt32(47);
}
if (r[48] != DBNull.Value)
{
emp.clothingSizeTypeId = r.GetByte(48);
}
if (r[49] != DBNull.Value)
{
emp.gender = r.GetString(49);
}
/*
* string json = JsonConvert.SerializeObject(emp, Formatting.None, new JsonSerializerSettings
* {
* NullValueHandling = NullValueHandling.Ignore
* });
* MessageBox.Show(json);
*/
Employee emp2 = rest.saveEntity <Employee>(emp);
}
r.Close();
cmd.Dispose();
conn.Close();
MessageBox.Show("Done!");
}
