//Remove Role From DesignationMaster public int RemoveDesignation(Models.DesignationAttribute designation) { List <SqlParameter> sqlparam = new List <SqlParameter>(); sqlparam.Add(new SqlParameter("@Desig_id", designation.DesigId)); sqlparam.Add(new SqlParameter("@CreatedBy", designation.UpdatedBy)); sqlparam.Add(new SqlParameter("@Operation", 2)); SqlParameter IsSuccessful = new SqlParameter("@IsSuccessful", SqlDbType.Int) { Direction = ParameterDirection.Output }; sqlparam.Add(IsSuccessful); // 2 is to Remove Role int i = DAL.SQLHelp.ExecuteNonQuery("Usp_UpdateDesignation", sqlparam); int value = Convert.ToInt32(IsSuccessful.Value.ToString()); return(value); }
//Update Designation From Temp Table public int UpdateTempDesignation(Models.DesignationAttribute designation) { List <SqlParameter> sqlparam = new List <SqlParameter>(); sqlparam.Add(new SqlParameter("@TempDesignId", designation.TempDesigId)); sqlparam.Add(new SqlParameter("@UserId", designation.CreatedBy)); sqlparam.Add(new SqlParameter("@Operation", designation.Operation)); SqlParameter IsSuccessful = new SqlParameter("@IsSuccessful", SqlDbType.Int) { Direction = ParameterDirection.Output }; sqlparam.Add(IsSuccessful); // 1 is to Approve Designation // 2 is to Reject Designation int i = DAL.SQLHelp.ExecuteNonQuery("Usp_ApproveOrRejectDesignation", sqlparam); int value = Convert.ToInt32(IsSuccessful.Value.ToString()); return(value); }
// Add Role public int AddDesignation(Models.DesignationAttribute designation) { int count = 0; List <SqlParameter> sqldesignation = new List <SqlParameter>(); sqldesignation.Add(new SqlParameter("@DesignationName", designation.DesignationName)); sqldesignation.Add(new SqlParameter("@Role_Id", designation.RoleId)); sqldesignation.Add(new SqlParameter("@Dept_Id", designation.DeptId)); sqldesignation.Add(new SqlParameter("@CreatedBy", designation.CreatedBy)); sqldesignation.Add(new SqlParameter("@Operation", 1)); SqlParameter IsSuccessful = new SqlParameter("@IsSuccessful", SqlDbType.Int) { Direction = ParameterDirection.Output }; sqldesignation.Add(IsSuccessful); //Add Desigantion In int i = DAL.SQLHelp.ExecuteNonQuery("Usp_UpdateDesignation", sqldesignation); count = Convert.ToInt32(IsSuccessful.Value.ToString()); return(count); }