private void BindGridQuestion()
{
int? getChaptersPerDay=0;
int lessonCompleted = 0;
int iSkip = 0;
string username = hdnusername.Value;
using (dbExtranetEntities db = new dbExtranetEntities())
{
var newuser = DataService.NewUser(username);
if (newuser==0)
{
imgPrevious.Visible = false;
getChaptersPerDay= DataService.GetTopicsPerChapter(lessonCompleted + 1);
iSkip = 0;
}
else
{
//skip sum coursemst topic and take nect lesson
//iSkip=
//getChaptersPerDay
}
grdchaptr.DataSource = DataService.LoadChapters(getChaptersPerDay);
grdchaptr.DataBind();
}
}
public static Int32 NewUser(string username)
{
Int32 result = 0;
using (dbExtranetEntities db = new dbExtranetEntities())
{
result = db.Beg_Result.Where(x => x.Username == username).ToList().Count;
}
return result;
}
protected void Login_Click1(object sender, EventArgs e)
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
using (var trans = db.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
var userlog = db.Users.Single(a => a.Username == txtUserName.Text && a.Password == txtPassword.Text);
if (userlog != null)
{
if (chkRemember.Checked)
{
Response.Cookies["um"].Value = txtUserName.Text;
Response.Cookies["ptd"].Value = txtPassword.Text;
Response.Cookies["um"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["ptd"].Expires = DateTime.Now.AddDays(-1);
}
else
{
Response.Cookies["um"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["ptd"].Expires = DateTime.Now.AddDays(-1);
}
string utype;
utype = userlog.Usertype.ToString().Trim().ToUpper();
if (utype == "A")
{
Session["USERNAME"] = txtUserName.Text;
Session["ut"] = utype;
FormsAuthentication.RedirectFromLoginPage("admin", true); ;
}
else if (utype == "U")
{
Session["USERNAME"] = txtUserName.Text;
Session["ut"] = utype;
Session["lgpr"] = userlog.LanguagePrefered;
FormsAuthentication.RedirectFromLoginPage("user", true); ;
// Response.Redirect("user",false);
}
}
else
{
lblError.Text = "Invalid User or Password! ";
}
}
catch (Exception ex)
{
}
}
}
}
public static int? GetTopicsPerChapter(Int32 lessoncompleted)
{
int? result = 0;
using (dbExtranetEntities db = new dbExtranetEntities())
{
result = db.CourseMsts.Where(x => x.Lesson == lessoncompleted).Select(x => x.Topics).SingleOrDefault();
}
return result;
}
protected void btnUpload_Click(object sender, EventArgs e)
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
using (var trans = db.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
using (BinaryReader br = new BinaryReader(FileUpload11.PostedFile.InputStream))
{
byte[] bytes = br.ReadBytes((int)FileUpload11.PostedFile.InputStream.Length);
var bf= new Beg_Files
{
Name = Path.GetFileName(FileUpload11.PostedFile.FileName),
ContentType = "audio/mpeg3",
Play = bytes,
BegAlphabetId = 1
};
db.Beg_Files.Add(bf);
db.SaveChanges();
trans.Commit();
}
//Response.Redirect(Request.Url.AbsoluteUri);
}
catch(Exception ex)
{
trans.Rollback();
throw;
}
}
}
//using (BinaryReader br = new BinaryReader(FileUpload11.PostedFile.InputStream))
//{
// byte[] bytes = br.ReadBytes((int)FileUpload11.PostedFile.InputStream.Length);
// string strConnString = ConfigurationManager.ConnectionStrings["LearnData"].ConnectionString;
// using (SqlConnection con = new SqlConnection(strConnString))
// {
// using (SqlCommand cmd = new SqlCommand())
// {
// cmd.CommandText = "insert into Beg_Files(Name, ContentType, Play) values (@Name, @ContentType, @Play)";
// cmd.Parameters.AddWithValue("@Name", Path.GetFileName(FileUpload11.PostedFile.FileName));
// cmd.Parameters.AddWithValue("@ContentType", "audio/mpeg3");
// cmd.Parameters.AddWithValue("@Play", bytes);
// cmd.Connection = con;
// con.Open();
// cmd.ExecuteNonQuery();
// con.Close();
// }
// }
//}
//
}
public static int? GetNumQuestTaken(string username, int? getChaptersPerDay)
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
List<int?> result1 = db.Beg_UserTest.Where(x => x.Username == username).Select(x => x.Course).ToList();
List<int> result2 = db.Beg_Test.Select(x => x.Id).ToList();
var differences = result2.Where(i => !result1.Contains(i)).ToList();
int diff = differences[0];
return diff;
}
}
private void BindGrid()
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
var query = db.tblFiles.Select(x => x).ToList();
}
//string strConnString = ConfigurationManager.ConnectionStrings["LearnData"].ConnectionString;
//using (SqlConnection con = new SqlConnection(strConnString))
//{
// using (SqlCommand cmd = new SqlCommand())
// {
// cmd.CommandText = "select Id, Name,Data from tblFiles";
// cmd.Connection = con;
// con.Open();
// //Repeater1.DataSource = cmd.ExecuteReader();
// //Repeater1.DataBind();
// DataList1.DataSource = cmd.ExecuteReader();
// DataList1.DataBind();
// con.Close();
// }
//}
}
public static bool SendBacktoSameCourse(string testday, string username)
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
using (var trans = db.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
var removeusertest = db.Beg_UserTest.Where(x => x.Username == username && x.Day == testday).ToList();
db.Beg_UserTest.RemoveRange(removeusertest);
db.SaveChanges();
trans.Commit();
return false;
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
}
public static List<LearningQuiz> LoadQuiz(int? getchaptersperday)
{
//4 quest
//gets first record
//List<Learning> randomList = LoadChapters(getchaptersperday);
List<LearningQuiz> resultList;
//randomList = randomList.Where(x => RandomService.GenerateRandom().Contains(x.BegPrId )).ToList();
using (dbExtranetEntities db = new dbExtranetEntities())
{
//load question
resultList =
db.Beg_Test.AsNoTracking().Join(db.Beg_Translate, x => x.Id, y => y.begAlphabetId, (x, y) => new {x, y})
.Join(db.Beg_Files, a => a.x.Id, b => b.BegAlphabetId, (a, b) => new {a, b})
.Where(x => x.a.x.Id == getchaptersperday)
.Select(xy => new LearningQuiz()
{
IdTestquiz = xy.a.x.Id,
IdquizDay = xy.a.x.Day,
QuestionNum = xy.a.x.QuestionNumber,
Question = xy.a.x.Question,
An = xy.a.x.Answer,
BegPrId = xy.a.x.BegAlphabetId
}).ToList();
}
return resultList;
}
protected void OnClick_Next(object sender, EventArgs e)
{
//UpdateTimer.Enabled = true;
int? getChaptersPerDay = 0;
int? getNumQuestTaken = 0;
int lessonCompleted = 0;
int iSkip = 0;
int i;
ViewState["questnum"] = 0;
using (dbExtranetEntities db = new dbExtranetEntities())
{
var newuser = DataService.NewUser(hdnusername.Value);
if (newuser == 0)
{
getChaptersPerDay = DataService.GetTopicsPerChapter(lessonCompleted + 1);
getNumQuestTaken = DataService.GetNumQuestTaken(hdnusername.Value, getChaptersPerDay);
ViewState["questnum"] = getNumQuestTaken;
imgPrevious.Visible = false;
iSkip = 0;
}
else
{
ViewState["questnum"] = Convert.ToInt32(ViewState["questnum"]) + 1;
//skip sum coursemst topic and take nect lesson
//iSkip=
//getChaptersPerDay
}
List<DataService.LearningQuiz> quest= DataService.LoadQuiz(Convert.ToInt32(ViewState["questnum"]));
lblQuest.Text = quest[0].QuestionNum + " " + quest[0].Question;
hdnAn.Value = Convert.ToString(quest[0].An);
hdnMainQuestid.Value= Convert.ToString(quest[0].BegPrId);
hdnTestQuestid.Value= Convert.ToString(quest[0].IdTestquiz);
hdnTestQuestDay.Value = Convert.ToString(quest[0].IdquizDay);
}
grdchaptr.Visible = false;
BindGridQuiz(getChaptersPerDay, Convert.ToInt32( hdnMainQuestid.Value));
btnsubmit.Visible = true;
}
protected void btnSignup_Click(object sender, EventArgs e)
{
if (txtusername.Text != "" && txtPassword.Text != "" && txtConfirmPass.Text != "" && txtEmail.Text != "" && ddlPreferedLanguage.SelectedItem.Text!="Select" &&
txtName.Text != "")
{
if (txtPassword.Text == txtConfirmPass.Text)
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
using (var trans = db.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
var username = db.Users.Where(a=> a.Username == txtusername.Text).Select(x => x.Username).FirstOrDefault();
if (username == null)
{
var addUser = new User
{
Username = txtusername.Text,
Password = txtPassword.Text,
Email = txtEmail.Text ,
Name = txtName.Text,
LanguagePrefered = ddlPreferedLanguage.SelectedItem.Text,
};
db.Users.Add(addUser);
}
else
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = "Username Already Exists In Our Database";
}
db.SaveChanges();
trans.Commit();
Response.Redirect("~/SignIn.aspx",false);
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
//string cs = ConfigurationManager.ConnectionStrings["LearnData"].ConnectionString;
// using (SqlConnection con = new SqlConnection(cs))
// {
// SqlCommand cmduser =
// new SqlCommand("Select Username from Users where username ='******'", con);
// SqlDataAdapter sda = new SqlDataAdapter(cmduser);
// DataTable dt = new DataTable();
// sda.Fill(dt);
// if (dt.Rows.Count == 0)
// {
// SqlCommand cmd =
// new SqlCommand(
// " Insert into Users values ('" + txtusername.Text + "','" + txtPassword.Text +
// "', '" +
// txtEmail.Text + "','" + txtName.Text + "' , '" + "U" + "')", con);
// con.Open();
// cmd.ExecuteNonQuery();
// lblMsg.ForeColor = Color.Green;
// lblMsg.Text = "Registration Successfull";
// Response.Redirect("~/SignIn.aspx");
// con.Close();
// }
// else
// {
// lblMsg.ForeColor = Color.Red;
// lblMsg.Text = "Username Already Exists In Our Database";
// }
//}
}
else
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = "Password Do Not Match";
}
}
else
{
lblMsg.ForeColor=Color.Red;
lblMsg.Text = "All Fields Are Required";
}
}
public static List<Learning> LoadChapters(int? getchaptersperday)
{
List<Learning> resultList;
using (dbExtranetEntities db = new dbExtranetEntities())
{
resultList = db.Beg_Alphabet.Join(db.Beg_Translate, x => x.Id, y => y.begAlphabetId, (x, y) => new {x, y})
.Join(db.Beg_Files, a => a.x.Id, b => b.BegAlphabetId, (a, b) => new {a, b})
.Take(Convert.ToInt32(getchaptersperday))
.Select(xy => new Learning()
{
BegPrId = xy.a.x.Id,
CapitalLetters = xy.a.x.CapitalLetter,
SmallLetters = xy.a.x.SmallLetter,
Kannada = xy.a.y.Kannada,
Hindi = xy.a.y.Hindi,
Play = xy.b.Play
}).ToList();
}
return resultList;
}
public static List<Learning> LoadQuizWithRandomSet(int? getchaptersperday, Int32 id, string username)
{
// int? nam=0;
List<Learning> resultList = null;
List<Learning> resultRandomList = null;
List<Learning> resultList1 = null;
Int32 i = 0;
using (dbExtranetEntities db = new dbExtranetEntities())
{
List<int?> randomnum = RandomService.GenerateRandom();
var testid = db.Beg_UserTest.Where(x => x.Username == username).Select(x => x.Course).Distinct().ToList();
//takequestion
resultList =
db.Beg_Test.AsNoTracking()
.Join(db.Beg_Translate, x => x.BegAlphabetId, y => y.begAlphabetId, (x, y) => new {x, y})
.Join(db.Beg_Files, a => a.x.BegAlphabetId, b => b.BegAlphabetId, (a, b) => new {a, b})
// .Take(Convert.ToInt32(getchaptersperday))
.Where(x => x.a.x.BegAlphabetId == id).Take(1)
.Select(xy => new Learning()
{
idName = xy.a.x.Id,
BegPrId = xy.a.x.BegAlphabetId,
Kannada = xy.a.y.Kannada,
Hindi = xy.a.y.Hindi,
Play = xy.b.Play
}).ToList();
// nam = resultList[0].idName;
resultRandomList =
db.Beg_Alphabet.Join(db.Beg_Translate, x => x.Id, y => y.begAlphabetId, (x, y) => new {x, y})
.Join(db.Beg_Files, a => a.x.Id, b => b.BegAlphabetId, (a, b) => new {a, b})
.Join(db.Beg_Test, aa => aa.a.x.Id, bb => bb.BegAlphabetId, (aa, bb) => new {aa, bb})
.Take(Convert.ToInt32(getchaptersperday))
.Where(xx => randomnum.Contains(xx.aa.a.x.Id))
.Select(xy => new Learning()
{
idName = xy.bb.Id,
BegPrId = xy.aa.a.x.Id,
Kannada = xy.aa.a.y.Kannada,
Hindi = xy.aa.a.y.Hindi,
Play = xy.aa.b.Play
}).ToList();
resultList1 = resultList.Union(resultRandomList).ToList();
}
return resultList1;
}
public static void AnswerGiven(int testid, string username, int begid)
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
using (var trans = db.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
var getquestioninfo = db.Beg_Test.SingleOrDefault(x => x.Id == testid);
var getAnstext = db.Beg_Alphabet.SingleOrDefault(x => x.Id == begid);
var testgiven = new Beg_UserTest()
{
BegAlphabetId = getquestioninfo.BegAlphabetId,
Username = username,
Course = testid,
Day = getquestioninfo.Day,
Question = getquestioninfo.Question,
QuestionNumber = getquestioninfo.QuestionNumber,
Answer = getAnstext.CapitalLetter
};
db.Beg_UserTest.Add(testgiven);
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
}
public static bool ResultPassorFail(string testday, string username)
{
using (dbExtranetEntities db = new dbExtranetEntities())
{
bool res = false;
var results = db.Beg_UserTest.AsNoTracking().Where(x => x.Day == testday && x.Username == username).ToList();
foreach (var result in results)
{
if (result.Answer == result.Question)
{
res = true;
}
else
{
res = false;
break;
}
}
return res;
}
}
public static int GetquestAnswered(string testid, string username)
{
int? result;
using (dbExtranetEntities db = new dbExtranetEntities())
{
result =
db.Beg_UserTest.AsNoTracking()
.Where(x => x.Username == username && x.Day == testid.ToString())
.ToList()
.Count();
}
return result.GetValueOrDefault();
}
public static int GetCoursemst(int testid)
{
int? result;
using (dbExtranetEntities db = new dbExtranetEntities())
{
//var getquestioninfo = db.Beg_Test.SingleOrDefault(x => x.Id == testid);
result = db.CourseMsts.AsNoTracking().Where(x => x.Lesson == testid).Select(x => x.Topics).SingleOrDefault();
}
return result.GetValueOrDefault();
}
