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);
}
}
