//Adds selected student in selected university
private void AddAssociatedStudent_Btn_Click(object sender, RoutedEventArgs e)
{
if (ListUniversity.SelectedItem != null && ListStudents.SelectedItem != null)
{
universityManager = new UniversityManager()
{
UniFK = int.Parse(ListUniversity.SelectedValue.ToString()),
StdFK = int.Parse(ListStudents.SelectedValue.ToString())
};
dataContext.UniversityManagers.InsertOnSubmit(universityManager);
dataContext.SubmitChanges();
ShowAssociatedStudents();
}
}
private void FillDDL()
{
UniversityManager _UniversityManager = new UniversityManager();
var obj = _UniversityManager.GetAllUniversity();
if (obj != null)
{
ddlUniversity.DataTextField = "Name";
ddlUniversity.DataValueField = "Id";
ddlUniversity.DataSource = obj.ToList();
}
ddlUniversity.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
var user = AspNetSecurityHelper.currentAppUser;
if (user != null)
{
UniversityManager _UniversityManager = new UniversityManager();
SSAManager _SSAManager = new SSAManager();
DAL.Entity.University obj = _UniversityManager.GetUniversity(queryStringId);
if (obj == null)
{
obj = new DAL.Entity.University();
}
obj.Name = txtUniversity.Text;
int i = 0;
if (obj.Id == 0)
{
obj.CreatedBy = user.UserName;
obj.CreatedDate = DateTime.Now;
obj.DeletedFlag = false;
i = _UniversityManager.AddUniversity(obj);
Operation = (String)GetGlobalResourceObject("HCMResource", "Add");
btnSave.Visible = false;
}
else
{
obj.LastUpdatedBy = user.UserName;
obj.LastUpdatedDate = DateTime.Now;
i = _UniversityManager.UpdateUniversity(obj);
Operation = (String)GetGlobalResourceObject("HCMResource", "Update");
}
if (i != 0)
{
ucAlertMessage.AlertMessage(String.Format((String)GetGlobalResourceObject("HCMResource", "OperationSuccess"), Operation), "", Common.msgType.alertMessageSuccess);
FillData();
}
else
{
ucAlertMessage.AlertMessage(String.Format((String)GetGlobalResourceObject("HCMResource", "OperationError"), Operation), "", Common.msgType.alertMessageDanger);
}
}
else
{
Response.Redirect("/");
}
}
private void FillData()
{
UniversityManager _UniversityManager = new UniversityManager();
SSAManager _SSAManager = new SSAManager();
var user = AspNetSecurityHelper.currentAppUser;
if (user != null)
{
var obj = _UniversityManager.GetAllUniversity();
if (obj != null)
{
GridView1.DataSource = obj.ToList();
}
}
GridView1.DataBind();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string un = AspNetSecurityHelper.GetCurrentUserName;
UniversityManager _UniversityManager = new UniversityManager();
if (e.CommandName == "DeleteUpdate")
{
string Id = e.CommandArgument.ToString();
int id = 0;
if (int.TryParse(Id, out id))
{
bool chk = _UniversityManager.CheckCanDeleted(id);
if (chk)
{
string operation = (String)GetGlobalResourceObject("HCMResource", "Delete");
int i = 0;//_UniversityManager.DeleteUniversity(id);
DAL.Entity.University obj = _UniversityManager.GetUniversity(id);
if (obj != null)
{
obj.DeletedFlag = true;
obj.LastUpdatedBy = un;
obj.LastUpdatedDate = DateTime.Now;
i = _UniversityManager.UpdateUniversity(obj);
}
if (i != 0)
{
ucAlertMessage.AlertMessage(String.Format((String)GetGlobalResourceObject("HCMResource", "OperationSuccess"), operation), "", Common.msgType.alertMessageSuccess);
}
else
{
ucAlertMessage.AlertMessage(String.Format((String)GetGlobalResourceObject("HCMResource", "OperationError"), operation), "", Common.msgType.alertMessageDanger);
}
}
else
{
ucAlertMessage.AlertMessage((String)GetGlobalResourceObject("HCMResource", "CantDelete"), "", Common.msgType.alertMessageDanger);
}
FillData();
}
}
}
private void FillDDL()
{
SSAManager _SSAManager = new SSAManager();
var obj = _SSAManager.GetAllSSA();
if (obj != null)
{
var data = from tbl in obj
select new
{
tbl.Id,
Name = (String.IsNullOrEmpty(tbl.Name) ? "" : tbl.Name + " - ") + tbl.University.Name + (tbl.State != null ? " - " + tbl.State.Name : "") + (tbl.City != null ? " - " + tbl.City.Name : "")
};
ddlSSA.DataTextField = "Name";
ddlSSA.DataValueField = "Id";
ddlSSA.DataSource = data.ToList();
}
ddlSSA.DataBind();
StateManager _StateManager = new StateManager();
var state = _StateManager.GetAllState();
if (state != null)
{
ddlState.DataTextField = "Name";
ddlState.DataValueField = "Id";
ddlState.DataSource = state.ToList();
}
ddlState.DataBind();
UniversityManager _UniversityManager = new UniversityManager();
var uni = _UniversityManager.GetAllUniversity();
if (uni != null)
{
ddlUniversity.DataTextField = "Name";
ddlUniversity.DataValueField = "Id";
ddlUniversity.DataSource = uni.ToList();
}
ddlUniversity.DataBind();
}
private void FillData()
{
if (!String.IsNullOrEmpty(queryStringIdStr))
{
UniversityManager _UniversityManager = new UniversityManager();
var obj = _UniversityManager.GetUniversity(queryStringId);
if (obj != null)
{
txtUniversity.Text = obj.Name;
Operation = (String)GetGlobalResourceObject("HCMResource", "UpdateExisting");
}
else
{
Operation = (String)GetGlobalResourceObject("HCMResource", "AddNew");
}
}
else
{
Operation = (String)GetGlobalResourceObject("HCMResource", "AddNew");
}
}
static void Main(string[] args)
{
int[] numbers = new int[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
University university1 = new University(1, "Yale");
University university2 = new University(2, "Standford");
Student student1 = new Student(1, "Tim", "male", 18, 1);
Student student2 = new Student(2, "Mike", "male", 18, 2);
Student student3 = new Student(3, "Kim", "male", 28, 1);
Student student4 = new Student(4, "Shawn", "female", 23, 2);
Student student5 = new Student(5, "Bob", "male", 23, 1);
Student student6 = new Student(6, "Billy", "male", 25, 2);
Student student7 = new Student(7, "Shara", "female", 18, 1);
Student student8 = new Student(8, "Nick", "male", 17, 2);
Student student9 = new Student(9, "Nicky", "female", 40, 1);
Student student10 = new Student(10, "Quan", "male", 33, 2);
UniversityManager universityManager = new UniversityManager();
// Managing list of universities
universityManager.unerversities.Add(university1);
universityManager.unerversities.Add(university2);
// Managing list of students
universityManager.students.Add(student1);
universityManager.students.Add(student2);
universityManager.students.Add(student3);
universityManager.students.Add(student4);
universityManager.students.Add(student5);
universityManager.students.Add(student6);
universityManager.students.Add(student7);
universityManager.students.Add(student8);
universityManager.students.Add(student9);
universityManager.students.Add(student10);
universityManager.GetAges(20, 25);
}
private void Awake()
{
_universityManager = FindObjectOfType <UniversityManager>();
_baseActivitySlot = gameObject.GetComponentInParent <BaseActivitySlot>();
}
