public DesignationBO GetDesignation(int Id) { DBEgine dbEgine = new DBEgine(); DesignationBO des = new DesignationBO(); try { dbEgine.DBOpen(); SqlParameter[] parms = new SqlParameter[1]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "in_DesignationId"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = Id; parms[0] = p1; SqlDataReader drDesig = dbEgine.ExecuteReader("UserManagement.UM_LoadDesignationById", parms); if (drDesig != null && drDesig.HasRows) { while (drDesig.Read()) { des= FillDesignation(drDesig); } // this.ScreenList = LoadUserPermissionByUserId(); } return des; } catch { throw; } finally { dbEgine.DBClose(); } }
private DesignationBO FillDesignation(SqlDataReader dr) { var designationBO = new DesignationBO(); designationBO.DesignationId = dr.GetInt32(dr.GetOrdinal("DesignationId")); designationBO.DesignationName = dr.GetValue(dr.GetOrdinal("Designation")).ToString(); designationBO.Desciption = dr.GetValue(dr.GetOrdinal("Description")).ToString(); designationBO.IsActive = dr.GetBoolean(dr.GetOrdinal("IsActive")); return designationBO; }
public int SaveDesignation(out int Id, DesignationBO obj) { DBEgine dbEgine = new DBEgine(); try { dbEgine.DBOpen(); SqlParameter[] parms = new SqlParameter[4]; SqlParameter designationIdParm = new SqlParameter(); designationIdParm.ParameterName = "DesignationId"; designationIdParm.SqlDbType = SqlDbType.Int; designationIdParm.Direction = ParameterDirection.InputOutput; designationIdParm.Value = obj.DesignationId; parms[0] = designationIdParm; SqlParameter designationParm = new SqlParameter(); designationParm.ParameterName = "Designation"; designationParm.SqlDbType = SqlDbType.NVarChar; designationParm.Direction = ParameterDirection.Input; designationParm.Value = obj.DesignationName; parms[1] = designationParm; SqlParameter descriptionParm = new SqlParameter(); descriptionParm.ParameterName = "Description"; descriptionParm.SqlDbType = SqlDbType.NVarChar; descriptionParm.Direction = ParameterDirection.Input; descriptionParm.Value = obj.Desciption; parms[2] = descriptionParm; SqlParameter IsActiveParm = new SqlParameter(); IsActiveParm.ParameterName = "IsActive"; IsActiveParm.SqlDbType = SqlDbType.Bit; IsActiveParm.Direction = ParameterDirection.Input; IsActiveParm.Value = obj.IsActive; parms[3] = IsActiveParm; dbEgine.ExecNonQueryStoredProc("UM_AddDesignations", parms); Id = Int32.Parse(designationIdParm.Value.ToString()); return Id; } catch { throw; } finally { dbEgine.DBClose(); } }