public EmployeeView Get(EmployeeEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetEmployeeById", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); SqlDataReader rdr = cmd.ExecuteReader(); EmployeeView content = new EmployeeView(); if (rdr.Read()) { content.Id = Convert.ToInt32(rdr["Id"]); content.EmployeeNo = Convert.ToString(rdr["EmployeeNo"]); content.Firstname = Convert.ToString(rdr["Firstname"]); content.Middlename = Convert.ToString(rdr["Middlename"]); content.Lastname = Convert.ToString(rdr["Lastname"]); content.DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]); content.Nationality = Convert.ToString(rdr["Nationality"]); content.Gender = (GenderEnum)Convert.ToInt32(rdr["Gender"]); content.PersonalNumber = Convert.ToString(rdr["PersonalNumber"]); content.Address = Convert.ToString(rdr["Address"]); content.Country = Convert.ToString(rdr["Country"]); content.City = Convert.ToString(rdr["City"]); content.MobilePhone = Convert.ToString(rdr["MobilePhone"]); content.WorkEmail = Convert.ToString(rdr["WorkEmail"]); content.OtherEmail = Convert.ToString(rdr["OtherEmail"]); content.Bank = Convert.ToString(rdr["Bank"]); content.AccountNumber = Convert.ToString(rdr["AccountNumber"]); content.Job = Convert.ToString(rdr["Job"]); content.OrganizationalUnit = Convert.ToString(rdr["OrganizationalUnit"]); content.MaritalStatus = (MaritalStatusEnum)Convert.ToInt32(rdr["MaritalStatus"]); if (rdr["Image"] != DBNull.Value) { content.Image = (byte[])rdr["Image"]; } content.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); } return content; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void InsertWithReminder(EmployeeEntity employeeEntity, ReminderEntity reminderEntity) { using (SqlConnection connection = DALHelper.CreateSqlDbConnection()) { // Start a local transaction. SqlTransaction sqlTran = connection.BeginTransaction(); // Enlist a command in the current transaction. try { SqlCommand command = connection.CreateCommand(); command.Transaction = sqlTran; new EmployeeMapper().Insert(employeeEntity, command); command = connection.CreateCommand(); command.Transaction = sqlTran; reminderEntity.EntityPK = employeeEntity.Id.ToString(); new ReminderMapper().Insert(reminderEntity, command); // Commit the transaction. sqlTran.Commit(); } catch (Exception) { // Handle the exception if the transaction fails to commit. try { // Attempt to roll back the transaction. sqlTran.Rollback(); } catch (Exception) { // Throws an InvalidOperationException if the connection // is closed or the transaction has already been rolled // back on the server. } } } }
public void Update(EmployeeEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_UpdateEmployee", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); cmd.Parameters.AddWithValue("@EmployeeNo", t.EmployeeNo); cmd.Parameters.AddWithValue("@Firstname", t.Firstname); cmd.Parameters.AddWithValue("@Middlename", t.Middlename); cmd.Parameters.AddWithValue("@Lastname", t.Lastname); cmd.Parameters.AddWithValue("@DateOfBirth", t.DateOfBirth); cmd.Parameters.AddWithValue("@NationalityId", t.NationalityId); cmd.Parameters.AddWithValue("@Gender", t.Gender); cmd.Parameters.AddWithValue("@PersonalNumber", t.PersonalNumber); cmd.Parameters.AddWithValue("@Address", t.Address); cmd.Parameters.AddWithValue("@CountryId", t.CountryId); cmd.Parameters.AddWithValue("@City", t.City); cmd.Parameters.AddWithValue("@MobilePhone", t.MobilePhone); cmd.Parameters.AddWithValue("@WorkEmail", t.WorkEmail); cmd.Parameters.AddWithValue("@OtherEmail", t.OtherEmail); cmd.Parameters.AddWithValue("@BankId", t.BankId); cmd.Parameters.AddWithValue("@AccountNumber", t.AccountNumber); cmd.Parameters.AddWithValue("@MaritalStatus", t.MaritalStatus); if (t.Image != null) { cmd.Parameters.AddWithValue("@Image", t.Image); } cmd.ExecuteScalar(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void Delete(EmployeeEntity t) { throw new NotImplementedException(); }
protected void ProceedButton_Click(object sender, EventArgs e) { EmployeeEntity entity = new EmployeeEntity(); entity.EmployeeNo = EmployeeNoTextBox.Text; entity.Firstname = FirstnameTextBox.Text; entity.Middlename = ""; entity.Middlename = MiddlenameTextBox.Text; entity.Lastname = LastnameTextBox.Text; DateTime dt; if (DateTime.TryParseExact(DateOfBirthTextBox.Text, ConfigurationManager.AppSettings["DateFormat"], null, System.Globalization.DateTimeStyles.None, out dt)) { entity.DateOfBirth = dt; } entity.Gender = (GenderEnum)Convert.ToInt32(GenderDropDownList.SelectedValue); entity.NationalityId = Convert.ToInt32(NationalityDropDownList.SelectedValue); entity.CountryId = Convert.ToInt32(CountryDropDownList.SelectedValue); entity.Address = AddressTextBox.Text; entity.PersonalNumber = PersonalNumberTextBox.Text; entity.WorkEmail = WorkEmailTextBox.Text; entity.MobilePhone = MobilePhoneTextBox.Text; entity.OtherEmail = OtherEmailTextBox.Text; entity.City = CityTextBox.Text; entity.BankId = Convert.ToInt32(BankDropDownList.SelectedValue); entity.AccountNumber = AccountNumberTextBox.Text; entity.MaritalStatus = (MaritalStatusEnum)Convert.ToInt32(MaritalStatusDropDownList.SelectedValue); if (Session["fileContents_"] != null) { byte[] fileContents = (byte[])Session["fileContents_"]; entity.Image = fileContents; } EmployeeMapper mapper = new EmployeeMapper(); try { if (Request.QueryString["action"] == "update" && Request.QueryString["EmployeeId"] != null) { entity.Id = Convert.ToInt32(Request.QueryString["EmployeeId"]); mapper.Update(entity); Response.Redirect("EducationAndExperience.aspx?action=update&EmployeeId=" + entity.Id); } else { ReminderEntity reminder = new ReminderEntity(); reminder.EntityPK = entity.Id.ToString(); reminder.EntityPKType = typeof(int).ToString(); reminder.ReminderType = ReminderEnum.EmployeeNoContract; reminder.Url = "/HRM/HR-Managment/Employee/EmployeesWithoutContract.aspx"; new EmployeeMapperTransaction().InsertWithReminder(entity, reminder); Response.Redirect("EducationAndExperience.aspx?EmployeeId=" + entity.Id); } } catch (SqlException ex) { StringBuilder sb = new StringBuilder(); sb.Append("<script language='javascript'>displayNoty('The Employee No { " + EmployeeNoTextBox.Text + " } has been used, plase write another number');</script>"); // if the script is not already registered if (!Page.ClientScript.IsClientScriptBlockRegistered(Page.GetType(), "HeyPopup")) ClientScript.RegisterClientScriptBlock(Page.GetType(), "HeyPopup", sb.ToString()); } finally { } }