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(); }