public List<SubCategoryAdmin> CreateSubCategory(SubCategory subCategory) { List<SubCategoryAdmin> subcategories = new List<SubCategoryAdmin>(); int result = 0; try { ctx.SubCategorys.Add(subCategory); result = ctx.SaveChanges(); subcategories = GetAllSubCatAdmin(); return subcategories; } catch (SqlException sqlex) { exceptionMessage = sqlex.Message; } catch (OASCustomException customex) { exceptionMessage = customex.Message; } catch (Exception ex) { exceptionMessage = ex.Message; } return subcategories; }
public int CreateUserTest(UserTest usertest) { int result = 0; string exceptionMessage; try { ctx.UserTests.Add(usertest); result = ctx.SaveChanges(); return(result); } catch (SqlException sqlex) { exceptionMessage = sqlex.Message; } catch (OASCustomException customex) { exceptionMessage = customex.Message; } catch (Exception ex) { exceptionMessage = ex.Message; } return(result); }
public List <TopicAdmin> CreateTopic(Topic topic) { List <TopicAdmin> topicslist = new List <TopicAdmin>(); int result = 0; try { ctx.Topics.Add(topic); result = ctx.SaveChanges(); topicslist = GetAllTopicAdmin(); return(topicslist); } catch (SqlException sqlex) { exceptionMessage = sqlex.Message; } catch (OASCustomException customex) { exceptionMessage = customex.Message; } catch (Exception ex) { exceptionMessage = ex.Message; } return(topicslist); }
public int UpdateQuestionBank(QuestionBank questionBank) { int result = 0; try { QuestionBank existingQuestionBank = ctx.QuestionBanks.FirstOrDefault(questionbanks => questionbanks.QuestionBankID == questionbanks.QuestionBankID); if (existingQuestionBank != null) { existingQuestionBank.Question = questionBank.Question; existingQuestionBank.Option1 = questionBank.Option1; existingQuestionBank.Option2 = questionBank.Option2; existingQuestionBank.Option3 = questionBank.Option3; existingQuestionBank.Option4 = questionBank.Option4; existingQuestionBank.Answer = questionBank.Answer; existingQuestionBank.DifficultyLevelID = questionBank.DifficultyLevelID; existingQuestionBank.TopicID = questionBank.TopicID; existingQuestionBank.Marks = questionBank.Marks; result = ctx.SaveChanges(); } return(result); } catch (SqlException sqlex) { exceptionMessage = sqlex.Message; } catch (OASCustomException customex) { exceptionMessage = customex.Message; } catch (Exception ex) { exceptionMessage = ex.Message; } return(result); }
public int CreateTest(Test test) { int result = 0; try { ctx.Tests.Add(test); result = ctx.SaveChanges(); return(result); } catch (SqlException sqlex) { exceptionMessage = sqlex.Message; } catch (OASCustomException customex) { exceptionMessage = customex.Message; } catch (Exception ex) { exceptionMessage = ex.Message; } return(result); }
public int CreateCategory(Category category) { int result = 0; try { ctx.Categorys.Add(category); result = ctx.SaveChanges(); return(result); } catch (SqlException sqlex) { exceptionMessage = sqlex.Message; } catch (OASCustomException customex) { exceptionMessage = customex.Message; } catch (Exception ex) { exceptionMessage = ex.Message; } return(result); }
public int CreateQuestionBank(int id) { int result = 0; string excelFile = null; var httpRequest = HttpContext.Current.Request; string filePath = string.Empty; var postedFile = httpRequest.Files[0]; try { if (postedFile != null) { string path = HttpContext.Current.Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } excelFile = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-"); excelFile = excelFile + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); filePath = path + excelFile; postedFile.SaveAs(filePath); string extension = Path.GetExtension(postedFile.FileName); string conString = string.Empty; switch (extension) { case ".xls": //Excel 97-03. conString = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString; break; case ".xlsx": //Excel 07 and above. conString = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString; break; default: break; } DataTable dt = new DataTable(); conString = string.Format(conString, filePath); using (OleDbConnection connExcel = new OleDbConnection(conString)) { using (OleDbCommand cmdExcel = new OleDbCommand()) { using (OleDbDataAdapter odaExcel = new OleDbDataAdapter()) { cmdExcel.Connection = connExcel; //Get the name of First Sheet. connExcel.Open(); DataTable dtExcelSchema; dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString(); connExcel.Close(); //Read Data from First Sheet. connExcel.Open(); cmdExcel.CommandText = "SELECT * From [" + sheetName + "]"; odaExcel.SelectCommand = cmdExcel; odaExcel.Fill(dt); connExcel.Close(); } } } //Insert records to database table. OASContext ctx = new OASContext(); foreach (DataRow row in dt.Rows) { ctx.QuestionBanks.Add(new QuestionBank { QuestionBankID = Convert.ToInt32(row["QuestionBankID"]), Question = Convert.ToString(row["Question"]), Option1 = Convert.ToString(row["Option1"]), Option2 = Convert.ToString(row["Option2"]), Option3 = Convert.ToString(row["Option3"]), Option4 = Convert.ToString(row["Option4"]), Answer = Convert.ToString(row["Answer"]), Marks = Convert.ToInt32(row["Marks"]), DifficultyLevelID = Convert.ToInt32(row["DifficultyLevelID"]), //TopicID = Convert.ToInt32(row["TopicID"]) TopicID = id }); } result = ctx.SaveChanges(); } else { return(result); } } catch (SqlException sqlex) { exceptionMessage = sqlex.Message; } catch (OASCustomException customex) { exceptionMessage = customex.Message; } catch (Exception ex) { exceptionMessage = ex.Message; } return(result); }