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();
}
}
