/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { HIVContractedBLL HIVContractedBLLobj = new HIVContractedBLL(); grdHIVC.DataSource = HIVContractedBLLobj.GetALLHIVContracted(); grdHIVC.DataBind(); }
/// <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 ContractedID = ((Literal)gr.FindControl("litContractedID")).Text; int ContractedID_ = Convert.ToInt32(ContractedID); HIVContractedBLL HIVContractedBLLobj = new HIVContractedBLL(); message = HIVContractedBLLobj.ObsoleteHIVC(ContractedID_, Convert.ToString(chk.Checked), Convert.ToInt32(Session["USER_ID"])); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(false, true); } catch (Exception ex) { throw ex; } }
/// <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 grdHIVC_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["ContractedID"] = e.CommandArgument; Get_HIVC_Details(); SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { HIVContractedBLL HIVContractedBLLobj = new HIVContractedBLL(); string message = string.Empty; message = HIVContractedBLLobj.DeleteHIVC(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } SetUpdateMode(false); clearfields(); BindGrid(false, true); } }
/// <summary> /// to bind the HIV Contracted Data /// </summary> private void BindHIVContracted() { HIVContractedBLL HIVContractedBLLobj = new HIVContractedBLL(); chklsthivcontracted.DataSource = HIVContractedBLLobj.GetALLHIVContracted(); chklsthivcontracted.DataTextField = "ContractedThrough"; chklsthivcontracted.DataValueField = "ContractedID"; chklsthivcontracted.DataBind(); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string message = ""; HIVContractedBLL HIVContractedBLLobj = null; try { HIVContractedBLLobj = new HIVContractedBLL(); HIVContractedBO objHIVContracted = new HIVContractedBO(); if (Convert.ToInt32(ViewState["ContractedID"]) > 0) { objHIVContracted.ContractedThrough = HIVCTextBox.Text.Trim(); objHIVContracted.ContractedID = Convert.ToInt32(ViewState["ContractedID"]); message = HIVContractedBLLobj.EDITHIVC(objHIVContracted); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } SetUpdateMode(false); } else { objHIVContracted.ContractedThrough = HIVCTextBox.Text.Trim(); objHIVContracted.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = HIVContractedBLLobj.insertHIVC(objHIVContracted); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } clearfields(); BindGrid(true, true); } catch (Exception ex) { throw ex; } finally { HIVContractedBLLobj = null; } }
/// <summary> /// get the Grid value into textBox /// </summary> private void Get_HIVC_Details() { HIVContractedBLL HIVContractedBLLobj = new HIVContractedBLL(); int ContractedID = 0; if (ViewState["ContractedID"] != null) { ContractedID = Convert.ToInt32(ViewState["ContractedID"]); } HIVContractedBO objHIVContracted = new HIVContractedBO(); objHIVContracted = HIVContractedBLLobj.GetContractedID(ContractedID); HIVCTextBox.Text = objHIVContracted.ContractedThrough; }