private void metroButton1_Click(object sender, EventArgs e)
{
string currentDate = DateTime.Today.ToString("dd-MM-yyyy");
// البحث عن طالب
try
{
if (txtseatNo.Text != "")
{
int count = adabstu.FillBy(dataDataSet1.studentData, Convert.ToInt32(txtseatNo.Text));
if (count != 0)
{
txtname.Text = dataDataSet1.studentData.Rows[0]["stname"].ToString();
txtschool.Text = dataDataSet1.studentData.Rows[0]["scname"].ToString();
regionText.Text = dataDataSet1.studentData.Rows[0]["examScid"].ToString();
seerTxt.Text = dataDataSet1.studentData.Rows[0]["examscname"].ToString();
lagnaNumTxt.Text = dataDataSet1.studentData.Rows[0]["seercode"].ToString();
typedesc.Text = dataDataSet1.studentData.Rows[0]["type_adesc"].ToString();
stType.Text = dataDataSet1.studentData.Rows[0]["st_type"].ToString();
// depatText.Text = dataDataSet1.studentData.Rows[0]["typecode"].ToString();
//gender = dataDataSet1.studentData.Rows[0]["sex"];
int typecode = Convert.ToInt32(dataDataSet1.studentData.Rows[0]["typecode"].ToString());
if (cmbcourse.SelectedIndex == -1)
{
// adabexam.FillBytype(dataDataSet1.examTable, typecode);
adabexam.FillByToday(dataDataSet1.examTable, typecode, DateTime.Today);
}
if (!IsEqualprevDep())
{
// adabexam.FillBytype(dataDataSet1.examTable, typecode);
adabexam.FillByToday(dataDataSet1.examTable, typecode, DateTime.Today);
}
cmbcourse.DisplayMember = "examName";
cmbcourse.ValueMember = "examId";
list = dataDataSet1.examTable;
cmbcourse.DataSource = list;
//if (!IsEqualprevDep())
examscname = dataDataSet1.studentData.Rows[0]["examscname"].ToString();
}
else
{
MetroMessageBox.Show(this, "رقم الجلوس غير مسجل بالنظام", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150);
}
}
else
{
MetroMessageBox.Show(this, "من فضلك أدخل رقم الجلوس", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Warning, 150);
}
}
catch (Exception g)
{
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
MetroMessageBox.Show(this, "Do you like this metro message box?", "Metro Title", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Asterisk);
}
private void metroButton8_Click(object sender, EventArgs e)
{
MetroMessageBox.Show(this, "This is a sample MetroMessagebox `Yes`, `No` and `Cancel` button", "MetroMessagebox", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
}
private void metroLink2_Click(object sender, EventArgs e)
{
Clipboard.SetData(DataFormats.Text, "https://bowlroll.net/file/95442");
System.Diagnostics.Process.Start("https://bowlroll.net/file/95442");
MetroMessageBox.Show(this, "已经复制到剪切板", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnCreate_Click(object sender, EventArgs e) //triggers the creation of a new field
{
bool error = false;
foreach (TableDef oneTable in clsDataStorage.db.TableDefs) //loops through the tabledefinitions
{
if (oneTable.Attributes == 0)
{
foreach (Field abcd in oneTable.Fields)
{
if (abcd.Name == txtFieldName.Text) //check if table already contains a field with the same name
{
MetroMessageBox.Show(this, "This table already contains a field with the name " + abcd.Name + ".\nField names have to be unique!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
error = true;
}
}
if (cmbFieldProperty.Text == "Primary" || cmbFieldProperty.Text == "Unique") //check if table contains primary or unique elements
{
foreach (Index inx in oneTable.Indexes)
{
if (inx.Primary == true && !error)
{
MetroMessageBox.Show(this, "This table already contains a field with the property INDEX.\nA table can only contain one index.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
error = true;
break;
}
if (inx.Unique == true && !error)
{
MetroMessageBox.Show(this, "This table already contains a field with the property UNIQUE.\nA table can only contain one UNIQUE.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
error = true;
break;
}
}
}
}
}
if (!error) //if no primary or unique, then create a new field
{
table = clsDataStorage.db.TableDefs[cmbListTable.Text];
string name;
name = txtFieldName.Text;
int size;
Field field = new Field();
//creates the field according to the type chosen by the user
if (cmbFieldType.Text == "Long")
{
size = Convert.ToInt32(txtFieldSize.Text);
field = table.CreateField(name, DAO.DataTypeEnum.dbLong, size);
if (chkAuto.Checked)
{
field.Attributes = (int)DAO.FieldAttributeEnum.dbAutoIncrField;
}
}
else if (cmbFieldType.Text == "Double")
{
size = Convert.ToInt32(txtFieldSize.Text);
field = table.CreateField(name, DAO.DataTypeEnum.dbDouble, size);
}
else if (cmbFieldType.Text == "Text")
{
size = Convert.ToInt32(txtFieldSize.Text);
field = table.CreateField(name, DAO.DataTypeEnum.dbText, size);
}
else if (cmbFieldType.Text == "Currency")
{
size = Convert.ToInt32(txtFieldSize.Text);
field = table.CreateField(name, DAO.DataTypeEnum.dbCurrency, size);
}
else if (cmbFieldType.Text == "Boolean")
{
size = Convert.ToInt32(txtFieldSize.Text);
field = table.CreateField(name, DAO.DataTypeEnum.dbBoolean, size);
}
else
{
field = table.CreateField(name, DAO.DataTypeEnum.dbDate);
}
table.Fields.Append(field); //appends the field to the table
if (cmbFieldProperty.Text == "Primary") //check if field is primary, then append the property
{
Index index = table.CreateIndex("pk_" + name);
field = index.CreateField(name);
index.Primary = true;
index.Required = true;
index.IgnoreNulls = false;
((IndexFields)index.Fields).Append(field);
table.Indexes.Append(index);
}
else if (cmbFieldProperty.Text == "Unique") //check if field is unique, then append the property
{
Index index = table.CreateIndex("unq_" + name);
field = index.CreateField(name);
index.Required = true;
index.Unique = true;
index.IgnoreNulls = false;
((IndexFields)index.Fields).Append(field);
table.Indexes.Append(index);
}
else if (cmbFieldProperty.Text == "Index") //check if field is index, then append the property
{
Index index = table.CreateIndex("idx_" + name);
field = index.CreateField(name);
index.Required = true;
index.Unique = true;
index.IgnoreNulls = false;
((IndexFields)index.Fields).Append(field);
table.Indexes.Append(index);
}
MetroMessageBox.Show(this, "The new field was included successfully.", "New field", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close(); //after the field being added, closes the form
}
}
private void OnDisconnect(object sender, SessionEventArgs e)
{
MetroMessageBox.Show(this, $"\nNetwork Session Successfully Disposed",
$"Disconnected", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void metroButton9_Click(object sender, EventArgs e)
{
MetroMessageBox.Show(this, "This is a sample MetroMessagebox `Abort`, `Retry` and `Ignore` button. With Error style.", "MetroMessagebox", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error);
}
public static void ShowError(string message)
{
MetroMessageBox.Show(FrmMain.Instance, message, "Ha ocurrido un error! Nooooo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
private void LoginProcess()
{
// 빈값 비교 처리
// TxtUserID나 TxtUserPW가 빈 값일 경우 아래 코드 실행
if (string.IsNullOrEmpty(TxtUserID.Text) || string.IsNullOrEmpty(TxtUserPW.Text))
{
MetroMessageBox.Show(this, "아이디나 패스워드를 입력하세요!", "로그인", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
// 실제 DB처리
string resultId = string.Empty;
try
{
// MySql Connection
using (MySqlConnection conn = new MySqlConnection(Commons.CONNSTR))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
// space 신경써서 꼭! 넣어주기
// @userID, @password -> 파라미터 : 입력값을 가져옴
cmd.CommandText = "SELECT UserID FROM usertbl " +
" WHERE UserID = @userID " +
" AND Password = @password ";
MySqlParameter paramUserId = new MySqlParameter("@userID", MySqlDbType.VarChar, 12);
// 입력시 발생하는 공백을 제거하기 위해 Trim()을 사용한다.
paramUserId.Value = TxtUserID.Text.Trim();
MySqlParameter paramUserPw = new MySqlParameter("@password", MySqlDbType.VarChar);
paramUserPw.Value = TxtUserPW.Text.Trim();
// Id, PW를 입력
cmd.Parameters.Add(paramUserId);
cmd.Parameters.Add(paramUserPw);
MySqlDataReader reader = cmd.ExecuteReader();
// 값을 확인하고 읽어옴
reader.Read();
// 읽어온 값이 아무것도 없는 경우 (읽어온 값이 있으면 return 1;)
if (!reader.HasRows)
{
MetroMessageBox.Show(this, "아이디나 패스워드를 정확히 입력하세요.", "로그인 실패",
MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtUserID.Text = TxtUserPW.Text = "";
TxtUserID.Focus();
return;
}
// 읽어온 값 중 userID의 값이 null 이 아니면 문자열로 변환
resultId = reader["userID"] != null ? reader["userID"].ToString() : string.Empty;
this.mainForm.Login = true;
MetroMessageBox.Show(this, $"로그인성공 : {resultId}");
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, $"DB접속 에러 : {ex.Message}", "로그인에러", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(resultId))
{
MetroMessageBox.Show(this, "아이디나 패스워드를 정확히 입력하세요.", "로그인 실패",
MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtUserID.Text = TxtUserPW.Text = "";
TxtUserID.Focus();
return;
}
// resultID의 결과가 있는 경우 로그인창 종료
else
{
this.Close();
}
}
/// <summary>
/// Entry point... this will check if we are at the initial setup
/// phase, and show the installation forms
/// </summary>
/// <returns>Returns false if the user cancels the setup before the basic settings are setup, true otherwise</returns>
public static bool Run()
{
// Load the program config
Settings Config = Settings.Default;
// If this is the first time running a new update, we need to update the config file
if (!Config.SettingsUpdated)
{
Config.Upgrade();
Config.SettingsUpdated = true;
Config.Save();
}
// If this is the first run, Get client and server install paths
if (String.IsNullOrWhiteSpace(Config.Bf2InstallDir) || !File.Exists(Path.Combine(Config.Bf2InstallDir, "bf2.exe")))
{
TraceLog.WriteLine("Empty or Invalid BF2 directory detected, running Install Form.");
if (!ShowInstallForm())
{
return(false);
}
}
// Create the "My Documents/BF2Statistics" folder
try
{
// Make sure documents folder exists
if (!Directory.Exists(Program.DocumentsFolder))
{
Directory.CreateDirectory(Program.DocumentsFolder);
}
}
catch (Exception E)
{
// Alert the user that there was an error
MessageBox.Show("We encountered an error trying to create the required \"My Documents/BF2Statistics\" folder!"
+ Environment.NewLine.Repeat(1) + E.Message,
"Setup Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
return(false);
}
// Load server go.. If we fail to load a valid server, we will come back to here
LoadClient:
{
// Load the BF2 Server
try
{
BF2Client.SetInstallPath(Config.Bf2InstallDir);
}
catch (Exception E)
{
MetroMessageBox.Show(Form.ActiveForm, E.Message, "Battlefield 2 Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// Re-prompt
if (!ShowInstallForm())
{
return(false);
}
goto LoadClient;
}
}
return(true);
}
private async void MoreInfoForm_Shown(object sender, EventArgs e)
{
ActiveControl = null;
EnableControlls(false);
var data = await _apiLib.TitleAsync(_id);
if (!string.IsNullOrEmpty(data.ErrorMessage))
{
MetroMessageBox.Show(this, data.ErrorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
EnableControlls(true);
return;
}
this.Text = data.Title;
lblFullTitle.Text = data.FullTitle;
lblOriginalTitle.Text = data.OriginalTitle;
if (string.IsNullOrEmpty(lblOriginalTitle.Text))
{
lblOriginalTitle.Visible = false;
}
if (string.IsNullOrEmpty(data.PlotLocal))
{
txtPlot.Text = data.Plot;
}
else
{
txtPlot.Text = data.PlotLocal;
if (data.PlotLocalIsRtl)
{
txtPlot.RightToLeft = RightToLeft.Yes;
}
}
var creators = new List <StarShort>();
if (data.DirectorList != null)
{
creators.AddRange(data.DirectorList);
}
if (data.WriterList != null)
{
creators.AddRange(data.WriterList);
}
if (data.TvSeriesInfo != null && !string.IsNullOrEmpty(data.TvSeriesInfo.Creators))
{
creators.AddRange(data.TvSeriesInfo.CreatorList);
}
txtPlot.Visible = lblCreatorsTitle.Visible = lblCountryTitle.Visible = lblCompanyTitle.Visible = lblRuntimeTitle.Visible = lblGenreTitle.Visible = true;
lblCreators.Text = string.Join(", ", creators.Select(cx => cx.Name).Distinct());
lblCountry.Text = string.Join(", ", data.CountryList.Select(cx => cx.Key));
lblCompany.Text = data.Companies;
lblRuntime.Text = data.RuntimeStr;
lblGenre.Text = string.Join(", ", data.GenreList.Select(cx => cx.Key));
data.Image = data.Image.Replace("/original/", "/224x308/");
using (var wc = new WebClient())
picPoster.Image = Utils.BytesToImage(await wc.DownloadDataTaskAsync(data.Image));
foreach (var act in data.ActorList.Take(6))
{
var uc = new CastUserControl();
act.Image = act.Image.Replace("/original/", "/96x132/");
using (var wc = new WebClient())
uc.CastImage = Utils.BytesToImage(await wc.DownloadDataTaskAsync(act.Image));
uc.CastName = act.Name;
uc.CastAsCharacter = act.AsCharacter;
flowLayoutPanel1.Controls.Add(uc);
}
EnableControlls(true);
}
private void btnConfirmClassInfor_Click(object sender, EventArgs e)
{
Class _class = new Class();
_class.ID = txtClassId.Text;
_class.Room = txtRoom.Text;
_class.StudentNum = 0;
_class.FormerTeacherID = null;
if (!Helper.IsInformationOfClassCorrected(_class))
{
return;
}
BackgroundWorker worker = new BackgroundWorker();
mainProgressbar.Visible = lbInformation.Visible = true;
bool success = false, isExist = true;
if (is_New)
{
lbInformation.Text = "Đang thêm lớp...";
worker.DoWork += (s, e) =>
{
isExist = classControll.IsClassExist(_class.ID);
if (!isExist)
{
success = classControll.AddNewClass(_class);
}
if (success)
{
success = teachingController.AddTeachingForClass(_class.ID);
}
};
worker.RunWorkerCompleted += (s, e) =>
{
mainProgressbar.Visible = lbInformation.Visible = false;
progressSuccess = success;
if (success && !isExist)
{
MetroMessageBox.Show(this, "Thêm lớp thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
if (isExist)
{
MetroMessageBox.Show(this, "Mã lớp này đã tồn tại. Vui lòng kiểm tra lại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroMessageBox.Show(this, "Thêm thất bại vui lòng thử lại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
};
}
else
{
lbInformation.Text = "Đang cập nhật lớp...";
worker.DoWork += (s, e) =>
{
success = classControll.UpdateClassInfor(_class.ID, _class.Room);
};
worker.RunWorkerCompleted += (s, e) =>
{
mainProgressbar.Visible = lbInformation.Visible = false;
progressSuccess = success;
if (success)
{
MetroMessageBox.Show(this, "Cập nhật thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
return;
}
else
{
MetroMessageBox.Show(this, "Cập nhật thất bại vui lòng thử lại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
};
}
worker.RunWorkerAsync();
}
// طباعة قرار الحرمان
private void btnprintqarar_Click(object sender, EventArgs e)
{
// cofigure data
DataTable dt = new DataTable();
dt.Columns.Add("seatno", typeof(string));
dt.Columns.Add("studentname", typeof(string));
dt.Columns.Add("school", typeof(string));
dt.Columns.Add("subject", typeof(string));
dt.Columns.Add("description", typeof(string));
dt.Columns.Add("seername", typeof(string));
dt.Columns.Add("examname", typeof(string));
dt.Columns.Add("examdate", typeof(string));
dt.Columns.Add("examday", typeof(string));
dt.Columns.Add("depart", typeof(string));
dt.Columns.Add("period", typeof(string));
dt.Columns.Add("year", typeof(string));
dt.Columns.Add("number", typeof(string));
dt.Columns.Add("region", typeof(string));
dt.Columns.Add("seercode", typeof(string));
dt.Rows.Add(new object[] { txtseatNo.Text, txtname.Text, txtschool.Text, cmbcourse.Text, txtreport.Text, seerTxt.Text, cmbcourse.Text, txtDate.Text, txtDay.Text, "", "", "", txtnumherman.Text, regionText.Text, lagnaNumTxt.Text });
int test = 0;
try
{
if (txtname.Text != "" && txtschool.Text != "" && txtnumherman.Text != "" && cmbType.Text != "" && cmbcourse.SelectedIndex != -1 && txtDate.Text != "" && txtDay.Text != "" && txtreport.Text != "")
{
// found in grid
if (contain() == 1)
{
String descCode = getCodeType();
adabdec.UpdateQuery1(txtreport.Text, cmbType.Text, descCode, txtnumherman.Text);
printreport(dt);
}
// else not contain
else
{
if (checknameandid() == 1)
{
// show error message
MetroMessageBox.Show(this, "هذا الرقم مسجل لطالب اخر", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100);
txtnumherman.Text = "";
return;
}
else
{
if (!hasOldReport(txtseatNo.Text))
{
if (addtodb(dt) == 1)
{
MetroMessageBox.Show(this, "تم إدخال البيانات بنجاح", "معلومات ", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100);
printreport(dt);
clear();
show();
}
}
else
{
MetroMessageBox.Show(this, "مسجل للطالب قرار حرمان جميع مجالات او نهائي", " موجود من قبل ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, 100);
}
}
}
}
else
{
MetroMessageBox.Show(this, "من فضلك أكمل البيانات أولا", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100);
}
}
catch (Exception ff)
{
if (test == 1)
{
MetroMessageBox.Show(this, "تم إدخال البيانات بنجاح", "معلومات ", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100);
frmReportsMahader f = new frmReportsMahader(dt);
clear();
show();
}
}
}
private void devgrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
// عرض قرار سابق من الجريد
if (e.ColumnIndex == 6)
{
adabdec.SearchByID(dataDataSet1.decTbl, Convert.ToInt32(devgrid.Rows[e.RowIndex].Cells[0].Value));
dataDataSet.decTblDataTable list1 = dataDataSet1.decTbl;
if (list1.Count != 0)
{
txtname.Text = list1[0].stName;
txtschool.Text = list1[0].scName;
txtseatNo.Text = list1[0].seatNo.ToString();
cmbcourse.Text = list1[0].examName;
txtnumherman.Text = list1[0].decNumber;
txtreport.Text = list1[0].dec_desc;
regionText.Text = list1[0].region;
seerTxt.Text = list1[0].examscName;
lagnaNumTxt.Text = list1[0].type_str;
txtDate.Text = list1[0].examDate;
DateTime dateTime = DateTime.Parse(txtDate.Text);
txtDay.Text = dateTime.ToString("dddd", new System.Globalization.CultureInfo("ar-AE"));
// txtDay.Text = list1[0].examday;
//cmbcourse.Text = list1[0].examName;
adabstu.FillBy(dataDataSet1.studentData, Convert.ToInt32(txtseatNo.Text));
adabexam.FillBytype(dataDataSet1.examTable, Convert.ToInt32(dataDataSet1.studentData.Rows[0][4].ToString()));
cmbcourse.DisplayMember = "examName";
cmbcourse.ValueMember = "examId";
list = dataDataSet1.examTable;
cmbcourse.DataSource = list;
cmbcourse.Text = list1[0].examName;
// cmbType.Text = cmbcourse.Text;
metroTextBox1.Text = list1[0].decType;
adabeReport.Fill(dataDataSet1.reportTypes);
cmbType.DisplayMember = "description";
cmbType.ValueMember = "Id";
reportTypeList = dataDataSet1.reportTypes;
cmbType.DataSource = reportTypeList;
cmbType.Text = metroTextBox1.Text;
}
}
// حذف قرار
else if (e.ColumnIndex == 7)
{
int test = 0;
DialogResult res = MetroMessageBox.Show(this, "هل أنت متأكد من حذف هذا القرار \n مع العلم سيتم حذفه نهائياَ؟", "معلومات", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, 150);
if (res == DialogResult.Yes)
{
adabdec.SearchByID(dataDataSet1.decTbl, Convert.ToInt32(devgrid.Rows[e.RowIndex].Cells[0].Value));
dataDataSet.decTblDataTable list = dataDataSet1.decTbl;
if (list.Count != 0)
{
test = adabdec.DeleteQuery(list[0].decNumber, Int32.Parse(list[0].seatNo));
if (test == 1)
{
MetroMessageBox.Show(this, "تم حذف البيانات بنجاح", "معلومات ", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, 100);
show();
}
}
}
}
}
}
catch (Exception v)
{
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
var strUserId = "";
if (string.IsNullOrEmpty(TxtUserId.Text) || string.IsNullOrEmpty(TxtPassword.Text))
{
MetroMessageBox.Show(this, "아이디/패스워드를 입력하세요!", "오류",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
// SqlConnection 연결
using (SqlConnection conn = new SqlConnection(Helper.Common.ConnString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
var query = "SELECT userID FROM membertbl " +
" WHERE userID = @userID " +
" AND passwords = @passwords " +
" AND levels = 'S' ";
// SqlCommand 생성
SqlCommand cmd = new SqlCommand(query, conn);
// SqlInjection 해킹 막기 위해서 사용
SqlParameter pUserID = new SqlParameter("@userId", SqlDbType.VarChar, 20);
pUserID.Value = TxtUserId.Text;
cmd.Parameters.Add(pUserID);
SqlParameter pPasswords = new SqlParameter("@passwords", SqlDbType.VarChar, 20);
pPasswords.Value = TxtPassword.Text;
cmd.Parameters.Add(pPasswords);
// SqlDataReader 실행(1)
SqlDataReader reader = cmd.ExecuteReader();
// reader로 처리
reader.Read();
strUserId = reader["userID"] != null ? reader["userID"].ToString() : "";
reader.Close();
// 값이 넘어오는지 중간 확인
//MessageBox.Show(strUserId);
if (string.IsNullOrEmpty(strUserId))
{
MetroMessageBox.Show(this, "접속실패", "로그인실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var updateQuery = $@"UPDATE membertbl SET
lastloginDt = GETDATE()
, loginIpAddr = '{Helper.Common.GetLocalIp()}'
WHERE userId = '{strUserId}' ";
cmd.CommandText = updateQuery;
cmd.ExecuteNonQuery();
MetroMessageBox.Show(this, "접속성공", "로그인성공", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, $"Error : {ex.Message}", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private async void BtnPreview_Click(object sender, EventArgs e)
{
if (CheckUtility.SearchConditionCheck(this, lblDestinationMailAddress.Text, txtDestinationMailAddress.Text, false, Utility.DataType.EMAIL, 255, 0))
{
frmRegisterCompleteNotificationController oController = new frmRegisterCompleteNotificationController();
try
{
DataTable result = oController.PreviewFunction(txtCompanyName.Text, txtCompanyNoBox.Text, REQ_SEQ, txtEDIAccount.Text);
string return_message = "";
try
{
return_message = result.Rows[0]["Message"].ToString();
}
catch (Exception)
{
}
string FILENAME = "";
if (string.IsNullOrEmpty(return_message))
{
FILENAME = result.Rows[0]["FILENAME"].ToString();
MetroMessageBox.Show(this, "\n" + JimugoMessages.I000WB001, "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n" + return_message, "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DataTable dt = DTParameter(txtCompanyNoBox.Text, REQ_SEQ, QUOTATION_DATE, ORDER_DATE, COMPLETION_NOTIFICATION_DATE, COMPANY_NAME, txtDestinationMailAddress.Text, txtEDIAccount.Text, FILENAME);
#region CallPreviewScreen
string temp_deirectory = System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + @"/Temp";
if (!Directory.Exists(temp_deirectory))
{
Directory.CreateDirectory(temp_deirectory);
}
//delete temp files
Utility.DeleteFiles(temp_deirectory);
string destinationpath = temp_deirectory + "/" + FILENAME;
btnPreview.Enabled = false;
bool success = await Core.WebUtility.Download(Properties.Settings.Default.GetTempFile + "?FILENAME=" + FILENAME, destinationpath);
if (success)
{
frmRegisterCompleteNotificationPreview frm = new frmRegisterCompleteNotificationPreview(dt);
frm.ShowDialog();
this.Show();
UPDATED_AT = frm.UPDATED_AT;
UPDATED_AT_RAW = frm.UPDATED_AT_RAW;
COMPLETION_NOTIFICATION_DATE = txtRegisterCompleteNotificationDate.Text.Trim();
Dialog = DialogResult.OK;
this.BringToFront();
}
btnPreview.Enabled = true;
#endregion
}
catch (Exception ex)
{
Utility.WriteErrorLog(ex.Message, ex, false);
}
}
}
private void SaveProcess()
{
if (string.IsNullOrEmpty(mode))
{
MetroMessageBox.Show(this, "신규버튼을 누르고 데이터를 저장하십시오", "경고",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
using (SqlConnection conn = new SqlConnection(Commons.CONNSTRING))
{ // using 괄호가 없어서 오류
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string strQuery = "";
if (mode == "UPDATE")
{
strQuery = " UPDATE dbo.bookstbl SET Author = @Author, Division = @Division, Names = @Names, ReleaseDate = @ReleaseDate, ISBN = @ISBN, Price = @Price "
+ " WHERE Idx = @Idx ";
}
else if (mode == "INSERT")
{
strQuery = " INSERT INTO dbo.bookstbl(Author, Division, Names, ReleaseDate, ISBN, Price) "
+ " VALUES(@Author, @Division, @Names, @ReleaseDate, @ISBN, @Price) ";
}
cmd.CommandText = strQuery;
SqlParameter parmAuthor = new SqlParameter("@Author", SqlDbType.VarChar, 45);
parmAuthor.Value = TxtAuthor.Text;
cmd.Parameters.Add(parmAuthor);
SqlParameter parmDivision = new SqlParameter("@Division", SqlDbType.Char, 4);
parmDivision.Value = CboDivision.SelectedValue;
cmd.Parameters.Add(parmDivision);
SqlParameter parmNames = new SqlParameter("@Names", SqlDbType.VarChar, 100);
parmNames.Value = TxtNames.Text;
cmd.Parameters.Add(parmNames);
SqlParameter parmReleaseDate = new SqlParameter("@ReleaseDate", SqlDbType.Date);
parmReleaseDate.Value = DtpReleaseDate.Value;
cmd.Parameters.Add(parmReleaseDate);
SqlParameter parmISBN = new SqlParameter("@ISBN", SqlDbType.VarChar, 200);
parmISBN.Value = TxtISBN.Text;
cmd.Parameters.Add(parmISBN);
SqlParameter parmPrice = new SqlParameter("@Price", SqlDbType.Decimal, 10);
parmPrice.Value = TxtPrice.Text;
cmd.Parameters.Add(parmPrice);
if (mode == "UPDATE")
{
SqlParameter parmIdx = new SqlParameter("@Idx", SqlDbType.Int);
parmIdx.Value = TxtIdx.Text;
cmd.Parameters.Add(parmIdx);
}
cmd.ExecuteNonQuery();
}
}
//입력(수정)처리 프로세스
private void SaveData()
{
try
{
using (SqlConnection conn = new SqlConnection(BookRentalShopApp.Helper.Common.ConnString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
var query = "";
if (isNew == true) //insert
{
query = @"INSERT INTO [dbo].[rentaltbl]
([memberIdx]
,[bookIdx]
,[rentalDate]
,[rentalState])
VALUES
(@memberIdx
,@bookIdx
,@rentalDate
,@rentalState)";
}
else //update
{
query = @"UPDATE [dbo].[rentaltbl]
SET [returnDate] = case @rentalState
when 'T' then GETDATE()
When 'R' then null end
,[rentalState] = @rentalState
WHERE Idx = @Idx";
}
cmd.CommandText = query;
if (isNew == true) // 신규
{
var pMemberIdx = new SqlParameter("@memberIdx", SqlDbType.Int);
pMemberIdx.Value = selMemberIdx;
cmd.Parameters.Add(pMemberIdx);
var pBookIdx = new SqlParameter("@bookIdx", SqlDbType.Int);
pBookIdx.Value = selBookIdx;
cmd.Parameters.Add(pBookIdx);
var pRentalDate = new SqlParameter("@rentalDate", SqlDbType.Date);
pRentalDate.Value = DtpRentaldate.Value;
cmd.Parameters.Add(pRentalDate);
var pRentalState = new SqlParameter("@rentalState", SqlDbType.Char, 1);
pRentalState.Value = CboRentalState.SelectedValue;
cmd.Parameters.Add(pRentalState);
}
else // 업데이트일땐
{
var pRentalState = new SqlParameter("@rentalState", SqlDbType.Char, 1);
pRentalState.Value = CboRentalState.SelectedValue;
cmd.Parameters.Add(pRentalState);
var pIdx = new SqlParameter("@Idx", SqlDbType.Int);
pIdx.Value = TxtIdx.Text;
cmd.Parameters.Add(pIdx);
}
var result = cmd.ExecuteNonQuery();
if (result == 1)
{
MetroMessageBox.Show(this, "저장 성공", "저장",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "저장 실패", "저장",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, $"예외발생 : {ex.Message}", "오류",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SaveData()
{
try
{
using (SqlConnection conn = new SqlConnection(Helper.Common.ConnString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
var query = "";
if (isNew == true) // INSERT
{
query = @"INSERT INTO [dbo].[membertbl]
([Names]
,[Levels]
,[Addr]
,[Mobile]
,[Email]
,[userID]
,[passwords])
VALUES
(@Names
,@Levels
,@Addr
,@Mobile
,@Email
,@userID
,@passwords) ";
}
else // UPDATE
{
query = @"UPDATE [dbo].[membertbl]
SET [Names] = @Names
,[Levels] = @Levels
,[Addr] = @Addr
,[Mobile] = @Mobile
,[Email] = @Email
,[userID] = @userID
,[passwords] = @passwords
WHERE Idx = @Idx ";
}
cmd.CommandText = query;
SqlParameter pNames = new SqlParameter("@Names", SqlDbType.NVarChar, 50);
pNames.Value = TxtNames.Text;
cmd.Parameters.Add(pNames);
SqlParameter pLevels = new SqlParameter("@Levels", SqlDbType.Char, 1);
pLevels.Value = CboLevels.SelectedItem.ToString();
cmd.Parameters.Add(pLevels);
SqlParameter pAddr = new SqlParameter("@Addr", SqlDbType.NVarChar, 100);
pAddr.Value = TxtAddr.Text;
cmd.Parameters.Add(pAddr);
SqlParameter pMobile = new SqlParameter("@Mobile", SqlDbType.VarChar, 13);
pMobile.Value = TxtMobile.Text;
cmd.Parameters.Add(pMobile);
SqlParameter pEmail = new SqlParameter("@Email", SqlDbType.VarChar, 50);
pEmail.Value = TxtEmail.Text;
cmd.Parameters.Add(pEmail);
SqlParameter puserID = new SqlParameter("@userID", SqlDbType.VarChar, 20);
puserID.Value = TxtUserId.Text;
cmd.Parameters.Add(puserID);
SqlParameter ppasswords = new SqlParameter("@passwords", SqlDbType.VarChar, 100);
ppasswords.Value = TxtPasswords.Text;
cmd.Parameters.Add(ppasswords);
if (isNew == false)
{
SqlParameter pIdx = new SqlParameter("@Idx", SqlDbType.Int);
pIdx.Value = TxtIdx.Text;
cmd.Parameters.Add(pIdx);
}
var result = cmd.ExecuteNonQuery();
if (result == 1)
{
MetroMessageBox.Show(this, "저장 성공", "저장",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "저장 실패", "저장",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, $"예외발생 : {ex.Message}", "오류", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void btnInjectImage_Click(object sender, RoutedEventArgs e)
{
try
{
_blf = new PureBLF(_blfLocation);
var ofd = new OpenFileDialog
{
Title = "Open an image to be injected",
Filter = "JPEG Image (*.jpg,*.jpeg,)|*.jpg;*.jpeg|PNG Image [H3/ODST]|*.png|BMP Image [H3/ODST]|*.bmp"
};
if (!((bool)ofd.ShowDialog()))
{
Close();
return;
}
byte[] newImage = File.ReadAllBytes(ofd.FileName);
var stream = new EndianStream(new MemoryStream(newImage), Endian.BigEndian);
// Check if it's a supported image
stream.SeekTo(0x0);
ushort imageMagic = stream.ReadUInt16();
if (imageMagic != 0xFFD8 && imageMagic != 0x8950 && imageMagic != 0x424D)
{
throw new Exception("Invalid image type. Only JPEG, PNG, and BMP are supported.");
}
// Check for size and dimension differences
var imageSize = new FileInfo(ofd.FileName).Length;
var image = new BitmapImage();
image.BeginInit();
image.StreamSource = new MemoryStream(newImage);
image.EndInit();
string sizeMessage = "";
string dimensionMessage = "";
if (new FileInfo(ofd.FileName).Length >= 0x1C000)
{
sizeMessage = String.Format("- The size of the new image (0x{0}) exceeds Halo 3/ODST's modified limit of 0x1C000. This image will not display in those games as a result. Can be ignored otherwise.\n",
imageSize.ToString("X"));
}
if (image.PixelWidth != ((BitmapImage)imgBLF.Source).PixelWidth ||
image.PixelHeight != ((BitmapImage)imgBLF.Source).PixelHeight)
{
dimensionMessage = String.Format("- The dimensions of the new image ({0}x{1}) are not the same as the dimensions of the original image ({2}x{3}). This blf may appear stretched or not appear at all as a result.\n",
image.PixelWidth, image.PixelHeight, ((BitmapImage)imgBLF.Source).PixelWidth, ((BitmapImage)imgBLF.Source).PixelHeight);
}
if (dimensionMessage != "" || sizeMessage != "")
{
if (MetroMessageBox.Show("Warning",
"There were some potential issue(s) found with your new image;\n\n" + String.Format("{0}{1}",
sizeMessage, dimensionMessage) + "\nInject anyway?",
MetroMessageBox.MessageBoxButtons.OkCancel) != MetroMessageBox.MessageBoxResult.OK)
{
Close();
return;
}
}
// It's the right everything! Let's inject
var newImageChunkData = new List <byte>();
newImageChunkData.AddRange(new byte[] { 0x00, 0x00, 0x00, 0x00 });
byte[] imageLength = BitConverter.GetBytes(newImage.Length);
Array.Reverse(imageLength);
newImageChunkData.AddRange(imageLength);
newImageChunkData.AddRange(newImage);
// Write data to chunk file
_blf.BLFChunks[1].ChunkData = newImageChunkData.ToArray <byte>();
_blf.RefreshRelativeChunkData();
_blf.UpdateChunkTable();
// Update eof offset value
var eofstream = new EndianStream(new MemoryStream(_blf.BLFChunks[2].ChunkData), Endian.BigEndian);
uint eofFixup = (uint)_blf.BLFStream.Length - 0x111; //real cheap but hey it works and is always the same in all games
eofstream.SeekTo(0);
eofstream.WriteUInt32(eofFixup);
_blf.RefreshRelativeChunkData();
_blf.UpdateChunkTable();
Close();
MetroMessageBox.Show("Injected!", "The BLF Image has been injected. This image tab will now close.");
App.AssemblyStorage.AssemblySettings.HomeWindow.ExternalTabClose(_tab);
}
catch (Exception ex)
{
Close();
MetroMessageBox.Show("Inject Failed!", "The BLF Image failed to be injected: \n " + ex.Message);
}
}
private void metroButton12_Click(object sender, EventArgs e)
{
MetroMessageBox.Show(this, "This is a sample `default` MetroMessagebox ", "MetroMessagebox");
}
private void loadBLF()
{
try
{
_blf = new PureBLF(_blfLocation);
var imgChunkData = new List <byte>(_blf.BLFChunks[1].ChunkData);
imgChunkData.RemoveRange(0, 0x08);
Dispatcher.Invoke(new Action(delegate
{
var image = new BitmapImage();
image.BeginInit();
image.StreamSource = new MemoryStream(imgChunkData.ToArray());
image.EndInit();
imgBLF.Source = image;
var stream = new EndianStream(new MemoryStream(imgChunkData.ToArray <byte>()), Endian.BigEndian);
stream.SeekTo(0x0);
ushort imageMagic = stream.ReadUInt16();
switch (imageMagic)
{
case 0xFFD8:
blfImageFormat = "JPEG";
break;
case 0x8950:
blfImageFormat = "PNG";
break;
case 0x424D:
blfImageFormat = "BMP";
break;
default:
blfImageFormat = "Unknown";
break;
}
// Add Image Info
paneImageInfo.Children.Insert(0, new MapHeaderEntry("Image Format:", blfImageFormat));
paneImageInfo.Children.Insert(1, new MapHeaderEntry("Image Width:", image.PixelWidth + "px"));
paneImageInfo.Children.Insert(2, new MapHeaderEntry("Image Height", image.PixelHeight + "px"));
// Add BLF Info
paneBLFInfo.Children.Insert(0, new MapHeaderEntry("BLF Length:", "0x" + _blf.BLFStream.Length.ToString("X")));
paneBLFInfo.Children.Insert(1,
new MapHeaderEntry("BLF Chunks:", _blf.BLFChunks.Count.ToString(CultureInfo.InvariantCulture)));
if (App.AssemblyStorage.AssemblySettings.StartpageHideOnLaunch)
{
App.AssemblyStorage.AssemblySettings.HomeWindow.ExternalTabClose(Home.TabGenre.StartPage);
}
RecentFiles.AddNewEntry(new FileInfo(_blfLocation).Name, _blfLocation, "BLF Image", Settings.RecentFileType.Blf);
Close();
}));
}
catch (Exception ex)
{
Close();
Dispatcher.Invoke(new Action(delegate
{
MetroMessageBox.Show("Unable to open BLF", ex.Message.ToString(CultureInfo.InvariantCulture));
App.AssemblyStorage.AssemblySettings.HomeWindow.ExternalTabClose((LayoutDocument)Parent);
}));
}
}
private void DatosMetroGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 1)
{
DataGridViewRow r = DatosMetroGrid.SelectedRows[0];
Marca marca = (Marca)r.Tag;
DialogResult dr = MetroMessageBox.Show(this, $"¿Desea dar de baja a la marca {marca.Nombre}?",
"Confirmar Baja",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
try
{
servicio.Borrar(marca.MarcaId);
DatosMetroGrid.Rows.Remove(r);
MetroMessageBox.Show(this, "Registro borrado", "Mensaje",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exception)
{
MetroMessageBox.Show(this, exception.Message, "Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
if (e.ColumnIndex == 2)
{
DataGridViewRow r = DatosMetroGrid.SelectedRows[0];
MarcaDto marcaDto = (MarcaDto)r.Tag;
//MarcaDto marcaAux =(Marca) marca.Clone();
MarcasAEForm frm = new MarcasAEForm();
frm.Text = "Editar Marca";
frm.SetMarca(marcaDto);
DialogResult dr = frm.ShowDialog(this);
if (dr == DialogResult.OK)
{
try
{
marcaDto = frm.GetMarca();
if (!servicio.Existe(marcaDto))
{
servicio.Editar(marcaDto);
SetearFila(r, marcaDto);
MetroMessageBox.Show(this, "Registro Editado", "Mensaje",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "Marca repetida", "Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
//SetearFila(r,marcaAux);
LoadRegistros();
}
}
catch (Exception exception)
{
MetroMessageBox.Show(this, exception.Message, "Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
}
private void retrieveDotaDir()
{
// start process of retrieving dota dir
dotaDir = Settings.Default.DotaDir;
if (Settings.Default.DotaDir == "")
{
// this is first run of application
// try to auto-get the dir
dotaDir = Util.getDotaDir();
DialogResult dr = DialogResult.No;
if (dotaDir != "")
{
// first run of modkit on this computer.
dr = MetroMessageBox.Show(this,
"Dota directory has been set to: " + dotaDir + ". Is this correct?",
"Dota Directory",
MessageBoxButtons.YesNo,
MessageBoxIcon.Information);
}
if (dr == DialogResult.No)
{
FolderBrowserDialog fbd = new FolderBrowserDialog();
fbd.Description = "Dota 2 directory (i.e. 'dota 2 beta')";
var dr2 = fbd.ShowDialog();
if (dr2 != DialogResult.OK)
{
MetroMessageBox.Show(this, "No folder selected. Exiting.",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
Environment.Exit(0);
}
string p = fbd.SelectedPath;
dotaDir = p;
}
}
// ModKit must ran in the same drive as the dota dir.
if (!Util.hasSameDrives(Environment.CurrentDirectory, dotaDir))
{
MetroMessageBox.Show(this, "Dota 2 ModKit must be ran from the same drive as Dota 2 or else errors " +
"will occur. Please move Dota 2 ModKit to the '" + dotaDir[0] + "' Drive and create a shortcut to it. Exiting.",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
Environment.Exit(0);
}
// trying to read vpk practice. this works currently
/*
* string s2vpkPath = Path.Combine(dotaDir, "game", "dota_imported", "pak01_dir.vpk");
* using (var vpk = new VpkFile(s2vpkPath)) {
* vpk.Open();
* Debug.WriteLine("Got VPK version {0}", vpk.Version);
* VpkNode node = vpk.GetFile("scripts/npc/npc_units.txt");
* using (var inputStream = VPKUtil.GetInputStream(s2vpkPath, node)) {
* var pathPieces = node.FilePath.Split('/');
* var directory = pathPieces.Take(pathPieces.Count() - 1);
* var fileName = pathPieces.Last();
*
* //EnsureDirectoryExists(Path.Combine(directory.ToArray()));
*
* using (var fsout = File.OpenWrite(Path.Combine(Environment.CurrentDirectory, "something.txt"))) {
* var buffer = new byte[1024];
* int amtToRead = (int)node.EntryLength;
* int read;
*
* while ((read = inputStream.Read(buffer, 0, buffer.Length)) > 0 && amtToRead > 0) {
* fsout.Write(buffer, 0, Math.Min(amtToRead, read));
* amtToRead -= read;
* }
* }
* }
* }*/
}
private void metroButton1_Click(object sender, EventArgs e)
{
String s = metroComboBox1.SelectedItem.ToString();
MySqlConnection con1 = new MySqlConnection("SERVER=localhost;DATABASE=sales;UID=root;PASSWORD=smhs;");
String q1 = "Select * from invent where id='" + s + "';";
MySqlCommand cmd1 = new MySqlCommand(q1, con1);
MySqlDataReader dataReader1;
con1.Open();
dataReader1 = cmd1.ExecuteReader();
if (dataReader1.Read())
{
String re = metroLabel2.Text.ToString();
if (re == "edit")
{
EditStock e1 = new EditStock();
e1.metroLabel13.Text = s;
e1.Visible = true;
Close();
}
else if (re == "Search")
{
Transaction t = new Transaction();
t.Text = "PAYMENT HISTORY";
t.Show();
t.metroButton1.PerformClick();
t.metroComboBox1.SelectedItem = "Unique ID";
t.metroTextBox1.Text = s;
t.metroButton3.PerformClick();
//t.metroButton2.PerformClick();
//this.Dispose();
Application.OpenForms["Mbox_Search"].Dispose();
Application.OpenForms["Home"].BringToFront();
Application.OpenForms["Transaction"].BringToFront();
}
else if (re == "delete")
{
DialogResult d = new DialogResult();
d = MetroMessageBox.Show(this, "\n\nAre Your Sure you want to delete this Entry?\nEntry Once deleted cant be recovered Back..", "WARNING", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (d == DialogResult.OK)
{
MySqlConnection con = new MySqlConnection("SERVER=localhost;DATABASE=Sales;UID=root;PASSWORD=smhs;");
con.Open();
MySqlCommand cmd = new MySqlCommand("Select id, status, bid, netamt from invent,sell where id='" + s + "' and id=sell.specs;", con);
MySqlDataReader dr1 = cmd.ExecuteReader();
double amt = 0;
int bid = 0;
String stat = "";
while (dr1.Read())
{
stat = dr1.GetValue(1).ToString();
amt = Convert.ToDouble(dr1.GetValue(3));
bid = Convert.ToInt32(dr1.GetValue(2));
}
dr1.Close();
double sum = 0;
cmd.CommandText = "Select Sum(amt) from history where pid='" + s + "';";
dr1 = cmd.ExecuteReader();
while (dr1.Read())
{
String s1 = Convert.ToString(dr1.GetValue(0));
if (s1.Length > 0)
{
sum = sum + Convert.ToDouble(s1);
}
}
dr1.Close();
cmd.CommandText = "DELETE from history where pid='" + s + "';";
cmd.ExecuteNonQuery();
cmd.CommandText = "UPDATE buyer set Total=Total-" + amt + ", Deposited=Deposited-" + sum + " where Buyid=" + bid + ";";
cmd.ExecuteNonQuery();
cmd.CommandText = "UPDATE Seller set Total=Total-" + amt + ", Deposited=Deposited-" + sum + " where Selid=10001;";
cmd.ExecuteNonQuery();
cmd.CommandText = "DELETE from sell where specs='" + s + "';";
int result = cmd.ExecuteNonQuery();
cmd.CommandText = "DELETE from invent where id='" + s + "';";
result = cmd.ExecuteNonQuery();
if (result > 0)
{
MetroMessageBox.Show(this, "\n\nEntry Deleted Successfully", "SUCCESS", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
}
else if (re == "balance")
{
}
}
else
{
DialogResult d = new DialogResult();
d = MetroMessageBox.Show(this, "STOCK NOT FOUND!! Please Re-Enter a Valid Stock-Code to proceed Further..", "INVALID STOCK CODE", MessageBoxButtons.RetryCancel, MessageBoxIcon.Exclamation);
if (d.ToString() == "Retry")
{
Application.OpenForms["Home"].BringToFront();
Application.OpenForms["Mbox_Search"].BringToFront();
//metroTextBox1.Select();
}
else
{
Close();
Application.OpenForms["Home"].BringToFront();
}
}
}
public MainForm()
{
// bring up the UI
InitializeComponent();
Localizer localizer = new Localizer(this);
localizer.localize();
//Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("cn-CN");
Console.WriteLine(strings.Hello);
setupMainFormHooks();
// check for updates
updater = new Updater(this);
updater.checkForUpdates();
// init mainform controls stuff
initControls();
// get the dota dir
retrieveDotaDir();
// *** at this point assume valid dota dir. ***
// save the dota dir
Settings.Default.DotaDir = dotaDir;
Debug.WriteLine("Directory: " + dotaDir);
// get the master 'game' and 'content' paths.
gamePath = Path.Combine(dotaDir, "game", "dota_addons");
contentPath = Path.Combine(dotaDir, "content", "dota_addons");
// create these dirs if they don't exist.
if (!Directory.Exists(gamePath))
{
Directory.CreateDirectory(gamePath);
}
if (!Directory.Exists(contentPath))
{
Directory.CreateDirectory(contentPath);
}
// get all the addons in the 'game' dir.
addons = getAddons();
// does this computer have any dota addons?
if (addons.Count == 0)
{
MetroMessageBox.Show(this, strings.NoDota2AddonsDetectedMsg,
strings.NoDota2AddonsDetectedCaption,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
Environment.Exit(0);
}
// setup custom tiles
setupCustomTiles();
// some functions in the Tick try and use mainform's controls on another thread. so we need to allot a very small amount of time for
// mainform to init its controls. this is mainly for the very first run of modkit.
Timer initTimer = new Timer();
initTimer.Interval = 100;
initTimer.Tick += (s, e) => {
// run it once
Timer t = (Timer)s;
t.Stop();
// clone a barebones repo if we don't have one, pull if we do
updater.clonePullBarebones();
// deserialize settings
deserializeSettings();
// auto-retrieve the workshop IDs for published addons if there are any.
getWorkshopIDs();
// set currAddon to the addon that was last opened in last run of modkit.
if (Settings.Default.LastAddon != "")
{
Addon a = getAddonFromName(Settings.Default.LastAddon);
if (a != null)
{
changeCurrAddon(a);
}
}
// basically, if this is first run of modkit, set the currAddon to w/e the default addon is in the workshop tools.
if (currAddon == null)
{
changeCurrAddon(addons[getDefaultAddonName()]);
}
// init our features of Modkit
initFeatures();
};
initTimer.Start();
}
private void metroButton10_Click(object sender, EventArgs e)
{
MetroMessageBox.Show(this, "This is a sample MetroMessagebox `OK` and `Cancel` button", "MetroMessagebox", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
private void SaveProcess()
{
if (String.IsNullOrEmpty(mode))
{
MetroMessageBox.Show(this, "신규버튼을 누르고 데이터를 저장하십시오.", "경고",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//DB저장프로세스
using (SqlConnection conn = new SqlConnection(Commons.CONNSTRING))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string strQuery = "";
if (mode == "UPDATE")
{
strQuery = "UPDATE dbo.membertbl " +
" SET Names = @Names, " +
" Levels = @Levels, " +
" Addr = @Addr, " +
" Mobile = @Mobile, " +
" Email = @Email " +
" WHERE Idx = @Idx ";
}
else if (mode == "INSERT")
{
//throw new NotImplementedException(); // 아직 구현 안 됬을 때 에러 발생
strQuery = "INSERT INTO dbo.membertbl (Names, Levels, Addr, Mobile, Email) " +
" VALUES (@Names, @Levels, @Addr, @Mobile, @Email) ";
}
cmd.CommandText = strQuery;
if (mode == "Update")
{
// TxtIdx 설정
SqlParameter pramIdx = new SqlParameter("@Idx", System.Data.SqlDbType.Int);//Idx 속성 글자타입을 Int, 길이를 Null이 아님으로 지정했음
pramIdx.Value = TxtIdx.Text;
cmd.Parameters.Add(pramIdx);
}
// TxtNames 설정
SqlParameter pramNames = new SqlParameter("@Names", System.Data.SqlDbType.NVarChar, 45); //Names 속성 글자타입을 NVarChar, 길이를 45로 지정했음
pramNames.Value = TxtNames.Text;
cmd.Parameters.Add(pramNames);
//CboLevels 설정
SqlParameter parmLevels = new SqlParameter("@Levels", System.Data.SqlDbType.Char, 1); //Levels 속성 글자타입을 Char, 길이를 1로 지정했음
parmLevels.Value = CboLevels.SelectedItem;
cmd.Parameters.Add(parmLevels);
// TxtAddr 설정
SqlParameter pramAddr = new SqlParameter("@Addr", System.Data.SqlDbType.VarChar, 100); //Address 속성 글자타입을 VarChar, 길이를 100로 지정했음
pramAddr.Value = TxtAddr.Text;
cmd.Parameters.Add(pramAddr);
// TxtMobile 설정
SqlParameter pramMobile = new SqlParameter("@Mobile", System.Data.SqlDbType.VarChar, 13); //Mobile 속성 글자타입을 VarChar, 길이를 13로 지정했음
pramMobile.Value = TxtMobile.Text;
cmd.Parameters.Add(pramMobile);
// TxtEmail 설정
SqlParameter pramEmail = new SqlParameter("@Email", System.Data.SqlDbType.VarChar, 50); //Email 속성 글자타입을 VarChar, 길이를 50로 지정했음
pramEmail.Value = TxtEmail.Text;
cmd.Parameters.Add(pramEmail);
cmd.ExecuteNonQuery(); //쿼리문을 실행 시켜주기 위해서, NonQuery를 사용하는것은 값을 돌려받지 않기 위해서
}
}
private void metroButton11_Click(object sender, EventArgs e)
{
MetroMessageBox.Show(this, "This is a sample MetroMessagebox `Retry` and `Cancel` button. With warning style.", "MetroMessagebox", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
}
private void metroButton1_Click(object sender, EventArgs e)
{
string date1 = metroTextBox1.Text;
String dau = date1.Replace('-', '/');
DateTime dvs = Convert.ToDateTime(dau);
double result1 = 0;
String tx = metroTextBox2.PromptText;
int leo = tx.IndexOf(".");
double prnum = Convert.ToDouble(tx.Substring(leo + 1));
if (metroTextBox2.Text.ToString().Length > 0 && Double.TryParse(metroTextBox2.Text.ToString(), out result1) && Convert.ToDouble(metroTextBox2.Text) <= prnum)
{
double re = Convert.ToDouble(metroTextBox2.Text.ToString());
MySqlConnection con = new MySqlConnection("SERVER=localhost;DATABASE=Sales;UID=root;PASSWORD=smhs;");
con.Open();
MySqlCommand cmd = new MySqlCommand("Select bid from sell where specs='" + metroComboBox1.SelectedItem.ToString() + "';", con);
MySqlDataReader dataReader1;
dataReader1 = cmd.ExecuteReader();
int bid = 0;
while (dataReader1.Read())
{
bid = Convert.ToInt32(dataReader1.GetValue(0));
}
dataReader1.Close();
cmd.CommandText = "update Buyer set Deposited=Deposited+" + re + " where Buyid=" + bid + ";";
int result = 0;
result = cmd.ExecuteNonQuery();
cmd.CommandText = "update Seller set Deposited=Deposited+" + re + " where Selid=10001;";
result = cmd.ExecuteNonQuery();
if (result > 0)
{
MySqlConnection con1 = new MySqlConnection("SERVER=localhost;DATABASE=Sales;UID=root;PASSWORD=smhs;");
String q1 = "Insert into History(pid,dater,amt,bid) values(@a,@b,@c,@d);";
MySqlCommand cmd1 = new MySqlCommand(q1, con1);
cmd1.Parameters.AddWithValue("@a", metroComboBox1.SelectedItem.ToString().Trim());
cmd1.Parameters.AddWithValue("@b", dvs);
cmd1.Parameters.AddWithValue("@c", re);
cmd1.Parameters.AddWithValue("@d", bid);
con1.Open();
cmd1.ExecuteNonQuery();
cmd1.CommandText = "update sell set date_clear=@davs where specs='" + metroComboBox1.SelectedItem.ToString() + "' and netAmt=(Select Sum(amt) from history where pid='" + metroComboBox1.SelectedItem.ToString() + "' group by pid);";
cmd1.Parameters.AddWithValue("@davs", dvs);
cmd1.ExecuteNonQuery();
MetroMessageBox.Show(this, ("\n\nData Updated successfully!"), "SUCCESS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n\nPlease Check All the Details and Try Again.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
Close();
Application.OpenForms["Home"].BringToFront();
}
else
{
MetroMessageBox.Show(this, "\n\nPlease Insert Proper info First to Proceed Further..", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.OpenForms["Home"].BringToFront();
Application.OpenForms["Cash_Depo"].BringToFront();
metroTextBox2.Text = "";
metroTextBox2.Select();
}
}
