/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid(bool addRow, bool deleteRow)
{
OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL();
grdOptionGroup.DataSource = objOptionGroupBLL.GetOptionGroup();
grdOptionGroup.DataBind();
}
/// <summary>
/// To delete Optiongroup from grid
/// </summary>
private void DeleteOptionGroup(string optionGroupID)
{
OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL();
string message = string.Empty;
try
{
message = objOptionGroupBLL.DeleteOptionGroup(Convert.ToInt32(optionGroupID));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data deleted successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
BindGrid(false, true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update Database Make data as Obsoluted
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void IsObsolete_CheckedChanged(Object sender, EventArgs e)
{
string message = string.Empty;
try
{
CheckBox chk = (CheckBox)sender;
GridViewRow gr = (GridViewRow)chk.Parent.Parent;
string OptionGroupID = ((Literal)gr.FindControl("litUserID")).Text;
OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL();
message = objOptionGroupBLL.ObsoleteOptionGroup(Convert.ToInt32(OptionGroupID), Convert.ToString(chk.Checked));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
BindGrid(true, false);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// To fetch Optiongroup from database
/// </summary>
private void GetOptionGroupDetails()
{
OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL();
int OptionGroupID = 0;
if (ViewState["OptionGroupID"] != null)
{
OptionGroupID = Convert.ToInt32(ViewState["OptionGroupID"]);
}
OptionGroupBO objOptionGroupBO = new OptionGroupBO();
objOptionGroupBO = objOptionGroupBLL.GetOptionGroupById(OptionGroupID);
txtOptionGroup.Text = objOptionGroupBO.OptionGroupName;
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string message = "";
OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL();
if (Convert.ToInt32(ViewState["OptionGroupID"]) == 0)
{
try
{
string uID = Session["USER_ID"].ToString();
OptionGroupBO objOptionGroupBO = new OptionGroupBO();
objOptionGroupBO.OptionGroupName = txtOptionGroup.Text.ToString().Trim();
objOptionGroupBO.UserID = Convert.ToInt32(uID);
message = objOptionGroupBLL.InsertOptionGroups(objOptionGroupBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
// txtOptionGroup.Text = "0";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objOptionGroupBLL = null;
}
BindGrid(true, true);
}
//edit the data in the textbox exiting in the Grid
else if (Convert.ToInt32(ViewState["OptionGroupID"]) > 0)
{
try
{
string uID = Session["USER_ID"].ToString();
OptionGroupBO objOptionGroupBO = new OptionGroupBO();
objOptionGroupBO.OptionGroupName = txtOptionGroup.Text.ToString().Trim();
objOptionGroupBO.OptionGroupID = Convert.ToInt32(ViewState["OptionGroupID"]);
objOptionGroupBO.UserID = Convert.ToInt32(uID);
message = objOptionGroupBLL.UpdateOptionGroups(objOptionGroupBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
txtOptionGroup.Text = "0";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objOptionGroupBLL = null;
}
BindGrid(true, true);
SetUpdateMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
ClearData();
}
