/// <summary> /// To fetch all details by ID /// </summary> /// <param name="graveID"></param> /// <returns></returns> public GraveFinishBO GetGraveByID(int graveID) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_GRAVEFINISHBYID"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("GRV_FINISHID", graveID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GraveFinishBO objGF = null; GraveFinishList objGFList = new GraveFinishList(); while (dr.Read()) { objGF = new GraveFinishBO(); objGF.GraveFinishID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRV_FINISHID")))); objGF.GraveFinishType = dr.GetValue(dr.GetOrdinal("GRV_FINISHTYPE")).ToString(); objGF.isDeleted = dr.GetValue(dr.GetOrdinal("isDeleted")).ToString(); objGFList.Add(objGF); } dr.Close(); return(objGF); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { GraveFinishBO objGF = new GraveFinishBO(); GraveFinishBLL objGFBLL = new GraveFinishBLL(); grdGraveFinish.DataSource = objGFBLL.GetAllGraveFinish(); grdGraveFinish.DataBind(); }
/// <summary> /// to update data /// </summary> /// <param name="objGF"></param> /// <returns></returns> public string UpdateGrave(GraveFinishBO objGF) { string returnResult; cnn = new OracleConnection(con); proc = "USP_MST_UPD_GRAVEFINISH"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("GRV_FINISHID", objGF.GraveFinishID); cmd.Parameters.Add("GRV_FINISHTYPE", objGF.GraveFinishType); cmd.Parameters.Add("UPDATEDBY", objGF.CreatedBy); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { returnResult = cmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } return(returnResult); //OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); //int result = 0; //{ // OracleCommand myCommand; // myCommand = new OracleCommand("USP_MST_UPD_GRAVEFINISH", con); // myCommand.Connection = con; // myCommand.CommandType = CommandType.StoredProcedure; // myCommand.Parameters.Add("GRV_FINISHID", objGF.GraveFinishID); // if (string.IsNullOrEmpty(objGF.GraveFinishType) == true) // { // myCommand.Parameters.Add("GRV_FINISHTYPE", OracleDbType.Varchar2, 250).Value = " "; // } // else // { // myCommand.Parameters.Add("GRV_FINISHTYPE", OracleDbType.Varchar2, 250).Value = objGF.GraveFinishType; // } // myCommand.Parameters.Add("UPDATEDBY", OracleDbType.Int64, 5).Value = 1; // con.Open(); // result = myCommand.ExecuteNonQuery(); // con.Close(); // } //return result; }
/// <summary> /// to save data /// </summary> /// <param name="objGF"></param> /// <returns></returns> public string AddGrave(GraveFinishBO objGF) { string returnResult; cnn = new OracleConnection(con); proc = "USP_MST_INS_GRAVEFINISH"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("GRV_FINISHTYPE", objGF.GraveFinishType); cmd.Parameters.Add("ISDELETEDIN", objGF.IsDeleted); cmd.Parameters.Add("CREATEDBY", objGF.CreatedBy); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { returnResult = cmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } return(returnResult); //OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); //int result = 0; //{ // OracleCommand myCommand; // myCommand = new OracleCommand("USP_MST_INS_GRAVEFINISH", con); // myCommand.Connection = con; // myCommand.CommandType = CommandType.StoredProcedure; // myCommand.Parameters.Add("@GRV_FINISHTYPE", OracleDbType.Varchar2, 25).Value = objGF.GraveFinishType; // myCommand.Parameters.Add("@ISDELETEDIN", OracleDbType.Varchar2, 5).Value = "False"; // myCommand.Parameters.Add("@CREATEDBY", OracleDbType.Int64, 5).Value = 1; // con.Open(); // result = myCommand.ExecuteNonQuery(); // con.Close(); //} ////return objRelr; }
/// <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 grdGraveFinish_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["GRV_FINISHID"] = e.CommandArgument; GraveFinishBO objGF = new GraveFinishBO(); GraveFinishBLL objGFBLL = new GraveFinishBLL(); objGF = objGFBLL.GetGraveByID(Convert.ToInt32(ViewState["GRV_FINISHID"])); if (objGF != null) { txtGrave.Text = objGF.GraveFinishType; } SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { string message = string.Empty; GraveFinishBLL objGFBLL = new GraveFinishBLL(); message = objGFBLL.DeleteGrave(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } ClearDetails(); SetUpdateMode(false); BindGrid(false, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_Save_Click(object sender, EventArgs e) { string message = string.Empty; string AlertMessage = string.Empty; GraveFinishBO objGF = new GraveFinishBO(); objGF.GraveFinishID = int.Parse(ViewState["GRV_FINISHID"].ToString()); objGF.GraveFinishType = txtGrave.Text.Trim(); objGF.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); GraveFinishBLL objGFBLL = new GraveFinishBLL(); if (objGF.GraveFinishID == 0) { message = objGFBLL.AddGrave(objGF); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data added successfully"; ClearDetails(); BindGrid(true, false); } } else { message = objGFBLL.UpdateGrave(objGF); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; SetUpdateMode(false); ClearDetails(); BindGrid(true, false); } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }
/// <summary> /// To Update Grave /// </summary> /// <param name="objGF"></param> /// <returns></returns> public string UpdateGrave(GraveFinishBO objGF) { GraveFinishDAL objGraveDAL = new GraveFinishDAL(); return(objGraveDAL.UpdateGrave(objGF)); }
/// <summary> /// To Add Grave /// </summary> /// <param name="objGrave"></param> /// <returns></returns> public string AddGrave(GraveFinishBO objGrave) { GraveFinishDAL objGraveDAL = new GraveFinishDAL(); return(objGraveDAL.AddGrave(objGrave)); }