//To Update the records of a particluar employee
public int UpdateWikiEntry(WikiEntry wikiEntry)
{
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spUpdateWikiEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Day", wikiEntry.Day);
cmd.Parameters.AddWithValue("@Month", wikiEntry.Month);
cmd.Parameters.AddWithValue("@Year", wikiEntry.Year);
cmd.Parameters.AddWithValue("@Description", wikiEntry.Description);
cmd.Parameters.AddWithValue("@Category", wikiEntry.Category);
cmd.Parameters.AddWithValue("@DateAdded", wikiEntry.DateAdded);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
return(1);
}
catch
{
throw;
}
}
public IEnumerable <WikiEntry> GetAllWikiEntries()
{
try
{
List <WikiEntry> lstWikiEntries = new List <WikiEntry>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spGetAllWikiEntries", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
WikiEntry wikiEntry = new WikiEntry();
wikiEntry.ID = Convert.ToInt32(rdr["ID"]);
wikiEntry.Day = Convert.ToInt32(rdr["ID"]);
wikiEntry.Month = Convert.ToInt32(rdr["ID"]);
wikiEntry.Year = Convert.ToInt32(rdr["ID"]);
wikiEntry.Description = Convert.ToString(rdr["ID"]);
wikiEntry.Category = Convert.ToString(rdr["ID"]);
wikiEntry.DateAdded = Convert.ToDateTime(rdr["ID"]);
}
con.Close();
}
return(lstWikiEntries);
}
catch
{
throw;
}
}
public static void WriteToDB(List <string> list)
{
try
{
for (int i = 1; i < list.Count; i++)
{
WikiEntry wikiEntry = new WikiEntry();
wikiEntry.Day = DateHelper.dayToInt();
wikiEntry.Month = DateHelper.monthToInt();
var temp = list[i];
var first = temp.IndexOf('|');
var last = temp.LastIndexOf('|');
var year = temp.Substring(first + 1, last - first - 1).Trim();
wikiEntry.Year = Int32.Parse(year);
wikiEntry.Description = list[i].Substring(last + 1, list[i].Length - last - 1).Trim();
wikiEntry.Category = list[i].Substring(0, first - 1).Trim();
wikiEntry.DateAdded = DateTime.Now;
DBHelper dbHelper = new DBHelper();
dbHelper.AddWikiEntry(wikiEntry);
}
}
catch (Exception ex)
{
Console.WriteLine($"Error while inserting in DB {ex.Message}");
}
}
//Get the details of a particular employee
public WikiEntry GetWikiEntryData(int id)
{
try
{
WikiEntry wikiEntry = new WikiEntry();
using (SqlConnection con = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM tblEmployee WHERE EmployeeID= " + id;
SqlCommand cmd = new SqlCommand(sqlQuery, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
wikiEntry.ID = Convert.ToInt32(rdr["ID"]);
wikiEntry.Day = Convert.ToInt32(rdr["ID"]);
wikiEntry.Month = Convert.ToInt32(rdr["ID"]);
wikiEntry.Year = Convert.ToInt32(rdr["ID"]);
wikiEntry.Description = Convert.ToString(rdr["ID"]);
wikiEntry.Category = Convert.ToString(rdr["ID"]);
wikiEntry.DateAdded = Convert.ToDateTime(rdr["ID"]);
}
}
return(wikiEntry);
}
catch
{
throw;
}
}