public void RetreiveAllPositions() { StaticPositionCollection.staticPositionList.Clear(); using (var db = DBConnection.CreateConnection()) { db.Open(); var sql = "dbo.GetPositions"; var cmd = new SqlCommand(sql, db); var reader = cmd.ExecuteReader(); if (!reader.HasRows) { return; } while (reader.Read()) { var item = new DesignationItem(); item._POS_ID = (int)reader["POS_ID"]; item._POS_NAME = (string)reader["POS_NAME"]; item._POS_DEPARTMENT = (string)reader["POS_DEPARTMENT"]; StaticPositionCollection.staticPositionList.Add(item); } db.Close(); } }
public void SaveDesignation(DesignationItem myItem) { using (var db = DBConnection.CreateConnection()) { db.Open(); var sql = "dbo.spInsertPosition"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@POS_NAME", myItem._POS_NAME)); cmd.Parameters.Add(new SqlParameter("@POS_DEPARTMENT", myItem._POS_DEPARTMENT)); cmd.ExecuteNonQuery(); db.Close(); } }