/// <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 CropDiaMeterID = ((Literal)gr.FindControl("litUserID")).Text; CropDiameterBLL objCropDiameterBLL = new CropDiameterBLL(); message = objCropDiameterBLL.ObsoleteCropDiameter(Convert.ToInt32(CropDiaMeterID), 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(); } catch (Exception ex) { throw ex; } }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid() { CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); grdCropDiameter.DataSource = CropDiameterBLLobj.GetCropDiameter(); grdCropDiameter.DataBind(); }
/// <summary> /// To fetch details and assign to textbox /// </summary> private void GetCropDiameterDetails() { CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); int CROPDIAMETERID = 0; if (ViewState["CropDiaMeterID"] != null) { CROPDIAMETERID = Convert.ToInt32(ViewState["CropDiaMeterID"]); } CropDiameterBO CropDiameterObj = new CropDiameterBO(); CropDiameterObj = CropDiameterBLLobj.GetCropDiameterById(CROPDIAMETERID); CropDiameterTextBox.Text = CropDiameterObj.CROPDIAMETER; CropDiameterIDTextBox.Text = CropDiameterObj.CROPDIAMETERID.ToString(); }
/// <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 grdCropDiameter_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["CropDiaMeterID"] = e.CommandArgument; GetCropDiameterDetails(); SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); string message = string.Empty; try { message = CropDiameterBLLobj.DeleteCropDiameter(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); } ClearData(); } catch (Exception ex) { throw ex; } SetUpdateMode(false); BindGrid(); } }
/// <summary> /// To save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string message = ""; int count = 0; if (CropDiameterIDTextBox.Text.ToString().Trim() == "0" || CropDiameterIDTextBox.Text.ToString().Trim() == string.Empty) { CropDiameterBLL CropDiameterBLLOBJ = new CropDiameterBLL(); try { string uID = Session["USER_ID"].ToString(); CropDiameterBO objCropDiameter = new CropDiameterBO(); objCropDiameter.CROPDIAMETER = CropDiameterTextBox.Text.ToString().Trim(); objCropDiameter.UserID = Convert.ToInt32(uID); CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); message = CropDiameterBLLobj.InsertCropDiameter(objCropDiameter); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } CropDiameterIDTextBox.Text = "0"; if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { CropDiameterBLLOBJ = null; } BindGrid(); } //edit the data in the textbox exiting in the Grid else if (CropDiameterIDTextBox.Text.ToString().Trim() != string.Empty) { ConcernBLL concernBLLOBJ = new ConcernBLL(); try { string uID = Session["USER_ID"].ToString(); CropDiameterBO objCropDiameter = new CropDiameterBO(); objCropDiameter.CROPDIAMETER = CropDiameterTextBox.Text.ToString().Trim(); objCropDiameter.CROPDIAMETERID = Convert.ToInt32(CropDiameterIDTextBox.Text.ToString().Trim()); objCropDiameter.UserID = Convert.ToInt32(uID); CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL(); message = CropDiameterBLLobj.EDITCropDiameter(objCropDiameter); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; BindGrid(); SetUpdateMode(false); } } catch (Exception ex) { throw ex; } finally { concernBLLOBJ = null; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearData(); }