public static HR_Designation GetHR_DesignationByDesignationID(int DesignationID) { HR_Designation hR_Designation = new HR_Designation(); SqlHR_DesignationProvider sqlHR_DesignationProvider = new SqlHR_DesignationProvider(); hR_Designation = sqlHR_DesignationProvider.GetHR_DesignationByDesignationID(DesignationID); return hR_Designation; }
public ActionResult DeleteConfirmed(short id) { try { HR_Designation hr_designation = db.HR_Designation.Find(id); db.HR_Designation.Remove(hr_designation); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception) { throw; } }
protected void btnUpdate_Click(object sender, EventArgs e) { HR_Designation hR_Designation = new HR_Designation(); hR_Designation.DesignationID = int.Parse(Request.QueryString["ID"].ToString()); hR_Designation.DesignationName = txtDesignationName.Text; hR_Designation.DepartmentID = int.Parse(ddlDepartmentID.SelectedValue); hR_Designation.Supervisor = txtSupervisor.Text; hR_Designation.JobResponsibility = txtJobResponsibility.Text; string userID = Profile.card_id; hR_Designation.AddedBy = userID; hR_Designation.AddedDate = DateTime.Now; hR_Designation.ModifiedBy = userID; hR_Designation.ModifiedDate = DateTime.Now; bool resutl = HR_DesignationManager.UpdateHR_Designation(hR_Designation); Response.Redirect("AdminDisplayHR_Designation.aspx"); }
public ActionResult Create([Bind(Include = "DesgID,DesignationName,OCommonName")] HR_Designation hr_designation) { try { if (ModelState.IsValid) { db.HR_Designation.Add(hr_designation); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hr_designation)); } catch (Exception) { throw; } }
public ActionResult Edit([Bind(Include = "DesgID,DesignationName,OCommonName")] HR_Designation hr_designation) { try { if (ModelState.IsValid) { db.Entry(hr_designation).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp; AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Designation), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)hr_designation.DesgID); return(RedirectToAction("Index")); } return(View(hr_designation)); } catch (Exception) { throw; } }
// GET: /HumanResource/Designation/Details/5 public ActionResult Details(short?id) { try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HR_Designation hr_designation = db.HR_Designation.Find(id); if (hr_designation == null) { return(HttpNotFound()); } return(View(hr_designation)); } catch (Exception) { throw; } }
public static int InsertHR_Designation(HR_Designation hR_Designation) { SqlHR_DesignationProvider sqlHR_DesignationProvider = new SqlHR_DesignationProvider(); return sqlHR_DesignationProvider.InsertHR_Designation(hR_Designation); }
public static bool UpdateHR_Designation(HR_Designation hR_Designation) { SqlHR_DesignationProvider sqlHR_DesignationProvider = new SqlHR_DesignationProvider(); return sqlHR_DesignationProvider.UpdateHR_Designation(hR_Designation); }
private void showHR_DesignationData() { HR_Designation hR_Designation = new HR_Designation(); hR_Designation = HR_DesignationManager.GetHR_DesignationByDesignationID(Int32.Parse(Request.QueryString["ID"])); txtDesignationName.Text = hR_Designation.DesignationName.ToString(); ddlDepartmentID.SelectedValue = hR_Designation.DepartmentID.ToString(); txtSupervisor.Text = hR_Designation.Supervisor.ToString(); txtJobResponsibility.Text = hR_Designation.JobResponsibility.ToString(); }
public bool UpdateHR_Designation(HR_Designation hR_Designation) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_Designation", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DesignationID", SqlDbType.Int).Value = hR_Designation.DesignationID; cmd.Parameters.Add("@DesignationName", SqlDbType.NVarChar).Value = hR_Designation.DesignationName; cmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = hR_Designation.DepartmentID; cmd.Parameters.Add("@Supervisor", SqlDbType.NVarChar).Value = hR_Designation.Supervisor; cmd.Parameters.Add("@JobResponsibility", SqlDbType.NVarChar).Value = hR_Designation.JobResponsibility; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_Designation.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_Designation.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_Designation GetHR_DesignationFromReader(IDataReader reader) { try { HR_Designation hR_Designation = new HR_Designation ( DataAccessObject.IsNULL<int>(reader["DesignationID"]), DataAccessObject.IsNULL<string>(reader["DesignationName"]), DataAccessObject.IsNULL<int>(reader["DepartmentID"]), DataAccessObject.IsNULL<string>(reader["Supervisor"]), DataAccessObject.IsNULL<string>(reader["JobResponsibility"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_Designation; } catch(Exception ex) { return null; } }