/// <summary> /// To Get Representation /// </summary> /// <returns></returns> public RepresentationList GetRepresentation() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_REPRESENTATION"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); RepresentationBO objRepresentationBO = null; RepresentationList Representation = new RepresentationList(); while (dr.Read()) { objRepresentationBO = new RepresentationBO(); objRepresentationBO.RepresentationID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("representationid"))); objRepresentationBO.RepresentationName = dr.GetString(dr.GetOrdinal("representationname")); objRepresentationBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); Representation.Add(objRepresentationBO); } dr.Close(); return(Representation); }
/// <summary> /// To Load Representation Data /// </summary> /// <returns></returns> public RepresentationList LoadRepresentationData() { cnn = new OracleConnection(AppConfiguration.ConnectionString); string proc = "USP_MST_LOADREPRESENTATION"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); RepresentationBO obMaster = null; RepresentationList Master = new RepresentationList(); while (dr.Read()) { obMaster = new RepresentationBO(); if (!dr.IsDBNull(dr.GetOrdinal("ID"))) { obMaster.RepresentationID = dr.GetInt32(dr.GetOrdinal("ID")); } if (!dr.IsDBNull(dr.GetOrdinal("Name"))) { obMaster.RepresentationName = dr.GetString(dr.GetOrdinal("Name")); } Master.Add(obMaster); } dr.Close(); return(Master); }
/// <summary> /// To fetch details from the database and assign to textbox /// </summary> /// <param name="sender"></param> /// <param name="e"></param>e private void GetRepresentationDetails() { RepresentationBLL objRepresentationBLL = new RepresentationBLL(); RepresentationBO objRepresentationBO = new RepresentationBO(); objRepresentationBO = objRepresentationBLL.GetRepresentationById(Convert.ToInt32(ViewState["RepresentationID"])); if (objRepresentationBO != null) { txtRepresentation.Text = objRepresentationBO.RepresentationName; } }
/// <summary> /// To Update Representation /// </summary> /// <param name="objRepresentationBO"></param> /// <returns></returns> public string UpdateRepresentation(RepresentationBO objRepresentationBO) { RepresentationDAL objRepresentationDAL = new RepresentationDAL(); //Data pass -to Database Layer try { return(objRepresentationDAL.UpdateRepresentation(objRepresentationBO)); } catch { throw; } finally { objRepresentationDAL = null; } }
/// <summary> /// To Update Representation /// </summary> /// <param name="objRepresentationBO"></param> /// <returns></returns> public string UpdateRepresentation(RepresentationBO objRepresentationBO) { string result = ""; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATEREPRESENTATION", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("REPRESENTATIONID_", objRepresentationBO.RepresentationID); dcmd.Parameters.Add("REPRESENTATIONNAME_", objRepresentationBO.RepresentationName); dcmd.Parameters.Add("UPDATEDBY_", objRepresentationBO.UserID); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { result = dcmd.Parameters["errorMessage_"].Value.ToString(); } return(result); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }
/// <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 = ""; RepresentationBLL objRepresentationBLL = new RepresentationBLL(); if (Convert.ToInt32(ViewState["RepresentationID"]) == 0) { try { string uID = Session["USER_ID"].ToString(); RepresentationBO objRepresentationBO = new RepresentationBO(); objRepresentationBO.RepresentationName = txtRepresentation.Text.ToString().Trim(); objRepresentationBO.UserID = Convert.ToInt32(uID); message = objRepresentationBLL.InsertRepresentation(objRepresentationBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { objRepresentationBLL = null; } ClearData(); BindGrid(); } //edit the data in the textbox exiting in the Grid else if (Convert.ToInt32(ViewState["RepresentationID"]) > 0) { try { RepresentationBO objRepresentationBO = new RepresentationBO(); objRepresentationBO.RepresentationName = txtRepresentation.Text.ToString().Trim(); objRepresentationBO.RepresentationID = Convert.ToInt32(ViewState["RepresentationID"]); objRepresentationBO.UserID = Convert.ToInt32(Session["USER_ID"]); message = objRepresentationBLL.UpdateRepresentation(objRepresentationBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { objRepresentationBLL = null; } ClearData(); BindGrid(); SetUpdateMode(false); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }