protected void btnAdd_Click(object sender, EventArgs e) { if (isValid(0)) { SuggestionsTableAdapters.SuggestionTableAdapter tableAdapter = new SuggestionsTableAdapters.SuggestionTableAdapter(); tableAdapter.Insert(loggedInUserCoId, int.Parse(ddlDepartment.SelectedValue),false, int.Parse(ddlCategory.SelectedValue),tbName.Text,suggestionType,cbDefault.Checked); BindRepeater(); SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); } //lbl }
public void BindGrids() { try { SuggestionsTableAdapters.SuggestionTableAdapter ta = new SuggestionsTableAdapters.SuggestionTableAdapter(); gv1.DataSource = ta.GetSuggestionsByType(int.Parse(ddlDepartment1.SelectedValue), int.Parse(ddlCompany1.SelectedValue),suggestionType); gv1.DataBind(); gv2.DataSource = ta.GetSuggestionsByType(int.Parse(ddlDepartment2.SelectedValue), int.Parse(ddlCompany2.SelectedValue),suggestionType); gv2.DataBind(); HideTransferButtons(); } catch { //this is needed as some time the ddls are not set. } }
public override void DataBind() { SuggestionsTableAdapters.SuggestionTableAdapter suggestionTA = new SuggestionsTableAdapters.SuggestionTableAdapter(); IEnumerator iEnum = suggestionTA.GetSuggestionsByType(loggedInUserCoId, departmentId, suggestionType).GetEnumerator(); while (iEnum.MoveNext()) { Suggestions.SuggestionEntityRow suggestion = (Suggestions.SuggestionEntityRow)iEnum.Current; if (isPresent(suggestion.suggestion_text) == false) { if (categories.ContainsKey(suggestion.category_name) == false) { categories.Add(suggestion.category_name, new List<Suggestions.SuggestionEntityRow>()); } List<Suggestions.SuggestionEntityRow> hazards = categories[suggestion.category_name]; hazards.Add(suggestion); } } rptSuggestions.DataSource = categories.Keys; rptSuggestions.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { string[] idList = Request["idOrdering"].Split(','); if (idList != null) { //-i because we have an extra comma at the end for (int i = 0; i < idList.Length - 1; i++) { Suggestions.SuggestionEntityRow dataRow = getSuggestion(int.Parse(idList[i])); if (dataRow != null) { SuggestionsTableAdapters.SuggestionTableAdapter tableAdapter = new SuggestionsTableAdapters.SuggestionTableAdapter(); dataRow.index_seq = i + 1; tableAdapter.Update(dataRow); } } } SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); BindRepeater(); }
protected void btnUpate_Click(object sender, EventArgs e) { int id = int.Parse(hfSuggestionId.Value); if (isValid(id)) { Suggestions.SuggestionEntityRow dataRow = getSuggestion(id); if (dataRow != null) { SuggestionsTableAdapters.SuggestionTableAdapter tableAdapter = new SuggestionsTableAdapters.SuggestionTableAdapter(); dataRow.suggestion_text = tbName.Text; dataRow.flg_default = cbDefault.Checked; dataRow.dept_id = int.Parse(ddlDepartment.SelectedValue); dataRow.category_id = int.Parse(ddlCategory.SelectedValue); tableAdapter.Update(dataRow); BindRepeater(); SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); } btnAdd.Visible = true; btnUpate.Visible = false; tbName.Text = ""; } }
private bool isValid(int id) { SuggestionsTableAdapters.SuggestionTableAdapter tableAdapter = new SuggestionsTableAdapters.SuggestionTableAdapter(); IEnumerator iEnumerator = tableAdapter.GetSuggestionByName(loggedInUserCoId,int.Parse(ddlDepartment.SelectedValue),suggestionType, tbName.Text,id).GetEnumerator(); if (iEnumerator.MoveNext()) { SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS); return false; } return true; }
private Suggestions.SuggestionEntityRow getSuggestion(int suggestionId) { Suggestions.SuggestionEntityRow dataRow = null; SuggestionsTableAdapters.SuggestionTableAdapter tableAdapter = new SuggestionsTableAdapters.SuggestionTableAdapter(); IEnumerator iEnumerator = tableAdapter.GetSuggestionById(suggestionId).GetEnumerator(); if (iEnumerator.MoveNext()) { dataRow = (Suggestions.SuggestionEntityRow)iEnumerator.Current; } return dataRow; }
private void BindRepeater() { SuggestionsTableAdapters.SuggestionTableAdapter suggestionTA = new SuggestionsTableAdapters.SuggestionTableAdapter(); repeater.DataSource = suggestionTA.GetSuggestionsByType(loggedInUserCoId, int.Parse(ddlDepartment.SelectedValue), suggestionType); repeater.DataBind(); }
protected void repeater_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("Edit")) { Suggestions.SuggestionEntityRow dataRow = getSuggestion(int.Parse(e.CommandArgument.ToString())); if (dataRow != null) { tbName.Text = dataRow.suggestion_text; ddlDepartment.SelectedValue = dataRow.dept_id.ToString(); ddlCategory.SelectedValue = dataRow.category_id.ToString(); cbDefault.Checked = dataRow.flg_default; btnAdd.Visible = false; btnUpate.Visible = true; hfSuggestionId.Value = e.CommandArgument.ToString(); } } else if (e.CommandName.Equals("Delete")) { SuggestionsTableAdapters.SuggestionTableAdapter tableAdapter = new SuggestionsTableAdapters.SuggestionTableAdapter(); tableAdapter.Delete(int.Parse(e.CommandArgument.ToString())); BindRepeater(); SetInfoMessage(WebConstants.Messages.Information.RECORD_DELETED); } }