public static object GetMaxMinOfGrade(string grade, string commodityFactorGroupId, string classId) { try { DataTable dt = GradingModel.GetCommodityGrade(new Guid(commodityFactorGroupId), new Guid(classId)); if (dt.Rows.Count > 0) { DataRow[] dr = dt.Select(" Grade = '" + grade + "'"); if (dr.Count() > 0) { dr[0]["MinimumTotalValue"].ToString(); return(new { Max = dr[0]["MaximumTotalValue"].ToString(), Min = dr[0]["MinimumTotalValue"].ToString() }); } else { return(null); } } else { return(null); } } catch { return(null); } }
private void FillCommodityGrade(DropDownList ddl, Guid commodityFactorGroupId, Guid classId) { ddl.DataSource = null; ddl.Items.Clear(); ddl.Items.Add(new ListItem("- - Please Select - -", "")); DataTable dt = GradingModel.GetCommodityGrade(commodityFactorGroupId, classId); ViewState.Add("GradeList", dt); ddl.DataSource = dt; ddl.DataTextField = "Grade"; ddl.DataValueField = "Grade"; ddl.DataBind(); }