/// <summary> /// To Update Structure Type /// </summary> /// <param name="oStructureType"></param> /// <returns></returns> public string UpdateStructureType(StructureTypeBO oStructureType) { string returnResult; cnn = new OracleConnection(con); proc = "USP_MST_UPD_STRUCTURETYPE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("str_typeid_", oStructureType.StructureTypeID); cmd.Parameters.Add("str_type_", oStructureType.StructureTypeName); cmd.Parameters.Add("updatedby_", oStructureType.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); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> #region Load Grid / Bind Grid private void BindGrid(bool addRow, bool deleteRow) { objStructureTypeBLL = new StructureTypeBLL(); objStructureType = new StructureTypeBO(); objStructureType.StructureTypeName = string.Empty; objStructureType.StructureTypeID = 0; grdStructureType.DataSource = objStructureTypeBLL.GetAllStructureType();//(objStructureType); grdStructureType.DataBind(); }
/// <summary> /// To Get All Structure Type /// </summary> /// <returns></returns> public StructureTypeList GetAllStructureType() { //Get All Records from Structure Type proc = "USP_MST_GET_ALL_STRUCTURETYPE"; cnn = new OracleConnection(con); StructureTypeBO objStructureType = null; StructureTypeList lstStructureTypeList = new StructureTypeList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objStructureType = new StructureTypeBO(); if (ColumnExists(dr, "str_typeid") && !dr.IsDBNull(dr.GetOrdinal("str_typeid"))) { objStructureType.StructureTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("str_typeid"))); } if (ColumnExists(dr, "str_type") && !dr.IsDBNull(dr.GetOrdinal("str_type"))) { objStructureType.StructureTypeName = dr.GetString(dr.GetOrdinal("str_type")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objStructureType.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } // objStructureType = MapData(dr); lstStructureTypeList.Add(objStructureType); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstStructureTypeList); }
/// <summary> /// Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> #region Edit Record private void GetStructureTypeDetails() { objStructureTypeBLL = new StructureTypeBLL(); int StructureTypeID = 0; if (ViewState["StructureTypeID"] != null) { StructureTypeID = Convert.ToInt32(ViewState["StructureTypeID"].ToString()); } objStructureType = new StructureTypeBO(); objStructureType = objStructureTypeBLL.GetStructureTypeById(StructureTypeID); txtStructureType.Text = objStructureType.StructureTypeName; }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> #region Save Record protected void btnSave_Click(object sender, EventArgs e) { string message = string.Empty; string AlertMessage = string.Empty; objStructureType = new StructureTypeBO(); objStructureTypeBLL = new StructureTypeBLL(); //Assignement objStructureType.StructureTypeName = txtStructureType.Text.Trim(); if (ViewState["StructureTypeID"] != null) { objStructureType.StructureTypeID = Convert.ToInt32(ViewState["StructureTypeID"].ToString()); } objStructureType.IsDeleted = "False"; //if (Session["USER_ID"] != null) objStructureType.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); if (objStructureType.StructureTypeID < 1) { //If StructureTypeID does Not exists then SaveStructureType objStructureType.StructureTypeID = -1;//For New StructureType message = objStructureTypeBLL.AddStructureType(objStructureType); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully."; } } else { //If StructureTypeID exists then UpdateStructureType message = objStructureTypeBLL.UpdateStructureType(objStructureType); //For Updating StructureType if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully."; } } ClearDetails(); BindGrid(true, false); AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); SetUpdateMode(false); }
/// <summary> /// To Map Data /// </summary> /// <param name="reader"></param> /// <returns></returns> private StructureTypeBO MapData(IDataReader reader) { StructureTypeBO oStructureTypeBO = new StructureTypeBO(); if (ColumnExists(reader, "str_typeid") && !reader.IsDBNull(reader.GetOrdinal("str_typeid"))) { oStructureTypeBO.StructureTypeID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("str_typeid"))); } if (ColumnExists(reader, "str_type") && !reader.IsDBNull(reader.GetOrdinal("str_type"))) { oStructureTypeBO.StructureTypeName = reader.GetString(reader.GetOrdinal("str_type")); } if (ColumnExists(reader, "IsDeleted") && !reader.IsDBNull(reader.GetOrdinal("IsDeleted"))) { oStructureTypeBO.IsDeleted = reader.GetString(reader.GetOrdinal("IsDeleted")); } return(oStructureTypeBO); }
/// <summary> /// To Get Structure Type By Id /// </summary> /// <param name="StructureTypeID"></param> /// <returns></returns> public StructureTypeBO GetStructureTypeById(int StructureTypeID) { cnn = new OracleConnection(con); proc = "USP_MST_GET_STRUCTURETYPEBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("shockid_", StructureTypeID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); StructureTypeBO objStructureType = null; while (dr.Read()) { objStructureType = new StructureTypeBO(); if (ColumnExists(dr, "str_typeid") && !dr.IsDBNull(dr.GetOrdinal("str_typeid"))) { objStructureType.StructureTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("str_typeid"))); } if (ColumnExists(dr, "str_type") && !dr.IsDBNull(dr.GetOrdinal("str_type"))) { objStructureType.StructureTypeName = dr.GetString(dr.GetOrdinal("str_type")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objStructureType.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } //objStructureType = objStructureType;//MapData(dr); } dr.Close(); return(objStructureType); }
/// <summary> /// To Get Structure Type /// </summary> /// <returns></returns> public StructureTypeList GetStructureType() { // Get Only Active Structure Types proc = "USP_MST_GET_STRUCTURETYPE"; cnn = new OracleConnection(con); StructureTypeBO objStructureType = null; StructureTypeList lstStructureTypeList = new StructureTypeList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objStructureType = new StructureTypeBO(); objStructureType = MapData(dr); lstStructureTypeList.Add(objStructureType); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstStructureTypeList); }
/// <summary> /// To Update Structure Type /// </summary> /// <param name="oStructureType"></param> /// <returns></returns> public string UpdateStructureType(StructureTypeBO oStructureType) { objStructureTypeDAL = new StructureTypeDAL(); return(objStructureTypeDAL.UpdateStructureType(oStructureType)); }
/// <summary> /// To Add Structure Type /// </summary> /// <param name="oStructureType"></param> /// <returns></returns> public string AddStructureType(StructureTypeBO oStructureType) { objStructureTypeDAL = new StructureTypeDAL(); return(objStructureTypeDAL.SaveStructureType(oStructureType)); }