public datainsertion()
{
InitializeComponent();
catAppDB = new CatAppDataClasses(DBConnectionString);
this.DataContext = this;
}
// public static string DBConnectionString = "Data Source=C:/Users/shweta/Desktop/solprog1june/prog reporttry/CATapp/catappdb.sdf";
// public Int64 op;
public Page3()
{
InitializeComponent();
// Connect to the database and instantiate data context.
catAppDB = new CatAppDataClasses(DBConnectionString);
// Data context and observable collection are children of the main page.
this.DataContext = this;
dt.Interval = new TimeSpan(0, 0, 0, 0, 1);
dt.Tick += new EventHandler(dt_Tick);
startDt = DateTime.Now;
dt.Start();
}
private void OK_Click(object sender, RoutedEventArgs e)
{
IDictionary<string, string> y = this.NavigationContext.QueryString;
String b = Convert.ToString(y["TextData1"]);
textBox2.Text = b.ToString();
MessageBox.Show("b" + textBox2.Text);
String timeonoff = b.ToString();
long tmonoff;
long.TryParse(timeonoff, out tmonoff);
bool tmd;
if (tmonoff == 0)
{
tmd = false;
}
else
{
tmd = true;
}
string s = textBox1.Text;
long l;
long.TryParse(s, out l);
var timest = from Test t in catAppDB.Tests
where t._id == l
select t;
Tests = new ObservableCollection<Test>(timest);
var time = Tests.ToList();
var t2 = time[0] as Test;
var tt = t2.Allowed_time;
txtAllowed.Text = tt.ToString();
// txtAllowed.Text = Tests.ToString();
// MessageBox.Show("Allowed Time" + txtAllowed.Text);
//var tt = Tests.ToList();
// int ts = tt[0].Allowed_time;
// txtAllowed.Text = Tests.ToString();
string tmpstp = txtAllowed.Text;
int l1;
long uid = 0;
int.TryParse(tmpstp, out l1);
ll = l1;
IList<User> UserList = this.GetUserList();
foreach (User usr1 in UserList)
{
uid = usr1._id;
}
using (catAppDB = new CatAppDataClasses(DBConnectionString))
{
Attempt newAttempt = new Attempt
{
T_id = l,
Timpstamp = l1,
Elapsed_time = l1 - ltotal,
U_id = uid,
//T_id = 13,
//Timpstamp = 2100,
Complete = completed,
//Elapsed_time = 200,
Timed = tmd
};
catAppDB.Attempts.InsertOnSubmit(newAttempt);
catAppDB.SubmitChanges();
//DialogClosed("OK");
}
}
public IList<User> GetUserList()
{
// Fetching data from local database
IList<User> UserList = null;
using (catAppDB = new CatAppDataClasses(DBConnectionString))
{
IQueryable<User> UserQuery = from Us in catAppDB.Users select Us;
UserList = UserQuery.ToList();
}
return UserList;
}
public IList<Test> GetTestList()
{
// Fetching data from local database
IList<Test> TestList = null;
using (catAppDB = new CatAppDataClasses(DBConnectionString))
{
IQueryable<Test> TestQuery = from Ts in catAppDB.Tests select Ts;
TestList = TestQuery.ToList();
}
return TestList;
}
public IList<Attempt> GetAttemptList()
{
// Fetching data from local database
IList<Attempt> AttemptList = null;
using (catAppDB = new CatAppDataClasses(DBConnectionString))
{
IQueryable<Attempt> AttemptQuery = from attempt1 in catAppDB.Attempts select attempt1;
AttemptList = AttemptQuery.ToList();
}
return AttemptList;
}
public noque()
{
InitializeComponent();
// Connect to the database and instantiate data context.
catAppDB = new CatAppDataClasses(DBConnectionString);
// Data context and observable collection are children of the main page.
this.DataContext = this;
}
private void radioButton1_Click_1(object sender, RoutedEventArgs e)
{
RadioButton radio = sender as RadioButton;
//Boolean b = true;
//if (radio.Tag.ToString().Equals(b.ToString()))
//{
// IsAnswerCorrect = "true";
// // radio.IsChecked = true;
//}
//else
//{
// IsAnswerCorrect = "false";
// //radio.IsChecked = false;
//}
string cn = radio.Content.ToString();
string id = txtquesID.Text.ToString();
long qid;
long.TryParse(id, out qid);
var opp = (from Option opt in catAppDB.Options
where opt.Q_id == qid
select opt).Count();
/*var testid = from Question que in catAppDB.Questions
where que._id == qid
select que;
var quelst = testid.ToList();*/
var opp1 = from Option opt in catAppDB.Options
where opt.Q_id == qid
select opt;
var opt1list = opp1.ToList();
for (int i = 0; i < opp; i++)
{
var opt2 = opt1list[i] as Option;
string opt3 = opt2.Content.ToString();
if (opt3 == cn)
{
txtoptid.Text = opt2._id.ToString();
}
}
long optid;
long.TryParse(txtoptid.Text, out optid);
using (catAppDB = new CatAppDataClasses(DBConnectionString))
{
Attempt_detail newAttempt_detail = new Attempt_detail
{
Q_id = qid,
O_id = optid,
A_id=2,
//Q_id=51,
//O_id=1842,
//_id=5002,
//A_id=1,
// // A_id=1,
//O_id=optid,
Mark_flag = true
};
catAppDB.Attempt_details.InsertOnSubmit(newAttempt_detail);
catAppDB.SubmitChanges();
//DialogClosed("OK");
}
}
public IList<Option> GetOptionList()
{
// Fetching data from local database
IList<Option> OptionList = null;
using (catAppDB = new CatAppDataClasses(DBConnectionString))
{
IQueryable<Option> OptionQuery = from option1 in catAppDB.Options select option1;
OptionList = OptionQuery.ToList();
}
return OptionList;
}
