public static STD_Contact GetSTDContactByStudentID(string StudentID)
{
STD_Contact sTD_Contact = new STD_Contact();
SqlSTD_ContactProvider sqlSTD_ContactProvider = new SqlSTD_ContactProvider();
sTD_Contact = sqlSTD_ContactProvider.GetSTD_ContactByStudentID(StudentID);
return sTD_Contact;
}
public static STD_Contact GetSTD_ContactByContactID(int ContactID)
{
STD_Contact sTD_Contact = new STD_Contact();
SqlSTD_ContactProvider sqlSTD_ContactProvider = new SqlSTD_ContactProvider();
sTD_Contact = sqlSTD_ContactProvider.GetSTD_ContactByContactID(ContactID);
return sTD_Contact;
}
protected void btnContactAdd_Click(object sender, EventArgs e)
{
if (Session["contacts"] == null)
{
List<STD_Contact> contacts = new List<STD_Contact>();
STD_Contact sTD_Contact = new STD_Contact();
// sTD_Contact.ContactID= int.Parse(ddlContactID.SelectedValue);
sTD_Contact.StudentID = Profile.card_id;
sTD_Contact.Name = txtName.Text;
sTD_Contact.CellNo = txtCellNo.Text;
sTD_Contact.Occupation = txtOccupation.Text;
sTD_Contact.OfficeTel = txtOfficeTel.Text;
sTD_Contact.OfficeAddress = txtOfficeAddress.Text;
sTD_Contact.ContactTypeID = int.Parse(ddlContactTypeID.SelectedValue);
sTD_Contact.AddedBy = Profile.card_id;
sTD_Contact.AddedDate = DateTime.Now;
sTD_Contact.ModifiedBy = Profile.card_id;
sTD_Contact.ModifiedDate = DateTime.Now;
sTD_Contact.RowStatusID = 1;
//int resutl = STD_ContactManager.InsertSTD_Contact(STD_Contact);
//add educational background
sTD_Contact.ContactID = contacts.Count;
contacts.Add(sTD_Contact);
Session["contacts"] = contacts;
gvSTD_Contact.DataSource = Session["contacts"];
gvSTD_Contact.DataBind();
}
else
{
STD_Contact sTD_Contact = new STD_Contact();
// sTD_Contact.ContactID= int.Parse(ddlContactID.SelectedValue);
sTD_Contact.StudentID = Profile.card_id;
sTD_Contact.Name = txtName.Text;
sTD_Contact.CellNo = txtCellNo.Text;
sTD_Contact.Occupation = txtOccupation.Text;
sTD_Contact.OfficeTel = txtOfficeTel.Text;
sTD_Contact.OfficeAddress = txtOfficeAddress.Text;
sTD_Contact.ContactTypeID = int.Parse(ddlContactTypeID.SelectedValue);
sTD_Contact.AddedBy = Profile.card_id;
sTD_Contact.AddedDate = DateTime.Now;
sTD_Contact.ModifiedBy = Profile.card_id;
sTD_Contact.ModifiedDate = DateTime.Now;
//int resutl = STD_ContactManager.InsertSTD_Contact(STD_Contact);
//add educational background
sTD_Contact.ContactID = ((List<STD_Contact>)Session["contacts"]).Count;
((List<STD_Contact>)Session["contacts"]).Add(sTD_Contact);
gvSTD_Contact.DataSource = Session["contacts"];
gvSTD_Contact.DataBind();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
STD_Contact sTD_Contact = new STD_Contact ();
sTD_Contact.ContactID= int.Parse(Request.QueryString["ID"].ToString());
sTD_Contact.StudentID= ddlStudentID.SelectedValue;
sTD_Contact.Name= txtName.Text;
sTD_Contact.CellNo= txtCellNo.Text;
sTD_Contact.Occupation= txtOccupation.Text;
sTD_Contact.OfficeTel= txtOfficeTel.Text;
sTD_Contact.OfficeAddress= txtOfficeAddress.Text;
sTD_Contact.ContactTypeID= int.Parse(ddlContactTypeID.SelectedValue);
sTD_Contact.AddedBy= Profile.card_id;
sTD_Contact.AddedDate= DateTime.Now;
sTD_Contact.ModifiedBy= Profile.card_id;
sTD_Contact.ModifiedDate= DateTime.Now;
bool resutl =STD_ContactManager.UpdateSTD_Contact(sTD_Contact);
Response.Redirect("AdminDisplaySTD_Contact.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
STD_Contact sTD_Contact = new STD_Contact();
// sTD_Contact.ContactID= int.Parse(ddlContactID.SelectedValue);
sTD_Contact.StudentID = ddlStudentID.SelectedValue;
sTD_Contact.Name = txtName.Text;
sTD_Contact.CellNo = txtCellNo.Text;
sTD_Contact.Occupation = txtOccupation.Text;
sTD_Contact.OfficeTel = txtOfficeTel.Text;
sTD_Contact.OfficeAddress = txtOfficeAddress.Text;
sTD_Contact.ContactTypeID = int.Parse(ddlContactTypeID.SelectedValue);
sTD_Contact.AddedBy = Profile.card_id;
sTD_Contact.AddedDate = DateTime.Now;
sTD_Contact.ModifiedBy = Profile.card_id;
sTD_Contact.ModifiedDate = DateTime.Now;
sTD_Contact.RowStatusID = 1;
int resutl = STD_ContactManager.InsertSTD_Contact(sTD_Contact);
Response.Redirect("AdminDisplaySTD_Contact.aspx");
}
protected void btnContactUpdate_Click(object sender, EventArgs e)
{
try
{
List<STD_Contact> contacts = new List<STD_Contact>();
contacts = (List<STD_Contact>)Session["contacts"];
STD_Contact sTD_Contact = new STD_Contact();
sTD_Contact.ContactID = int.Parse(hfContactID.Value);
sTD_Contact.StudentID = hfUserID.Value;
sTD_Contact.Name = txtName.Text;
sTD_Contact.CellNo = txtCellNo.Text;
sTD_Contact.Occupation = txtOccupation.Text;
sTD_Contact.OfficeTel = txtOfficeTel.Text;
sTD_Contact.OfficeAddress = txtOfficeAddress.Text;
sTD_Contact.ContactTypeID = int.Parse(ddlContactTypeID.SelectedValue);
sTD_Contact.AddedBy = Profile.card_id;
sTD_Contact.AddedDate = DateTime.Now;
sTD_Contact.ModifiedBy = Profile.card_id;
sTD_Contact.ModifiedDate = DateTime.Now;
contacts[int.Parse(hfContactID.Value)] = sTD_Contact;
Session["contacts"] = contacts;
gvSTD_Contact.DataSource = contacts;
gvSTD_Contact.DataBind();
btnContactAdd.Visible = true;
btnContactUpdate.Visible = false;
}
catch (Exception ex)
{
}
}
private void showSTD_ContactData(int contactID)
{
try
{
if (Session["contacts"] != null)
{
List<STD_Contact> contacts = new List<STD_Contact>();
contacts = (List<STD_Contact>)Session["contacts"];
STD_Contact STD_Contact = new STD_Contact();
STD_Contact = contacts[contactID];
STD_Contact sTD_Contact = new STD_Contact();
sTD_Contact = contacts[contactID];
hfContactID.Value = contactID.ToString();
hfUserID.Value = STD_Contact.StudentID == null ? Profile.card_id : STD_Contact.StudentID;
txtName.Text = sTD_Contact.Name.ToString();
txtCellNo.Text = sTD_Contact.CellNo.ToString();
txtOccupation.Text = sTD_Contact.Occupation.ToString();
txtOfficeTel.Text = sTD_Contact.OfficeTel.ToString();
txtOfficeAddress.Text = sTD_Contact.OfficeAddress.ToString();
ddlContactTypeID.SelectedValue = sTD_Contact.ContactTypeID.ToString();
}
}
catch (Exception ex)
{
}
}
private void loadcontact(string studentID)
{
List<STD_Contact> contacts = new List<STD_Contact>();
DataSet dscontact = STD_ContactManager.GetSTDContactByStudentID(studentID, true);
int i = 0;
foreach (DataRow drcontact in dscontact.Tables[0].Rows)
{
STD_Contact sTD_Contact = new STD_Contact();
sTD_Contact.ContactID = i++;
sTD_Contact.StudentID = drcontact["StudentID"].ToString();
sTD_Contact.Name = drcontact["Name"].ToString();
sTD_Contact.CellNo = drcontact["CellNo"].ToString();
sTD_Contact.Occupation = drcontact["Occupation"].ToString();
sTD_Contact.OfficeTel = drcontact["OfficeTel"].ToString();
sTD_Contact.OfficeAddress = drcontact["OfficeAddress"].ToString();
sTD_Contact.ContactTypeID = int.Parse(drcontact["ContactTypeID"].ToString());
sTD_Contact.AddedBy = drcontact["AddedBy"].ToString();
sTD_Contact.AddedDate = DateTime.Parse(drcontact["AddedDate"].ToString());
sTD_Contact.ModifiedBy = drcontact["ModifiedBy"].ToString();
sTD_Contact.ModifiedDate = DateTime.Parse(drcontact["ModifiedDate"].ToString());
sTD_Contact.RowStatusID = 1;
contacts.Add(sTD_Contact);
}
Session["contacts"] = contacts;
gvSTD_Contact.DataSource = contacts;
gvSTD_Contact.DataBind();
}
public bool UpdateSTD_Contact(STD_Contact sTD_Contact)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_Contact", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ContactID", SqlDbType.Int).Value = sTD_Contact.ContactID;
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_Contact.StudentID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = sTD_Contact.Name;
cmd.Parameters.Add("@CellNo", SqlDbType.NVarChar).Value = sTD_Contact.CellNo;
cmd.Parameters.Add("@Occupation", SqlDbType.NVarChar).Value = sTD_Contact.Occupation;
cmd.Parameters.Add("@OfficeTel", SqlDbType.NVarChar).Value = sTD_Contact.OfficeTel;
cmd.Parameters.Add("@OfficeAddress", SqlDbType.NVarChar).Value = sTD_Contact.OfficeAddress;
cmd.Parameters.Add("@ContactTypeID", SqlDbType.Int).Value = sTD_Contact.ContactTypeID;
cmd.Parameters.Add("@ContactTypeID", SqlDbType.Int).Value = sTD_Contact.ContactTypeID;
cmd.Parameters.Add("@ContactTypeID", SqlDbType.Int).Value = sTD_Contact.ContactTypeID;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = sTD_Contact.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = sTD_Contact.ModifiedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_Contact.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_Contact GetSTD_ContactFromReader(IDataReader reader)
{
try
{
STD_Contact sTD_Contact = new STD_Contact
(
DataAccessObject.IsNULL<int>(reader["ContactID"]),
DataAccessObject.IsNULL<string>(reader["StudentID"].ToString()),
DataAccessObject.IsNULL<string>(reader["Name"]),
DataAccessObject.IsNULL<string>(reader["CellNo"]),
DataAccessObject.IsNULL<string>(reader["Occupation"]),
DataAccessObject.IsNULL<string>(reader["OfficeTel"]),
DataAccessObject.IsNULL<string>(reader["OfficeAddress"]),
DataAccessObject.IsNULL<int>(reader["ContactTypeID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
try
{
sTD_Contact.StudentName = DataAccessObject.IsNULL<string>(reader["StudentName"].ToString());
}
catch (Exception ex)
{
}
return sTD_Contact;
}
catch(Exception ex)
{
return null;
}
}
protected void btnRejectedDate_OnClick(object sender, EventArgs e)
{
int sID = 1;
var studentID = "";
Student student = StudentManager.GetStudentByID("93102412");
#region StudentInfo
try
{
STD_Student sTD_Student = new STD_Student();
MembershipUser myObject = Membership.GetUser("93102412");
studentID = myObject.ProviderUserKey.ToString();
sTD_Student.StudentID = studentID;
sTD_Student.StudentName = student.S_name;
//sTD_Student.PPSizePhoto= "Fileurl";
sTD_Student.PPSizePhoto = "~/Uploads/StudentImages/NoImage.jpg";
sTD_Student.StudentCode = student.S_id;
sTD_Student.PresentAddress = student.Pre_add;
sTD_Student.PermanentAddress = student.Pre_add;
sTD_Student.Telephone = student.Tel;
sTD_Student.Mobile = student.Mob;
sTD_Student.Email = student.Email;
DateTime dateOfBirth = new DateTime(1970, 1, 1, 0, 0, 0, 0);
dateOfBirth = dateOfBirth.AddSeconds(int.Parse(student.Dob));
sTD_Student.DateofBirth = dateOfBirth;
sTD_Student.PassportNo = student.Password;
sTD_Student.Gender = student.Gender;
sTD_Student.MaritualStatusID = 1;
sTD_Student.ReligionID = student.R_id != "" ? int.Parse(student.R_id) : 0;
sTD_Student.SpouseQualification = "";
sTD_Student.EnglishQualification = "";
sTD_Student.IsRegisterWithACCA = false;
sTD_Student.RegistrationDate = DateTime.Parse("1/1/1753");
sTD_Student.RegistrationNo = "";
sTD_Student.AddedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_Student.AddedDate = DateTime.Now;
sTD_Student.ModifiedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_Student.ModifiedDate = DateTime.Now;
sTD_Student.BloodGroup = "";
sTD_Student.IELTS = 0;
sTD_Student.TOFEL = 0;
sTD_Student.ID = sID;
sTD_Student.BatchNo = 12007;
sTD_Student.Year = DateTime.Now.Year;
//sTD_Student.StudentID =
sTD_Student.RowStatusID = 1;
DataSet dsStudent = new DataSet();
dsStudent = STD_StudentManager.InsertSTD_Student(sTD_Student);
sTD_Student.StudentID = dsStudent.Tables[0].Rows[0]["StudentID"].ToString();
sTD_Student.StudentCode = dsStudent.Tables[0].Rows[0]["StudentCode"].ToString();
if (sTD_Student.StudentID != "")
{
//add to educational background to the db
STD_Contact contact = new STD_Contact();
contact.StudentID = sTD_Student.StudentID;
contact.AddedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
contact.ModifiedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
contact.ModifiedDate = DateTime.Now;
contact.Name = student.Father_name;
contact.Occupation = "";
contact.OfficeAddress = "";
contact.OfficeTel = "";
contact.RowStatusID = 1;
contact.CellNo = "";
contact.ContactTypeID = 1;
contact.AddedDate = DateTime.Now;
STD_ContactManager.InsertSTD_Contact(contact);
}
sID++;
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
#endregion
}
protected void btnAddStudent_Click(object sender, EventArgs e)
{
try
{
var studentID = "";
string email = "";
int sID = 1;
List<Student> students = StudentManager.GetAllStudents();
foreach (Student student in students)
{
#region Create User
if (student.Email != "")
{
MembershipCreateStatus result;
try
{
Membership.CreateUser(student.S_id, "123456", student.Email, "a", "a", true, out result);
switch (result)
{
case MembershipCreateStatus.Success:
FormsAuthentication.SetAuthCookie(student.S_id.ToString(), true);
var role = "STD";
MembershipUser myObject = Membership.GetUser(student.S_id.Trim());
studentID = myObject.ProviderUserKey.ToString();
//Assign Role to the Student
if (!Roles.IsUserInRole("Student"))
Roles.AddUserToRole(myObject.UserName, "Student");
lblError.Text = "User successfully created!";
lblError.ForeColor = System.Drawing.Color.Green;
break;
case MembershipCreateStatus.InvalidUserName:
lblError.Text = "The username format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidPassword:
lblError.Text = "The password was invalid: A password cannot be an empty string and must also meet the pasword strength requirements of the configured provider. Please enter a new password.";
break;
case MembershipCreateStatus.InvalidEmail:
lblError.Text = "The email format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidQuestion:
lblError.Text = "The password question format was invalid. Please enter a different question.";
break;
case MembershipCreateStatus.InvalidAnswer:
lblError.Text = "The password answer format was invalid. Please enter a different answer.";
break;
case MembershipCreateStatus.DuplicateUserName:
lblError.Text = "The username is already in use. Please enter a new username.";
break;
case MembershipCreateStatus.DuplicateEmail:
lblError.Text = "The email address is already in use. Please enter a different email address.";
break;
default:
lblError.Text = "An error occurred while creating the user.";
break;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
return;
}
}
else
{
MembershipCreateStatus result;
try
{
email = student.S_id.ToString() + "@cuc.com";
Membership.CreateUser(student.S_id, "123456", email, "a", "a", true, out result);
switch (result)
{
case MembershipCreateStatus.Success:
FormsAuthentication.SetAuthCookie(student.S_id.ToString(), true);
var role = "STD";
MembershipUser myObject = Membership.GetUser(student.S_id.Trim());
studentID = myObject.ProviderUserKey.ToString();
//Assign Role to the Student
if (!Roles.IsUserInRole("Student"))
Roles.AddUserToRole(myObject.UserName, "Student");
lblError.Text = "User successfully created!";
lblError.ForeColor = System.Drawing.Color.Green;
break;
case MembershipCreateStatus.InvalidUserName:
lblError.Text = "The username format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidPassword:
lblError.Text = "The password was invalid: A password cannot be an empty string and must also meet the pasword strength requirements of the configured provider. Please enter a new password.";
break;
case MembershipCreateStatus.InvalidEmail:
lblError.Text = "The email format was invalid. Please enter a different username.";
break;
case MembershipCreateStatus.InvalidQuestion:
lblError.Text = "The password question format was invalid. Please enter a different question.";
break;
case MembershipCreateStatus.InvalidAnswer:
lblError.Text = "The password answer format was invalid. Please enter a different answer.";
break;
case MembershipCreateStatus.DuplicateUserName:
lblError.Text = "The username is already in use. Please enter a new username.";
break;
case MembershipCreateStatus.DuplicateEmail:
lblError.Text = "The email address is already in use. Please enter a different email address.";
break;
default:
lblError.Text = "An error occurred while creating the user.";
break;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
return;
}
}
#endregion
#region StudentInfo
try
{
STD_Student sTD_Student = new STD_Student();
sTD_Student.StudentID = studentID;
sTD_Student.StudentName = student.S_name;
//sTD_Student.PPSizePhoto= "Fileurl";
sTD_Student.PPSizePhoto = "~/Uploads/StudentImages/NoImage.jpg";
sTD_Student.StudentCode = student.S_id;
sTD_Student.PresentAddress = student.Pre_add;
sTD_Student.PermanentAddress = student.Pre_add;
sTD_Student.Telephone = student.Tel;
sTD_Student.Mobile = student.Mob;
sTD_Student.Email = student.Email != "" ? student.Email : email;
DateTime dateOfBirth = new DateTime(1970, 1, 1, 0, 0, 0, 0);
dateOfBirth = dateOfBirth.AddSeconds(int.Parse(student.Dob));
sTD_Student.DateofBirth = dateOfBirth;
sTD_Student.PassportNo = student.Password;
sTD_Student.Gender = student.Gender;
sTD_Student.MaritualStatusID = 1;
sTD_Student.ReligionID = student.R_id != "" ? int.Parse(student.R_id) : 0;
sTD_Student.SpouseQualification = "";
sTD_Student.EnglishQualification = "";
sTD_Student.IsRegisterWithACCA = false;
sTD_Student.RegistrationDate = DateTime.Parse("1/1/1753");
sTD_Student.RegistrationNo = "";
sTD_Student.AddedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_Student.AddedDate = DateTime.Now;
sTD_Student.ModifiedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_Student.ModifiedDate = DateTime.Now;
sTD_Student.BloodGroup = "";
sTD_Student.IELTS = 0;
sTD_Student.TOFEL = 0;
sTD_Student.ID = sID;
sTD_Student.BatchNo = 12007;
sTD_Student.Year = DateTime.Now.Year;
//sTD_Student.StudentID =
sTD_Student.RowStatusID = 1;
DataSet dsStudent = new DataSet();
dsStudent = STD_StudentManager.InsertSTD_Student(sTD_Student);
sTD_Student.StudentID = dsStudent.Tables[0].Rows[0]["StudentID"].ToString();
sTD_Student.StudentCode = dsStudent.Tables[0].Rows[0]["StudentCode"].ToString();
if (sTD_Student.StudentID != "")
{
//add to educational background to the db
STD_Contact contact = new STD_Contact();
contact.StudentID = sTD_Student.StudentID;
contact.AddedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
contact.ModifiedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
contact.ModifiedDate = DateTime.Now;
contact.Name = student.Father_name;
contact.Occupation = "";
contact.OfficeAddress = "";
contact.OfficeTel = "";
contact.RowStatusID = 1;
contact.CellNo = "";
contact.ContactTypeID = 1;
contact.AddedDate = DateTime.Now;
STD_ContactManager.InsertSTD_Contact(contact);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
#endregion
}
}
catch (Exception ex)
{
}
}
public static int InsertSTD_Contact(STD_Contact sTD_Contact)
{
SqlSTD_ContactProvider sqlSTD_ContactProvider = new SqlSTD_ContactProvider();
return sqlSTD_ContactProvider.InsertSTD_Contact(sTD_Contact);
}
public static bool UpdateSTD_Contact(STD_Contact sTD_Contact)
{
SqlSTD_ContactProvider sqlSTD_ContactProvider = new SqlSTD_ContactProvider();
return sqlSTD_ContactProvider.UpdateSTD_Contact(sTD_Contact);
}
private void showSTD_ContactData()
{
STD_Contact sTD_Contact = new STD_Contact ();
sTD_Contact = STD_ContactManager.GetSTD_ContactByContactID(Int32.Parse(Request.QueryString["ID"]));
ddlStudentID.SelectedValue =sTD_Contact.StudentID.ToString();
txtName.Text =sTD_Contact.Name.ToString();
txtCellNo.Text =sTD_Contact.CellNo.ToString();
txtOccupation.Text =sTD_Contact.Occupation.ToString();
txtOfficeTel.Text =sTD_Contact.OfficeTel.ToString();
txtOfficeAddress.Text =sTD_Contact.OfficeAddress.ToString();
ddlContactTypeID.SelectedValue =sTD_Contact.ContactTypeID.ToString();
}
