/// <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 TRIBEID = ((Literal)gr.FindControl("litTRIBEID")).Text; TribeBLL TribeBLLObj = new TribeBLL(); message = TribeBLLObj.Obsoletetribe(Convert.ToInt32(TRIBEID), Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } BindGrid(false, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> private void BindGrid(bool addRow, bool deleteRow) { try { TribeBLL TribeBLLObj = new TribeBLL(); gvTribe.DataSource = TribeBLLObj.FetchALLTribeList(); gvTribe.DataBind(); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get details from Database /// </summary> private void GetTribeDetails() { TribeBLL TribeBLLObj = new TribeBLL(); int TribeID = 0; if (ViewState["TRIBEID"] != null) { TribeID = Convert.ToInt32(ViewState["TRIBEID"]); } TribeBO TribeBOObj = new TribeBO(); TribeBOObj = TribeBLLObj.GetTribeById(TribeID); txtTribe.Text = TribeBOObj.TribeName; }
/// <summary> /// Edit Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void EditTribeDetails() { TribeBLL TribeBLLObj = new TribeBLL(); string message = ""; try { TribeBO TribeBOObj = new TribeBO(); if (ViewState["TRIBEID"] != null) { TribeBOObj.TribeID = Convert.ToInt32(ViewState["TRIBEID"].ToString()); } string uID = string.Empty; uID = Session["USER_ID"].ToString(); TribeBOObj.TribeName = txtTribe.Text.ToString().Trim(); TribeBOObj.UpdatedBy = Convert.ToInt32(uID); message = TribeBLLObj.EDITTribe(TribeBOObj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } txtTribe.Text = string.Empty; SetUpdateMode(false); BindGrid(true, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { TribeBLLObj = null; } }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SaveTribeDetails() { TribeBOObj = new TribeBO(); string message = ""; string Tribe = string.Empty; string uID = string.Empty; uID = Session["USER_ID"].ToString(); Tribe = txtTribe.Text.ToString().Trim(); TribeBOObj.TribeName = Tribe; TribeBOObj.CreatedBy = Convert.ToInt32(uID); TribeBLLObj = new TribeBLL(); try { message = TribeBLLObj.InsertIntoTribeMaster(TribeBOObj); txtTribe.Text = string.Empty; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(true, true); } catch (Exception ee) { throw ee; } finally { TribeBLLObj = null; } }
/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvTribe_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["TRIBEID"] = e.CommandArgument; GetTribeDetails(); SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { // ViewState["TRIBEID"] = e.CommandArgument; TribeBLL TribeBLLObj = new TribeBLL(); message = TribeBLLObj.DeleteTribeById(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } SetUpdateMode(false); BindGrid(false, true); ClearData(); } else if (e.CommandName == "ViewROW") { ViewState["TRIBEID"] = e.CommandArgument; getClanDetails(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }