private void LoginButton_Click(object sender, EventArgs e)
{
try
{
//checking if the username field is empty or not
if (!(UserNameBox.Text == string.Empty))
{
//checking if the password field is empty or not
if (!(PasswordBox.Text == string.Empty))
{
//my connection string
String ConStr = "Data Source=FEROZE;Initial Catalog=InventoryApp;Integrated Security=True";
//opening sql connection
SqlConnection Conn = new SqlConnection(ConStr);
Conn.Open();
//writing query for it login
String query = "select * from Users where Username='******' and Password='******' ";
//giving sql command
SqlCommand Cmd = new SqlCommand(query, Conn);
//sql data reader
SqlDataReader dbr;
dbr = Cmd.ExecuteReader();
//getting data from the db
int count = 0;
while (dbr.Read())
{
count = count + 1;
}
if (count == 1)
{
MainForm obj = new MainForm();
obj.Show();
this.Hide();
}
else if (count < 1)
{
MessageBox.Show("incorrect username or password");
}
}
else
{
MessageBox.Show("Please enter the password");
}
}
else
{
MessageBox.Show("Please enter the username");
}
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
}
static void Main()
{
#if !DEBUG
Sentry.Initialise();
#endif
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
MainForm form = new MainForm();
Application.Run(form);
}
internal static void CheckNewVersion(MainForm mainForm)
{
Task.Factory.StartNew(() =>
{
var tempdir = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Global.APPNAME, Global.UPDATE_TEMP_DIRPATH);
var batchpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Global.APPNAME, "update.bat");
if (Directory.Exists(tempdir))
{
Directory.Delete(tempdir, true);
}
Directory.CreateDirectory(tempdir);
var resp = WebApi.Request(string.Format("https://api.github.com/repos/{0}/releases/latest", Global.GITHUB_REPO));
if (resp == null)
{
Log.E("새 업데이트 정보를 받아오지 못했습니다");
return;
}
try {
var api = JsonConvert.DeserializeObject<dynamic>(resp);
var latest = api.tag_name.ToObject<string>();
Log.I("현재 버전: {0}", Global.VERSION);
Log.I("최신 버전: {0}", latest);
if (decimal.Parse(Global.VERSION.Substring(1)) >= decimal.Parse(latest.Substring(1)))
{
Log.S("최신 버전을 이용중입니다");
}
else
{
Log.S("새로운 업데이트가 존재합니다");
if (Settings.AutoUpdate)
{
string url = null;
foreach (var asset in api.assets)
{
if (asset.name == string.Format("DFAssist.{0}.zip", latest))
{
url = asset.browser_download_url;
}
}
if (url == null)
{
Log.E("업데이트 파일을 찾을 수 없습니다");
return;
}
mainForm.Invoke(() =>
{
mainForm.Hide();
mainForm.overlayForm.Hide();
});
Task.Factory.StartNew(() =>
{
var updaterForm = new UpdaterForm();
updaterForm.SetVersion(latest);
updaterForm.ShowDialog();
});
Sentry.Report("Update started");
var stream = GetDownloadStreamByUrl(url);
using (ZipStorer zip = ZipStorer.Open(stream, FileAccess.Read))
{
List<ZipStorer.ZipFileEntry> dir = zip.ReadCentralDir();
foreach (ZipStorer.ZipFileEntry entry in dir)
{
if (entry.FilenameInZip == "README.txt")
{
continue;
}
zip.ExtractFile(entry, Path.Combine(tempdir, entry.FilenameInZip));
}
}
var exepath = Process.GetCurrentProcess().MainModule.FileName;
var currentdir = Path.GetDirectoryName(exepath);
File.WriteAllText(batchpath, string.Format(
"@echo off\r\n" +
"title DFAssist Updater\r\n" +
"echo Updating DFAssist...\r\n" +
"ping 127.0.0.1 -n 3 > nul\r\n" +
"move /y \"{0}\\*\" \"{1}\" > nul\r\n" +
"\"{2}\"\r\n" +
"echo Running DFAssist...\r\n",
tempdir, // 0
currentdir, // 1
exepath // 2
), Encoding.Default);
ProcessStartInfo si = new ProcessStartInfo();
si.FileName = batchpath;
si.CreateNoWindow = true;
si.UseShellExecute = false;
si.WindowStyle = ProcessWindowStyle.Hidden;
Process.Start(si);
Settings.Updated = true;
Settings.Save();
Application.Exit();
}
else
{
mainForm.Invoke(() =>
{
mainForm.linkLabel_NewUpdate.Visible = true;
mainForm.linkLabel_NewUpdate.Select();
mainForm.Show();
});
}
}
}
catch (Exception ex)
{
Log.Ex(ex, "업데이트 데이터 처리중 에러 발생");
}
try
{
var xml = WebApi.Request(string.Format("https://raw.githubusercontent.com/{0}/master/App/Resources/ZoneList.xml", Global.GITHUB_REPO));
Data.Initializer(xml);
}
catch (Exception ex)
{
Log.Ex(ex, "임무 데이터 업데이트중 에러 발생");
}
});
}