static void runApp() { try { Application.Run(new Login()); } catch (ArgumentOutOfRangeException e) { if (e.Message.Contains("'1401'")) { PopUp popup; popup = new PopUp("خطای تاریخ ورودی", "تاریخ غیرمجاز: این نسخه از نرم افزار از تاریخ ورودی پشتیبانی نمی کند", "تایید", "", "", "error"); popup.ShowDialog(); runApp(); } } }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); //Application.Run(new Waiting()); //Application.Run(new Form1()); try { runApp(); } catch (ArgumentOutOfRangeException e) { if (e.Message.Contains("'1401'")) { PopUp popup; popup = new PopUp("خطای تاریخ ورودی", "تاریخ غیرمجاز: این نسخه از نرم افزار از تاریخ ورودی پشتیبانی نمی کند", "تایید", "", "", "error"); popup.ShowDialog(); runApp(); } } }
private void reportFastPrintBtn_Click(object sender, EventArgs e) { try { if (reportTitleTxtbx.Text == "") { PopUp p = new PopUp("ریپورت بدون عنوان", "عنوانی برای ریپورت وارد نکرده اید. ادامه می دهید؟", "بله", "خیر", "", "info"); p.ShowDialog(); if (p.DialogResult == DialogResult.Yes) { DataTable dt = new DataTable(); foreach (DataGridViewColumn col in reportDataGridView.Columns) { dt.Columns.Add(col.Name); } foreach (DataGridViewRow row in reportDataGridView.Rows) { DataRow dRow = dt.NewRow(); foreach (DataGridViewCell cell in row.Cells) { if (cell.ColumnIndex == 14) { string temp = string.Format("{0:n0}", double.Parse(cell.Value.ToString())); temp = temp.Replace(',', '/'); dRow[cell.ColumnIndex] = temp; } else { dRow[cell.ColumnIndex] = cell.Value; } } dt.Rows.Add(dRow); } //DataTable dt = (DataTable)(searchProposalShowDgv.DataSource); Report report = new Report(); report.Load("report1.frx"); report.SetParameterValue("r_title", reportTitleTxtbx.Text.ToString()); report.SetParameterValue("r_totalRecords", reportDataGridView.Rows.Count.ToString()); report.SetParameterValue("r_userInfo", user.U_LName); report.SetParameterValue("r_userTel", user.U_Tel); report.SetParameterValue("r_dateInfo", dbh.getDateHijri(DateTime.Now.ToString())); //TableDataSource table = report.GetDataSource("proposalTable") as TableDataSource; report.RegisterData(dt, "proposalTable"); report.GetDataSource("proposalTable").Enabled = true; report.Prepare(); report.Print(); } else { reportTitleTxtbx.Focus(); } } else { DataTable dt = new DataTable(); foreach (DataGridViewColumn col in reportDataGridView.Columns) { dt.Columns.Add(col.Name); } foreach (DataGridViewRow row in reportDataGridView.Rows) { DataRow dRow = dt.NewRow(); foreach (DataGridViewCell cell in row.Cells) { if (cell.ColumnIndex == 14) { string temp = string.Format("{0:n0}", double.Parse(cell.Value.ToString())); temp = temp.Replace(',', '/'); dRow[cell.ColumnIndex] = temp; } else { dRow[cell.ColumnIndex] = cell.Value; } } dt.Rows.Add(dRow); } //DataTable dt = (DataTable)(searchProposalShowDgv.DataSource); Report report = new Report(); report.Load("report1.frx"); report.SetParameterValue("r_title", reportTitleTxtbx.Text.ToString()); report.SetParameterValue("r_totalRecords", reportDataGridView.Rows.Count.ToString()); report.SetParameterValue("r_userInfo", user.U_LName); report.SetParameterValue("r_userTel", user.U_Tel); report.SetParameterValue("r_dateInfo", dbh.getDateHijri(DateTime.Now.ToString())); //TableDataSource table = report.GetDataSource("proposalTable") as TableDataSource; report.RegisterData(dt, "proposalTable"); report.GetDataSource("proposalTable").Enabled = true; report.Prepare(); report.Print(); } } catch (Exception ee) { if (user.U_NCode == 999999999) // to show exceptin for admin { MessageBox.Show(ee.Message); } string context = "خطای فایل نامه"; Alert alert = new Alert(context, "bluegray", 15); } }
private void loginEnterBtn_Click(object sender, EventArgs e) { try { /*SqlConnection conn2 = new SqlConnection(); * * SqlCommand sc2 = new SqlCommand(); * //conn2.ConnectionString = "Data Source= 185.159.152.2;" + * //"Initial Catalog=rayanpro_EBS;" + * //"User id=rayanpro_rayan; " + * //"Password=P@hn1395;"; * conn2.ConnectionString = "Data Source= 169.254.92.252;" + * "Initial Catalog=rayanpro_EBS;" + * "User id=test; " + * "Password=HoseinNima1234;"; * * sc2.Connection = conn2; * * conn2.Open();*/ try { if (loginUsernameTxtBx.Text == "" || loginPasswordTxtbx.Text == "") { string context = "نام کاربری یا رمز عبور وارد نشده است"; Alert alert = new Alert(context, "darkred", 5); } else if (loginUsernameTxtBx.Text == "999999999" && loginPasswordTxtbx.Text == "P@hn1395") { username = loginUsernameTxtBx.Text; password = loginPasswordTxtbx.Text; // REMEMBERING PASSWORD if (loginRememberUsername.Checked) { remembering[0] = "yes"; remembering[1] = username; File.WriteAllLines("loginInformation", remembering); } else { remembering[0] = "no"; remembering[1] = "-"; File.WriteAllLines("loginInformation", remembering); } // REMEMBERING PASSWORD ServerInfo server = new ServerInfo(); this.Hide(); server.Show(); } else { DataBaseHandler dbh = new DataBaseHandler(user); AppSetting setting = new AppSetting(); username = loginUsernameTxtBx.Text; password = dbh.hashPass(loginPasswordTxtbx.Text); SqlConnection conn = new SqlConnection(); //conn.ConnectionString = "Data Source= 185.159.152.2;" + //"Initial Catalog=rayanpro_EBS;" + //"User id=rayanpro_rayan; " + //"Password=P@hn1395;"; /* conn.ConnectionString = "Data Source= 169.254.92.252;" + * "Initial Catalog=rayanpro_EBS;" + * "User id=test; " + * "Password=HoseinNima1234;";*/ conn.ConnectionString = setting.getConnectionString("cn"); SqlCommand sc = new SqlCommand(); sc.CommandTimeout = 5; SqlDataReader reader; sc.CommandText = "SELECT * FROM UsersTable WHERE u_NCode = '" + long.Parse(username) + "' AND u_Password = '******'"; sc.CommandType = CommandType.Text; sc.Connection = conn; conn.Open(); reader = sc.ExecuteReader(); if (reader.HasRows) { // REMEMBERING PASSWORD if (loginRememberUsername.Checked) { remembering[0] = "yes"; remembering[1] = username; File.WriteAllLines("loginInformation", remembering); } else { remembering[0] = "no"; remembering[1] = "-"; File.WriteAllLines("loginInformation", remembering); } // REMEMBERING PASSWORD reader.Read(); user.U_FName = reader["u_FName"].ToString(); user.U_LName = reader["u_LName"].ToString(); user.U_NCode = long.Parse(reader["u_NCode"].ToString()); user.U_Password = reader["u_Password"].ToString(); user.U_Email = reader["u_Email"].ToString(); user.U_Tel = reader["u_Tel"].ToString(); if (reader["u_IsAdmin"].ToString() == "True") { user.U_IsAdmin = 1; } else { user.U_IsAdmin = 0; } if (reader["u_canAddProposal"].ToString() == "True") { user.CanAddProposal = 1; } else { user.CanAddProposal = 0; } if (reader["u_canEditProposal"].ToString() == "True") { user.CanEditProposal = 1; } else { user.CanEditProposal = 0; } if (reader["u_canDeleteProposal"].ToString() == "True") { user.CanDeleteProposal = 1; } else { user.CanDeleteProposal = 0; } if (reader["u_canAddUser"].ToString() == "True") { user.CanAddUser = 1; } else { user.CanAddUser = 0; } if (reader["u_canEditUser"].ToString() == "True") { user.CanEditUser = 1; } else { user.CanEditUser = 0; } if (reader["u_canDeleteUser"].ToString() == "True") { user.CanDeleteUser = 1; } else { user.CanDeleteUser = 0; } if (reader["u_canManageTeacher"].ToString() == "True") { user.CanManageTeacher = 1; } else { user.CanManageTeacher = 0; } if (reader["u_canManageType"].ToString() == "True") { user.CanManageType = 1; } else { user.CanManageType = 0; } if (Int16.Parse(reader["u_otherAccess"].ToString()) == 1) { user.U_otherAccess = 1; // Read Only User } else { user.U_otherAccess = 0; } user.U_Color = reader["u_Color"].ToString(); user.U_Faculty = reader["u_faculty"].ToString(); this.Hide(); Form1 mainForm = new Form1(user); mainForm.Show(); } else { //PopUp popUp = new PopUp("خطا", "نام کاربری یا رمز عبور اشتباه است.", "تایید", "", "", "error"); //popUp.ShowDialog(); string context = "نام کاربری یا رمز عبور اشتباه است"; Alert alert = new Alert(context, "darkred", 5); } conn.Close(); } } catch (SqlException) { PopUp popUp = new PopUp("خطا", "خطا در برقراری ارتباط با سرور", "تایید", "", "", "error"); popUp.ShowDialog(); } } catch { string context = "خطا در برقراری ارتباط با سرور"; Alert alert = new Alert(context, "darkred", 5); } }