/// <summary> /// To Update Structure Condition /// </summary> /// <param name="oStructureCondition"></param> /// <returns></returns> public string UpdateStructureCondition(StructureConditionBO oStructureCondition) { string returnResult; cnn = new OracleConnection(con); proc = "USP_MST_UPD_STRUCTURECONDITION"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("str_conditionid_", oStructureCondition.StructureConditionID); cmd.Parameters.Add("str_condition_", oStructureCondition.StructureConditionName); cmd.Parameters.Add("updatedby_", oStructureCondition.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> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = string.Empty; string AlertMessage = string.Empty; objStructureCondition = new StructureConditionBO(); objStructureConditionBLL = new StructureConditionBLL(); //Assignement objStructureCondition.StructureConditionName = txtStructureCondition.Text.Trim(); if (ViewState["StructureConditionID"] != null) { objStructureCondition.StructureConditionID = Convert.ToInt32(ViewState["StructureConditionID"].ToString()); } objStructureCondition.IsDeleted = "False"; //if (Session["USER_ID"] != null) objStructureCondition.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); if (objStructureCondition.StructureConditionID < 1) { //If StructureConditionID does Not exists then SaveStructureCondition objStructureCondition.StructureConditionID = -1;//For New StructureCondition message = objStructureConditionBLL.AddStructureCondition(objStructureCondition); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully."; ClearDetails(); BindGrid(true, false); } } else { //If StructureConditionID exists then UpdateStructureCondition message = objStructureConditionBLL.UpdateStructureCondition(objStructureCondition); //For Updating StructureCondition if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully."; ClearDetails(); BindGrid(true, false); } } if (message != null) { AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } ClearDetails(); SetUpdateMode(false); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { objStructureConditionBLL = new StructureConditionBLL(); objStructureCondition = new StructureConditionBO(); objStructureCondition.StructureConditionName = string.Empty; objStructureCondition.StructureConditionID = 0; grdStructureCondition.DataSource = objStructureConditionBLL.GetAllStructureCondition();//(objStructureCondition); grdStructureCondition.DataBind(); }
/// <summary> /// to fetch details from database and assign to textbox /// </summary> private void GetStructureConditionDetails() { objStructureConditionBLL = new StructureConditionBLL(); int StructureConditionID = 0; if (ViewState["StructureConditionID"] != null) { StructureConditionID = Convert.ToInt32(ViewState["StructureConditionID"].ToString()); } objStructureCondition = new StructureConditionBO(); objStructureCondition = objStructureConditionBLL.GetStructureConditionById(StructureConditionID); txtStructureCondition.Text = objStructureCondition.StructureConditionName; }
/// <summary> /// To Get All Structure Condition /// </summary> /// <returns></returns> public StructureConditionList GetAllStructureCondition() { proc = "USP_MST_GET_ALLSTRUCTCONDITION"; cnn = new OracleConnection(con); StructureConditionBO objStructureCondition = null; StructureConditionList lstStructureConditionList = new StructureConditionList(); 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()) { objStructureCondition = new StructureConditionBO(); if (ColumnExists(dr, "str_conditionid") && !dr.IsDBNull(dr.GetOrdinal("str_conditionid"))) { objStructureCondition.StructureConditionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("str_conditionid"))); } if (ColumnExists(dr, "str_condition") && !dr.IsDBNull(dr.GetOrdinal("str_condition"))) { objStructureCondition.StructureConditionName = dr.GetString(dr.GetOrdinal("str_condition")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objStructureCondition.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } lstStructureConditionList.Add(objStructureCondition); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstStructureConditionList); }
/// <summary> /// To Get Structure Condition By Id /// </summary> /// <param name="StructureConditionID"></param> /// <returns></returns> public StructureConditionBO GetStructureConditionById(int StructureConditionID) { cnn = new OracleConnection(con); proc = "USP_MST_GET_STRUCTCONDI_BYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("str_conditionid_", StructureConditionID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); StructureConditionBO objStructureCondition = null; while (dr.Read()) { objStructureCondition = new StructureConditionBO(); if (ColumnExists(dr, "str_conditionid") && !dr.IsDBNull(dr.GetOrdinal("str_conditionid"))) { objStructureCondition.StructureConditionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("str_conditionid"))); } if (ColumnExists(dr, "str_condition") && !dr.IsDBNull(dr.GetOrdinal("str_condition"))) { objStructureCondition.StructureConditionName = dr.GetString(dr.GetOrdinal("str_condition")); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { objStructureCondition.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } } dr.Close(); return(objStructureCondition); }
/// <summary> /// To Update Structure Condition /// </summary> /// <param name="oStructureCondition"></param> /// <returns></returns> public string UpdateStructureCondition(StructureConditionBO oStructureCondition) { objStructureConditionDAL = new StructureConditionDAL(); return(objStructureConditionDAL.UpdateStructureCondition(oStructureCondition)); }
/// <summary> /// To Add Structure Condition /// </summary> /// <param name="oStructureCondition"></param> /// <returns></returns> public string AddStructureCondition(StructureConditionBO oStructureCondition) { objStructureConditionDAL = new StructureConditionDAL(); return(objStructureConditionDAL.SaveStructureCondition(oStructureCondition)); }