protected void btnDisapprove_Click(object sender, EventArgs e)
{
foreach (ListItem a in cblApprovedStudent.Items)
{
if (a.Selected)
{
MySQLDatabase data = new MySQLDatabase();
data.Execute("UpdateIsConfirmFalseByStudentCourseID",
new Dictionary <string, object> {
{ "@scid", a.Value }
}, true);
var marksection = data.QueryValue("GetMarkSectionIdForAttendenceByTCID",
new Dictionary <string, object>
{
{ "@tcid", ddlCourseTitle.SelectedValue }
}, true);
var studentid = data.QueryValue("GetStudentTableIdByScid",
new Dictionary <string, object>
{
{ "@scid", a.Value }
}, true);
data.Execute("DeleteMarkByMsidSid",
new Dictionary <string, object>
{
{ "@msid", marksection },
{ "@sid", studentid }
}, true);
}
}
loadNotApprovedStudent();
loadApprovedStudent();
}
//protected void LoadCBL(object o, EventArgs e) {
// MySQLDatabase db = new MySQLDatabase();
// var yid = db.QueryValue("getYearId", new Dictionary<string, object>() { { "@pyear", DateTime.Now.Year } }, true);
// var ycsId = db.QueryValue("getYearClassSectionId",
// new Dictionary<string, object>() {
// {"@pyearid", yid },
// {"@pclassid", ddlClass.SelectedValue },
// {"@psectionid", ddlSection.SelectedValue }
// }, true);
// cblDue.DataSource = db.Query("getStudentByTUNYCSId",
// new Dictionary<string, object>() {
// {"@TUN", User.Identity.Name},
// {"@YCSId", ycsId },
// {"@pdue", Convert.ToInt32(txtDueGreaterThen.Text.Length==0?"0":txtDueGreaterThen.Text) }
// }, true).Select(x => new TextValuePair {
// Text = x["student"],
// Value = x["studentid"]
// }).ToList();
// cblDue.DataBind();
//}
private List <TextValuePair> getStudents()
{
MySQLDatabase db = new MySQLDatabase();
var yid = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var ycsId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yid },
{ "@pclassid", ddlClass.SelectedValue },
{ "@psectionid", ddlSection.SelectedValue }
}, true);
return(db.Query("getStudentByTUNYCSId",
new Dictionary <string, object>()
{
{ "@TUN", User.Identity.Name },
{ "@YCSId", ycsId }
}, true).Select(x => new TextValuePair {
Text = x["student"],
Value = x["studentid"]
}).ToList());
}
protected void LoadCBAdd(object obj, EventArgs e)
{
//TODO remove students who are already in the group
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var YCSId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yearId },
{ "@pclassid", ddlClass.SelectedValue },
{ "@psectionid", ddlSection.SelectedValue }
}, true);
cbAdd.DataSource = db.Query("getStudentByTUNYCSId",
new Dictionary <string, object>()
{
{ "@TUN", User.Identity.Name },
{ "@YCSId", YCSId }
}, true).Select(x => new {
Text = x["firstname"] + x["lastname"],
Value = x["studentid"]
}).ToList();
cbAdd.DataBind();
}
protected void btnApply_Click(object sender, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var YCSId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yearId },
{ "@pclassid", Convert.ToInt32(txtClass.Text) },
{ "@psectionid", Convert.ToInt32(txtSection.Text) }
}, true);
if (YCSId == null)
{
info.Attributes["class"] = "text-danger";
}
else
{
db.Execute("changeStudent",
new Dictionary <string, object>()
{
{ "@SId", ddlStudent.SelectedValue },
{ "@YCSId", YCSId },
{ "@proll", Convert.ToInt32(txtRoll.Text) }
}, true);
}
}
protected void Page_Load(object o, EventArgs e)
{
if (!IsPostBack)
{
ddlAs.Items.Add(new ListItem("Student", "student"));
if (User.IsInRole("Admin"))
{
ddlAs.Items.Add(new ListItem("Teacher", "teacher"));
ddlAs.Items.Add(new ListItem("Admin", "admin"));
}
ddlDesignation.DataSource = db.Query("getAllDesignation", null, true).
Select(x => new TextValuePair {
Text = x["designation"],
Value = x["id"]
}).ToList();
ddlDesignation.DataBind();
ddlClass.DataSource = db.Query("getClassByYId",
new Dictionary <string, object>()
{
{ "@YId", db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true) }
}, true).Select(x => new TextValuePair {
Text = x["class"],
Value = x["classid"]
}).ToList();
ddlClass.DataBind();
}
}
protected void btnIssue_Click(object sender, EventArgs e)
{
var data = new MySQLDatabase();
var mId = data.QueryValue("GetMemberIdByMemberNum",
new Dictionary <string, object>
{
{ "@mNum", txtMemberNumber.Text }
}, true);
var bId = data.QueryValue("GetBookIdByBookNum",
new Dictionary <string, object>
{
{ "@bNum", txtBookNumber.Text }
}, true);
var returnDate = DateTime.Now;
if (ddlWeek.SelectedValue == "1")
{
returnDate = returnDate.AddDays(7);
}
else
{
returnDate = returnDate.AddDays(14);
}
data.Execute("AddNewBookRecord",
new Dictionary <string, object>
{
{ "@mid", mId },
{ "@bid", bId },
{ "@tDate", DateTime.Now },
{ "@rDate", returnDate },
}, true);
h3Success.Visible = true;
LoadGvBooks();
}
protected void btnAssign_Click(object sender, EventArgs e)
{
//Checks if a YearClassSection entry with null Section exists
int?nullSectionId = (int?)db.QueryValue("hasNullSection",
new Dictionary <string, object>()
{
{ "@YId", ddlYear.SelectedValue },
{ "@CId", ddlClass.SelectedValue }
}, true);
foreach (ListItem item in cbSection.Items)
{
if (item.Selected)
{
int count = Convert.ToInt32(db.QueryValue("countSectionInClassYear",
new Dictionary <string, object>()
{
{ "@YId", ddlYear.SelectedValue },
{ "@CId", ddlClass.SelectedValue },
{ "@SId", item.Value }
}, true));
if (count > 0)
{
continue;
}
if (nullSectionId == null)
{
//If no entry with null Section found, add a new entry normally
db.Execute("addYearClassSection", new Dictionary <string, object>()
{
{ "@YId", ddlYear.SelectedValue },
{ "@CId", ddlClass.SelectedValue },
{ "@SId", item.Value }
}, true);
}
else
{
//If a entry with null section exists, replace that with a section id
db.Execute("changeSectionId", new Dictionary <string, object>()
{
{ "@YCSId", nullSectionId },
{ "@Sid", item.Value }
}, true);
//Next sections will be added normally
nullSectionId = null;
}
}
}
LoadGVSection(null, null);
}
protected void Page_Init(object sender, EventArgs e)
{
yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
if (!IsPostBack)
{
LoadDDLClass(null, null);
LoadDDLType(null, null);
hSuccess.Visible = false;
}
}
protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var teacherId = db.QueryValue("getTIdByTUN", new Dictionary <string, object>()
{
{ "@TUN", User.Identity.Name }
}, true);
ReloadDDLSection(teacherId, yearId);
LoadCBAdd(sender, e);
}
public void DBConnect()
{
IMySqlDatabase iMySqlDatabase = new MySQLDatabase("DefaultConnection");
//var result= iMySqlDatabase.QueryValue("", null);
Assert.ThrowsException <ArgumentException>(() => { iMySqlDatabase.QueryValue("", null); }, "Command text cannot be null or empty.");
}
private void LoadStudentClass()
{
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
ddlClass.DataSource = db.Query(
"getClassByYId",
new Dictionary <string, object>()
{
{ "@YId", yearId }
},
true)
.Select(x => new {
Text = x["class"],
Value = x["classid"]
}).ToList();
ddlClass.DataBind();
if (ddlClass.Items.Count > 0)
{
ReloadDDLSection(yearId);
}
else
{
ddlSection.Items.Clear();
}
}
protected void btnPush_Click(object sender, EventArgs e)
{
if (IsValid)
{
MySQLDatabase db = new MySQLDatabase();
var TUId = Context.GetOwinContext().GetUserManager <ApplicationUserManager>().FindByName(User.Identity.Name).Id;
var res1 = db.Query("GetStudentIdByGId",
new Dictionary <string, object>()
{
{ "@GId", ddlTo.SelectedValue }
}, true);
var id = db.QueryValue("addNotification",
new Dictionary <string, object>()
{
{ "@TUId", TUId },
{ "@ptitle", txtSubject.Text },
{ "@pbody", txtDetail.Text }
}, true);
foreach (var item in res1)
{
db.Execute("addStudentNotification",
new Dictionary <string, object>()
{
{ "@SId", item["studentId"] },
{ "@NId", id }
}, true);
}
notificatinName.InnerText = txtSubject.Text;
groupName.InnerText = ddlTo.SelectedItem.Text;
divSuccessful.Visible = true;
}
}
private void BindDLL()
{
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var teacherId = Context.GetOwinContext().GetUserManager <ApplicationUserManager>().FindByName(User.Identity.Name).Id;
ReloadDDLGroup();
ddlClass.DataSource = db.Query(
"getClassByTUIdYId",
new Dictionary <string, object>()
{
{ "@TUId", teacherId },
{ "@YId", yearId }
},
true)
.Select(x => new {
Text = x["class"],
Value = x["classid"]
}).ToList();
ddlClass.DataBind();
ReloadDDLSection(teacherId, yearId);
}
private void ReloadDDLStudent(object yearId)
{
MySQLDatabase db = new MySQLDatabase();
var YCSId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yearId },
{ "@pclassid", ddlClass.SelectedValue },
{ "@psectionid", ddlSection.SelectedValue }
}, true);
ddlStudent.DataSource = db.Query("getStudentByYCSId",
new Dictionary <string, object>()
{
{ "@YCSId", YCSId }
}, true).Select(x => new {
Text = x["student"],
Value = x["studentid"]
}).ToList();
ddlStudent.DataBind();
//Reload Textboxes according to new ddl selection
if (ddlStudent.Items.Count > 0)
{
ReloadTextBox(Convert.ToInt32(ddlStudent.SelectedValue), (int)YCSId);
}
else
{
txtClass.Text = string.Empty;
txtSection.Text = string.Empty;
txtRoll.Text = string.Empty;
}
}
protected void BtnAuthorFinish_Click(object sender, EventArgs e)
{
var data = new MySQLDatabase();
data.Execute("AddNewBook",
new Dictionary <string, object>
{
{ "@bNum", txtBookNumber.Text },
{ "@bTitle", txtBookTitle.Text },
{ "@bPrice", txtBookPrice.Text },
{ "@bLan", txtBookLanguage.Text },
{ "@bEdi", txtBookEdition.Text }
}, true);
var lastBoookId = data.QueryValue("GetLastInsertedBookId", new Dictionary <string, object> {
}, true);
data.Execute("AddBookCatagory",
new Dictionary <string, object>
{
{ "@bid", lastBoookId },
{ "@cid", ddlCategory.SelectedValue }
}, true);
data.Execute("AddBookAuthor",
new Dictionary <string, object>
{
{ "@bid", lastBoookId },
{ "@aid", ddlAuthor.SelectedValue }
}, true);
multiView1.ActiveViewIndex = 3;
}
protected void btnCtSave_Click(object sender, EventArgs e)
{
if (IsValid)
{
MySQLDatabase data = new MySQLDatabase();
data.Execute("AddSectionName",
new Dictionary <string, object>
{
{ "@name", txtName.Text }
}, true);
var lastSecId = data.QueryValue("GetLastInsertIdOfSectionName",
new Dictionary <string, object> {
}, true);
data.Execute("AddMarksectionForCt",
new Dictionary <string, object>
{
{ "@tcid", ddlSelectCourse.SelectedValue },
{ "@snid", lastSecId },
{ "@msmark", Convert.ToInt32(txtMarks.Text) }
}, true);
var LastMarkSectionIdForCt = data.QueryValue("GetLastInsertIdOfMarkSection4CtAssByTcid",
new Dictionary <string, object> {
{ "@tcid", ddlSelectCourse.SelectedValue }
}, true);
var studentTableIdlist = data.Query("GetStudentTableIdByTcid",
new Dictionary <string, object> {
{ "@tcid", ddlSelectCourse.SelectedValue }
}, true);
foreach (var a in studentTableIdlist)
{
var val = a["studentid"];
data.Execute("AddMark4CtAssByMsidSid",
new Dictionary <string, object>
{
{ "@msid", LastMarkSectionIdForCt },
{ "@sid", val }
}, true);
}
LoadGvCtAss();
}
}
protected void ddlStudent_SelectedIndexChanged(object sender, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var YCSId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yearId },
{ "@pclassid", ddlClass.SelectedValue },
{ "@psectionid", ddlSection.SelectedValue }
}, true);
ReloadTextBox(Convert.ToInt32(ddlStudent.SelectedValue), (int)YCSId);
}
/// <summary>
/// Click Event Handler for btnApply. Creates a new response.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnApply_Click(object sender, EventArgs e)
{
if (IsValid)
{
Dictionary <string, object> dict = new Dictionary <string, object>(13);
dict.Add("applicationid", Convert.ToInt32(Request.QueryString["appid"]));
dict.Add("firstname", txtFirstName.Text);
dict.Add("lastname", txtFirstName.Text);
dict.Add("fathersname", txtFathersName.Text);
dict.Add("mothersname", txtMothersName.Text);
dict.Add("email", txtEmail.Text);
dict.Add("gender", ddlGender.SelectedValue);
dict.Add("birthdate", txtBirthDate.Text);
dict.Add("phoneNumber", txtBirthDate.Text);
dict.Add("address", txtAddress.Text);
if (Convert.ToInt32(Request.QueryString["type"]) == 2)
{
dict.Add("designationId", ViewState["id"]);
dict.Add("qualification", txtQualification.Text);
dict.Add("class", null);
dict.Add("GaurdianOccupation", null);
dict.Add("GaurdianOccupationDetail", null);
}
else
{
dict.Add("designationId", null);
dict.Add("qualification", null);
dict.Add("class", ViewState["id"]);
dict.Add("GaurdianOccupation", txtGuardianOccupation.Text);
dict.Add("GaurdianOccupationDetail", txtGuardianOccupationDetail.Text);
}
MySQLDatabase db = new MySQLDatabase();
long? id = Convert.ToInt64(db.QueryValue("addResponse", dict, true));
if (id == null)
{
Server.Transfer(Statics.Error, true);
}
divSuccessful.Visible = true;
appId.InnerText = id.ToString();
// TODO Send Email with response id
string dirstr = Server.MapPath(Statics.ResponseFolder + id.ToString());
if (!Directory.Exists(dirstr))
{
Directory.CreateDirectory(dirstr);
}
if (fuImage.HasFile)
{
fuImage.SaveAs(dirstr + "/" + fuImage.FileName);
}
if (fuCertificate.HasFile)
{
fuCertificate.SaveAs(dirstr + "/" + fuCertificate.FileName);
}
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (ViewState["YCSId"] == null)
{
ReloadYCSId(null, null);
}
MySQLDatabase db = new MySQLDatabase();
var teacherId = new UserTable <ApplicationUser>(db).GetUserId(User.Identity.Name);
#region Load Mark
int teacherSubjectId = Convert.ToInt32(
db.QueryValue("getTeacherSubjectId",
new Dictionary <string, object>()
{
{ "@TUN", User.Identity.Name },
{ "@ycsid", ViewState["YCSId"] },
{ "@psubjectid", ddlSubject.SelectedValue }
},
true));
var res2 = db.Query("getMarkPortionIdByTSId", new Dictionary <string, object>()
{
{ "@TSId", teacherSubjectId }
}, true);
marks.Controls.Clear();
//ViewState["clicks"] = new List<MarkPortion>();
foreach (var item in res2)
{
MarkPortion markPortion = LoadControl("~/User Control/MarkPortion.ascx") as MarkPortion;
markPortion.PortionName = item["portionname"];
markPortion.MarkPortionId = Convert.ToInt32(item["markportionid"]);
var resMark = db.Query("getMarkByMPIdSIdTid",
new Dictionary <string, object>()
{
{ "@MPId", item["markportionid"] },
{ "@SId", ddlStudent.SelectedValue },
{ "@Tid", ddlTerm.SelectedValue }
}, true);
if (resMark.Count == 0)
{
markPortion.Mark = null;
markPortion.MarkId = null;
}
else
{
markPortion.Mark = Convert.ToInt32(resMark[0]["mark"]);
markPortion.MarkId = Convert.ToInt32(resMark[0]["markid"]);
}
markPortion.SubmitClick += MarkPortion_SubmitClick;
//AsyncPostBackTrigger trigger = new AsyncPostBackTrigger() { ControlID = markPortion.ID, EventName = "SubmitClick" };
//up.Triggers.Add(trigger);
//(ViewState["clicks"] as List<MarkPortion>).Add(markPortion);
marks.Controls.Add(markPortion);
}
#endregion
}
protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
//var teacherId = Context.GetOwinContext().GetUserManager<ApplicationUserManager>().FindByName(User.Identity.Name).Id;
ReloadDDLSection(yearId);
}
protected void ChangeDDLDesignationAsDDLTeacher(object obj, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
ddlDesignation.SelectedValue = db.QueryValue(
"getDesignationIdByTId",
new Dictionary <string, object>()
{
{ "TId", ddlTeacher.SelectedValue }
},
true).ToString();
}
protected void ddlTransact_SelectedIndexChanged(object sender, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var YCSId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yearId },
{ "@pclassid", ddlClass.SelectedValue },
{ "@psectionid", ddlSection.SelectedValue }
}, true);
if (ddlTransact.SelectedValue == "1")
{
db.Execute("addTransactionAccessibility",
new Dictionary <string, object>()
{
{ "@Tid", ddlTeacher.SelectedValue },
{ "@YCSId", YCSId }
}, true);
hInfo.InnerText = ddlTeacher.SelectedItem.Text + " now can access class " + ddlClass.SelectedItem.Text + ", section " + ddlSection.SelectedItem.Text;
hInfo.Attributes["class"] = "text-success";
hInfo.Visible = true;
}
else
{
db.Execute("removeTransactionAccessibility",
new Dictionary <string, object>()
{
{ "@TId", ddlTeacher.SelectedValue },
{ "@YCSId", YCSId }
}, true);
hInfo.InnerText = ddlTeacher.SelectedItem.Text + " now cannot access class " + ddlClass.SelectedItem.Text + ", section " + ddlSection.SelectedItem.Text;
hInfo.Attributes["class"] = "text-danger";
hInfo.Visible = true;
}
}
protected void btnApply_Click(object sender, EventArgs e)
{
try {
MySQLDatabase db = new MySQLDatabase();
var yearId = db.QueryValue("getYearId", new Dictionary <string, object>()
{
{ "@pyear", DateTime.Now.Year }
}, true);
var YCSId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yearId },
{ "@pclassid", Convert.ToInt32(txtClass.Text) },
{ "@psectionid", Convert.ToInt32(txtSection.Text) }
}, true);
if (YCSId == null)
{
info.Visible = true;
success2.Visible = false;
}
else
{
db.Execute("changeStudent",
new Dictionary <string, object>()
{
{ "@SId", ddlStudent.SelectedValue },
{ "@YCSId", YCSId },
{ "@proll", Convert.ToInt32(txtRoll.Text) }
}, true);
success2.Visible = true;
info.Visible = false;
ReloadDDLStudent(yearId);
}
} catch (Exception) {
info.Visible = true;
success2.Visible = false;
}
}
protected void btnCreateGroup_Click(object sender, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
var teacherId = db.QueryValue("getTIdByTUN", new Dictionary <string, object>()
{
{ "@TUN", User.Identity.Name }
}, true);
//string query = "INSERT INTO `group` VALUES(null, '" + teacherId + "', '" + txtGroupName.Text + "';";
db.Execute("addGroup", new Dictionary <string, object>()
{
{ "@TId", teacherId },
{ "@name", txtGroupName.Text }
}, true);
BindDLL();
}
protected void Year_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = Convert.ToInt32(db.QueryValue("countYear", new Dictionary <string, object>()
{
{ "@pyear", txtYear.Text.Trim() }
}, true)) == 0;
if (!args.IsValid)
{
hSuccess.Visible = false;
}
}
protected void btnPay_Click(object sender, EventArgs e)
{
MySQLDatabase db = new MySQLDatabase();
db.Execute("addTransaction",
new Dictionary <string, object>()
{
{ "@SId", ddlStudent.SelectedValue },
{ "@TeaId", db.QueryValue("getTIdByTUN", new Dictionary <string, object>()
{
{ "@TUN", User.Identity.Name }
}, true) },
{ "@TypeId", ddlType.SelectedValue },
{ "@ammount", Convert.ToInt32(txtAmount.Text) }
}, true);
LoadDue(null, null);
}
/// <summary>
/// Returns the role Id given a role name
/// </summary>
/// <param name="roleName">Role's name</param>
/// <returns>Role's Id</returns>
public string GetRoleId(string roleName)
{
string roleId = null;
string commandText = "Select Id from Roles where Name = @name";
Dictionary <string, object> parameters = new Dictionary <string, object>()
{
{ "@name", roleName }
};
var result = _database.QueryValue(commandText, parameters);
if (result != null)
{
return(Convert.ToString(result));
}
return(roleId);
}
private void ReloadDDLCanTransact(object yearId)
{
MySQLDatabase db = new MySQLDatabase();
var YCSId = db.QueryValue("getYearClassSectionId",
new Dictionary <string, object>()
{
{ "@pyearid", yearId },
{ "@pclassid", Convert.ToInt32(ddlClass.SelectedValue) },
{ "@psectionid", Convert.ToInt32(ddlSection.SelectedValue) }
}, true);
ddlTransact.SelectedValue = db.Execute(
"canTransact",
new Dictionary <string, object>()
{
{ "@Tid", Convert.ToInt32(ddlTeacher.SelectedValue) },
{ "@YCSId", YCSId }
}, true).ToString();
}
protected void btnBookDetailNext_Click(object sender, EventArgs e)
{
var data = new MySQLDatabase();
var bookNumber = data.QueryValue("GetBookNumber",
new Dictionary <string, object>
{
{ "@bNum", txtBookNumber.Text }
}, true);
if (bookNumber == null)
{
multiView1.ActiveViewIndex = 2;
LoadViewAuthor();
}
else
{
lblWarnnig.Visible = true;
}
}
protected void Unnamed_Click(object sender, EventArgs e)
{
if (Request.QueryString["postid"] == null)
{
return;
}
MySQLDatabase db = new MySQLDatabase();
int id = Convert.ToInt32(Request.QueryString["postid"]);
var studentId = new UserTable <ApplicationUser>(db).GetUserId(User.Identity.Name);
db.Execute("removeNotificationByNidSId",
new Dictionary <string, object>()
{
{ "@Nid", id },
{ "@SId", Convert.ToInt32(db.QueryValue(
"SELECT id FROM student WHERE userid = '" + studentId + "' LIMIT 1",
null)) }
}, true);
Response.Redirect(Request.Url.AbsolutePath);
}