private void frmHeatItem_Load(object sender, System.EventArgs e) { this.Text = "参数编辑"; con = new DBcon(); InitializeGridTable(); LoadDatas(); }
public void MakePayment() { try { using (SqlConnection conn = new SqlConnection(DBcon.Connect())) { conn.Open(); using (SqlCommand cmd = new SqlCommand("spLavBetaling", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@afsender", SelectedAccountNmb); cmd.Parameters.AddWithValue("@modtager", Receiver); cmd.Parameters.AddWithValue("@note", Note); cmd.Parameters.AddWithValue("@beloeb", Amount); int count = Convert.ToInt32(cmd.ExecuteNonQuery()); if (count == -1) { MessageBox.Show("Modtageren findes ikke!"); } else { MessageBox.Show("Jeg tror det lykkedes?"); } } } } catch (Exception) { throw; } }
// Finally the method for doing the DB stuff public ReturnType DoDatabaseStuff() { SqlConnection myCon = DBcon.getInstance().conn(); try { myCon.Open(); // ... do some DB stuff } catch (Exception ex) { // ... Some logging } finally { if (myCon.State == ConnectionState.Open) { myCon.Close(); } // ... any additional cleanup in here } return // ... some value; }
public string AddBloodStorage([FromBody] BloodStorage bloodStorage) { string response = DBcon.AddBloodStorage(conn, bloodStorage.ShelfLife, bloodStorage.BloodType, bloodStorage.RHFactor, bloodStorage.Shipped, "addBloodStorage"); return(response); }
public void GetTransactions() { using (SqlConnection conn = new SqlConnection(DBcon.Connect())) { using (SqlCommand cmd = new SqlCommand("spHentAlleTransaktionerAlleKonti", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@kundeID", DashboardViewModel.u.Id); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { Transactions.Add(new TransactionModel { TransactionID = Convert.ToInt32(dr[0]), AccountNmb = Convert.ToInt32(dr[1]), Note = dr[2].ToString(), Function = Convert.ToChar(dr[3]), Amount = Convert.ToDecimal(dr[4]), NewBalance = Convert.ToDecimal(dr[5]), Date = dr[6].ToString() }); } } } }
public int IsLogInValid(string id, string password) { this.sql = "select * from Login where userid ='" + id + "'and password ='******';"; this.Ds = DBcon.GetDataSet(sql); if (this.Ds.Tables[0].Rows.Count == 1) { if (IsAdminValid(id, password) == true) { return(1); } else if (IsEmployeeValid(id, password) == true) { return(2); } else { return(0); } } else { return(0); } }
private void EditLoad() { DateTime dt; try { con = new DBcon(); SqlCommand cmd = new SqlCommand("select * from v_PointData where id=@m_id", con.GetConnection()); cmd.Parameters.Add("@m_id", m_DataID); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { dt = System.Convert.ToDateTime(dr["DT"]); dtDate.Value = dt.Date; dtTime.Value = dt.Hour; // dtDate.Value=System.Convert.ToDateTime(dr["DT"]); cmbPoint.Text = dr["Name"].ToString(); txtDescription.Text = dr["Description"].ToString(); txtFlux.Text = dr["Flux"].ToString(); txtFluxAll1.Text = dr["FluxAll1"].ToString(); txtFluxAll2.Text = dr["FluxAll2"].ToString(); txtFulxInstant.Text = dr["FluxInstant"].ToString(); txtHeat.Text = dr["Heat"].ToString(); txtHeatAll.Text = dr["HeatAll"].ToString(); txtTemp1.Text = dr["Temp1"].ToString(); txtTemp2.Text = dr["Temp2"].ToString(); } dr.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void AddRecord() { try { con = new DBcon(); SqlCommand cmd = new SqlCommand("PointDataAdd", con.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@p_PointName", cmbPoint.Text.ToString().Trim()); cmd.Parameters.Add("@p_DT", m_DT); cmd.Parameters.Add("@p_Temp1", m_Temp1); cmd.Parameters.Add("@p_Temp2", m_Temp2); cmd.Parameters.Add("@p_Flux", m_Flux); cmd.Parameters.Add("@p_Heat", m_Heat); cmd.Parameters.Add("@p_HeatAll", m_HeatAll); cmd.Parameters.Add("@p_FluxAll1", m_FluxAll1); cmd.Parameters.Add("@p_FluxAll2", m_FluxAll2); cmd.Parameters.Add("@p_FluxInstant", m_FluxInstant); cmd.Parameters.Add("@p_Description", txtDescription.Text.Trim()); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void Delete() { if (NoRecordDataGrid()) { return; } int row = m_dataGrid.CurrentCell.RowNumber; int col = 1; string UserName = m_dataGrid[row, col].ToString().ToString().Trim(); if (UserName == null) { MessageBox.Show("请正确选择需要删除的数据行!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (MessageBox.Show("确定要删除该行数据?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) { return; } row = m_dataGrid.CurrentCell.RowNumber; col = 0; DBcon con = new DBcon(); int id = Convert.ToInt32(m_dataGrid[row, col].ToString()); SqlCommand sqlCmd = new SqlCommand("DELETE FROM tbWUser WHERE ID=" + id, con.GetConnection()); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); RefreshDataGrid(); }
public void GetAccounts() { using (SqlConnection conn = new SqlConnection(DBcon.Connect())) { using (SqlCommand cmd = new SqlCommand("spHentKonti", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@kundeID", DashboardViewModel.u.Id); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { Accounts.Add(new AccountModel( AccountNmb = dr[0].ToString(), AccountType = dr[1].ToString(), AccountName = dr[2].ToString(), Balance = Convert.ToDecimal(dr[3]))); } } } }
public static void setLoggedUser(this HttpContext context, User userAccount, bool saveCookie = false) { DBcon dbContext = context.RequestServices.GetService <DBcon>(); string oldToken = context.Request.GetCookieJson <string>(loggedUser); if (oldToken != null) { Token remove = dbContext.Tokens.FirstOrDefault(i => i.Value == oldToken); if (remove != null) { dbContext.Tokens.Remove(remove); dbContext.SaveChanges(); } } if (userAccount != null) { string token = Guid.NewGuid().ToString(); dbContext.Tokens.Add(new Token { Value = token, UserId = userAccount.Id, Created = DateTime.Now }); dbContext.SaveChanges(); context.Response.SetCookieJson(loggedUser, token); } }
public string AddPrizeTransaction([FromBody] PrizeTransaction prizeTransaction) { var worked = DBcon.InsertPrizeTransaction(conn, prizeTransaction.donorID, prizeTransaction.PID, "addPrizeTransaction"); return(worked switch { 0 => "Transaction invalid", -1 => "error in procedure", _ => "Transaction complete. Insertion was successful" });
public void Login() { using (SqlConnection conn = new SqlConnection(DBcon.Connect())) { conn.Open(); try { SqlCommand cmd = new SqlCommand("spLogin", conn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@email", Email); cmd.Parameters.AddWithValue("@kodeord", Psw); cmd.ExecuteNonQuery(); int count = Convert.ToInt32(cmd.ExecuteScalar()); if (count == 1) { using (SqlCommand cmd2 = new SqlCommand("spHentbrugerinfo", conn)) { cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@email", Email); cmd2.Parameters.AddWithValue("@kodeord", Psw); using (SqlDataReader reader = cmd2.ExecuteReader()) { if (reader.HasRows) { reader.Read(); ShellViewModel.u = new UserModel( reader.GetInt32(0), reader.GetString(1).ToString(), reader.GetString(2).ToString()); } } }; _events.PublishOnUIThread(new DashboardRequest()); } else { manager.ShowDialog(new LoginErrorViewModel()); Psw = ""; } } catch (Exception) { manager.ShowDialog(new LoginErrorViewModel()); Psw = ""; } } }
public bool IsEmployeeValid(string id, string password) { this.sql = "select * from Login where userid ='" + id + "'and password ='******'and usertype ='Employee';"; this.Ds = DBcon.GetDataSet(sql); if (this.Ds.Tables[0].Rows.Count == 1) { return(true); } else { return(false); } }
public void AdminProfile() { string sql = "Select * from login"; DataTable dt = new DataTable(); dt = DBcon.GetDataTable(sql); if (dt.Rows.Count > 0) { lblid.Content = dt.Rows[0]["userid"].ToString(); lblname.Content = dt.Rows[0]["name"].ToString(); } }
private void LoadStation() { string str = "select name from PointInfo"; con = new DBcon(); SqlCommand cmd = new SqlCommand(str, con.GetConnection()); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { cmbPoint.Items.Add(dr.GetValue(0).ToString().Trim()); } dr.Close(); }
/// <summary> /// /// </summary> private void UpdateRecord() { try { DBcon con = new DBcon(); SqlCommand cmd = new SqlCommand("UserUpdate", con.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@p_EditName", m_strEditUser); cmd.Parameters.Add("@p_Name", txtUserName.Text.Trim()); cmd.Parameters.Add("@p_Password", txtPwd.Text); cmd.Parameters.Add("@p_Description", txtDescription.Text.Trim()); SqlDataReader dr = cmd.ExecuteReader(); if (!dr.Read()) { dr.Close(); return; } string UserID = dr["ID"].ToString().Trim(); int intUserID = Convert.ToInt32(UserID); dr.Close(); cmd.Dispose(); //delete old funID cmd = new SqlCommand("DELETE FROM WUserFunction WHERE UserID=" + intUserID, con.GetConnection()); cmd.ExecuteNonQuery(); cmd.Dispose(); for (int i = 0; i < cklPurview.Items.Count; i++) { if (cklPurview.GetItemChecked(i)) { int intFunID = Convert.ToInt32(m_FunName2FunID[cklPurview.Items[i]].ToString()); //add userid -> codeID to UserFunction cmd = new SqlCommand("UserFunctionAdd", con.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@p_UserID", intUserID); cmd.Parameters.Add("@p_FunctionID", intFunID); cmd.ExecuteNonQuery(); cmd.Dispose(); } } } catch (Exception ex) { // 2007.05.30 // //MessageBox.Show("编辑用户失败!"); ExceptionHandler.Handle("编辑用户失败!", ex); } }
private void LoadStation() { dtDateDown.Value = dtDateUp.Value.AddDays(1); string str = "select Name from V_heatDatas Group by name"; DBcon con = new DBcon(); SqlCommand cmd = new SqlCommand(str, con.GetConnection()); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { cmbID.Items.Add(dr.GetValue(0).ToString().Trim()); } dr.Close(); m_PageCount = 1; cmbID.Items.Add("<全部站点>"); }
public static User GetLoggedUser(this HttpContext context) { DBcon dbContext = context.RequestServices.GetService <DBcon>(); string token = context.Request.GetCookieJson <string>(loggedUser); if (token == null) { return(null); } int value = dbContext.Tokens.Where(x => x.Value == token).Select(s => s.UserId).FirstOrDefault(); User user = dbContext.Users.Find(value); return(user); }
private void RefreshDataGrid() { try { if (!d_Type) { m_dataGrid.DataSource = ds.Tables[0].DefaultView; this.Width = 170 + 90 * (ds.Tables[0].Columns.Count - 1); } else { DataTable dt = CreatTable(); DBcon con = new DBcon(); int z = 0; string strName = "select name from v_HeatDatas group by name"; SqlDataAdapter daName = new SqlDataAdapter(strName, con.GetConnection()); DataSet dsName = new DataSet(); daName.Fill(dsName, "Name"); daName.Dispose(); for (int i = 0; i < dsName.Tables["Name"].Rows.Count; i++) { string str = "select top 1 name,team,time,oneBackTemp from v_HeatDatas where name='" + dsName.Tables["Name"].Rows[i]["name"].ToString() + "' order by time desc"; SqlDataAdapter da = new SqlDataAdapter(str, con.GetConnection()); DataSet dsOBT = new DataSet(); da.Fill(dsOBT, "table"); for (int j = 0; j < dsOBT.Tables["table"].Rows.Count; j++) { DataRow newrow = dt.NewRow(); dt.Rows.Add(newrow); dt.Rows[z]["name"] = dsOBT.Tables["table"].Rows[j]["name"].ToString(); dt.Rows[z]["team"] = dsOBT.Tables["table"].Rows[j]["team"].ToString(); dt.Rows[z]["time"] = System.Convert.ToDateTime(dsOBT.Tables["table"].Rows[j]["time"].ToString()); dt.Rows[z]["oneBackTemp"] = System.Convert.ToDecimal(dsOBT.Tables["table"].Rows[j]["oneBackTemp"].ToString()); z = z + 1; } } m_dataGrid.DataSource = dt; this.Width = 184 + 90 * (dt.Columns.Count - 1); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// /// </summary> private void ReadEditUserInfo() { try { txtUserName.Text = m_strEditUser; DBcon con = new DBcon(); SqlCommand cmd = new SqlCommand("SELECT * FROM tbWUser WHERE Name='" + m_strEditUser + "'", con.GetConnection()); SqlDataReader dr = cmd.ExecuteReader(); int intUserID; if (!dr.Read()) { dr.Close(); cmd.Dispose(); return; } intUserID = Convert.ToInt32(dr["ID"]); txtPwd.Text = dr["Password"].ToString(); txtPwd2.Text = txtPwd.Text; txtDescription.Text = dr["Description"].ToString().Trim(); dr.Close(); cmd.Dispose(); cmd = new SqlCommand("SELECT * FROM WUserFunction WHERE UserID=" + intUserID, con.GetConnection()); dr = cmd.ExecuteReader(); ArrayList arrFun = new ArrayList(); while (dr.Read()) { arrFun.Add(dr["FunctionID"]); } dr.Close(); cmd.Dispose(); for (int i = 0; i < arrFun.Count; i++) { SetItemCheckedByFunID((int)arrFun[i]); } } catch (Exception ex) { // 2007.05.30 // //MessageBox.Show(ex.ToString()); ExceptionHandler.Handle(ex); } }
/// <summary> /// /// </summary> /// <param name="UserName"></param> /// <returns></returns> private bool UserNameExist(string UserName) { DBcon con = new DBcon(); SqlCommand cmd = new SqlCommand("SELECT * FROM tbWUser WHERE Name='" + UserName.Trim() + "'", con.GetConnection()); SqlDataReader dr = cmd.ExecuteReader(); bool bln = dr.Read(); dr.Close(); if (bln) { return(true); } else { return(false); } }
private void LoadDataGrid() { try { DBcon con = new DBcon(); string str = "select * from tbWUser"; SqlCommand cmd = new SqlCommand(str, con.GetConnection()); cmd.ExecuteNonQuery(); cmd.Dispose(); SqlDataAdapter da = new SqlDataAdapter(str, con.GetConnection()); DataSet ds = new DataSet(); da.Fill(ds, "User"); da.Dispose(); this.m_dataGrid.DataSource = ds.Tables["User"]; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// /// </summary> private void ReadFunction() { try { DBcon con = new DBcon(); SqlCommand cmd = new SqlCommand("SELECT * FROM tbWFunction ORDER BY ID", con.GetConnection()); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string FunName = dr["Name"].ToString().Trim(); cklPurview.Items.Add(FunName); m_FunName2FunID.Add(FunName, (int)dr["id"]); } dr.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void ReadFunction() { try { dtEnd.Value = dtBegin.Value.AddDays(1); string str = "select Name from V_heatDatas Group by name"; //筛选以存站点 DBcon con = new DBcon(); SqlCommand cmd = new SqlCommand(str, con.GetConnection()); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { cmbStation.Items.Add(dr.GetValue(0).ToString()); } dr.Close(); InitializeColor(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public Sub2totpldtm() { InitializeComponent(); DBcon.InitializeDB(); }
public string UpdateRequest([FromBody] Request request) { DBcon.UpdateRequest(conn, request.RequestID, request.Approved, request.ApprovedBy, "updateRequest"); return("Update was successful"); }
public string RetrieveRequestByBloodType(string bloodType, string rhf) { string json = DBcon.RetrieveRequestByBloodType(conn, bloodType, rhf, "getRequestByBloodType"); return(json); }
public string RetrieveAllRequests() { string json = DBcon.RetrieveAllRequests(conn, "getAllRequests"); return(json); }
public string AddRequest([FromBody] Request request) { DBcon.AddRequest(conn, request.ClinicID, request.DateCompleted, request.HospitalID, request.Amount, request.BloodType, request.RHFactor, "AddRequest"); return("Request Made. Insertion was successful"); }