/// <summary> /// To set Data to Dropdowns Inside repeater /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rptCriteria_ItemDataBound(object sender, RepeaterItemEventArgs e) { DropDownList rpt_ddlCriteriaSCore = e.Item.FindControl("ddlCriteriaScore") as DropDownList; HiddenField hdnCriteriaId = (HiddenField)e.Item.FindControl("hdnCriteriaId"); try { if (lstRouteCriteriaScore == null) { lstRouteCriteriaScore = LoadCriteriaScore(); } rpt_ddlCriteriaSCore.DataSource = lstRouteCriteriaScore; rpt_ddlCriteriaSCore.DataTextField = "ScoreDescription"; rpt_ddlCriteriaSCore.DataValueField = "scoreid"; rpt_ddlCriteriaSCore.DataBind(); rpt_ddlCriteriaSCore.SelectedIndex = 0; RouteScoreBO oRouteScoreBO = (new ProjectBLL()).GetRouteScore(Convert.ToInt32(ViewState["ROUTE_ID"]), Convert.ToInt32(hdnCriteriaId.Value)); if (oRouteScoreBO != null) { if (rpt_ddlCriteriaSCore.Items.FindByValue(oRouteScoreBO.ScoreId.ToString()) != null) { rpt_ddlCriteriaSCore.ClearSelection(); rpt_ddlCriteriaSCore.Items.FindByValue(oRouteScoreBO.ScoreId.ToString()).Selected = true; } } } catch (Exception ex) { throw ex; } }
//public ProjectRouteList GetProjectRoute_ByProjectId(int ProjectId) //{ // return (new ProjectDAL()).GetProjectRoute_ByProjectId(ProjectId); //} /// <summary> /// To Save Route Score /// </summary> /// <param name="oRouteScore"></param> /// <returns></returns> public int SaveRouteScore(RouteScoreBO oRouteScore) { return((new ProjectDAL()).SaveRouteScore(oRouteScore)); }
/// <summary> /// To save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { RouteScoreBO oRouteScore = new RouteScoreBO(); ProjectBLL oProjectBLL = new ProjectBLL(); int TotalScore = 0; if (Session["USER_ID"] != null) { oRouteScore.UserId = Convert.ToInt32(Session["USER_ID"]); } oRouteScore.IsDeleted = "False"; //Repeat Through Routes for (int k = 0; k < rptRoute.Controls.Count; k++) { Repeater rptFactors = rptRoute.Controls[k].FindControl("rptFactors") as Repeater; //RootID Assignment if (rptRoute.Controls[k].FindControl("hdnRouteId") is HiddenField) { oRouteScore.RouteId = Convert.ToInt32((rptRoute.Controls[k].FindControl("hdnRouteId") as HiddenField).Value); } //Repeat Through Factors for (int i = 0; i < rptFactors.Controls.Count; i++) { if (rptFactors.Controls[i].FindControl("rptCriteria") is Repeater) { Repeater rptCriteriaX = rptFactors.Controls[i].FindControl("rptCriteria") as Repeater; int SumCriteria = 0; for (int j = 0; j < rptCriteriaX.Controls.Count; j++) { if (rptCriteriaX.Controls[j].FindControl("ddlCriteriaScore") is DropDownList) { DropDownList ddlCriteriaScoreX = rptCriteriaX.Controls[j].FindControl("ddlCriteriaScore") as DropDownList; //ScoreId Assignment oRouteScore.ScoreId = Convert.ToInt32(ddlCriteriaScoreX.SelectedValue.ToString()); SumCriteria += Convert.ToInt32(ddlCriteriaScoreX.SelectedValue.ToString()); //Finding Sum of Criteria } if (rptCriteriaX.Controls[j].FindControl("hdnCriteriaId") is HiddenField) { HiddenField hdnCriteriaIdX = rptCriteriaX.Controls[j].FindControl("hdnCriteriaId") as HiddenField; //CriteriaId Assignment oRouteScore.CriteriaId = Convert.ToInt32(hdnCriteriaIdX.Value.ToString()); } if (oRouteScore.CriteriaId > 0) { oProjectBLL.SaveRouteScore(oRouteScore); //Storing Data } } } } if (rptRoute.Controls[k].FindControl("txtRouteScore") is TextBox) { int Scores = 0; int RouteId = 0; if (rptRoute.Controls[k].FindControl("txtRouteScore") is TextBox) { TextBox txtRouteScore = (rptRoute.Controls[k].FindControl("txtRouteScore") as TextBox); if (!string.IsNullOrEmpty(txtRouteScore.Text)) { Scores = Convert.ToInt32(txtRouteScore.Text); } } if (rptRoute.Controls[k].FindControl("hdnRouteId") is HiddenField) { HiddenField hdnRouteId = (rptRoute.Controls[k].FindControl("hdnRouteId") as HiddenField); if (!string.IsNullOrEmpty(hdnRouteId.Value)) { RouteId = Convert.ToInt32(hdnRouteId.Value); } } TotalScore = Convert.ToInt32(Scores); RouteBO oRouteBO = new RouteBO(); oRouteBO.TotalRouteScore = TotalScore; oRouteBO.RouteID = RouteId; oProjectBLL.SaveToalRouteScore(oRouteBO); } } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Data saved successfully');", true); ClientScript.RegisterStartupScript(this.GetType(), "RouteTotalScore", "AfterSave(1);", true); //ClearDetails(); //LoadRoutes(); }