public static void Add(int projectId, string question)
{
con = new Connections();
string queryStr = "INSERT INTO [dbo].[Question] " +
"([Question], [ProjectId])" +
"VALUES (N'" + question + "', " + projectId + ")";
con.ExecuteScalar(queryStr);
con.CloseConnection();
}
public static void Add(int questionId, string answer, bool status)
{
con = new Connections();
string queryStr = "INSERT INTO [dbo].[Answer] " +
"([Answer], [QuestionId], [Status])" +
"VALUES (N'" + answer + "', " + questionId + ", " + status + ")";
con.ExecuteScalar(queryStr);
con.CloseConnection();
}
public static void Add(string name, DateTime createdAt, int createdBy, DateTime startDate, DateTime endDate)
{
con = new Connections();
string queryStr = "INSERT INTO [dbo].[Project] " +
"(ProjectCode, Name, CreatedAt, CreatedBy, StartDate, EndDate)" +
"VALUES ('PJ-' + CONVERT(VARCHAR, (SELECT IDENT_CURRENT('Project') AS INDENTITY)) + '" + createdAt.Day.ToString() + "', N'" + name + "', CONVERT(datetime, '" + createdAt + "', 103), " + createdBy + ", CONVERT(datetime, '" + startDate + "', 103), CONVERT(datetime, '" + endDate + "', 103))";
con.ExecuteScalar(queryStr);
con.CloseConnection();
}