/// <summary> /// to update data /// </summary> /// <param name="ObjFixture"></param> /// <returns></returns> public string UpdateFixtureType(FixtureTypeBO ObjFixture) { cnn = new OracleConnection(con); string returnResult = string.Empty; // proc = "USP_MST_UPD_BANK"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("fixturetypeID", ObjFixture.FixtureID); cmd.Parameters.Add("fixturetype", ObjFixture.FixtureType); cmd.Parameters.Add("updatedby", ObjFixture.UpdatedBy); 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; } cmd.Connection.Close(); return(returnResult); }
/// <summary> /// to fetch details /// </summary> /// <param name="fixturetype"></param> /// <returns></returns> public FixtureTypeList GetAllFixtureType(string fixturetype) { proc = "USP_MST_GET_ALLBANKS"; FixtureTypeBO ObjFixture = null; FixtureTypeList fixtureList = new FixtureTypeList(); using (cnn = new OracleConnection(con)) { using (cmd = new OracleCommand(proc, cnn)) { cmd.CommandType = CommandType.StoredProcedure; if (fixturetype != "") { cmd.Parameters.Add("fixturetype_", fixturetype); } else { cmd.Parameters.Add("fixturetype_", DBNull.Value); } cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { ObjFixture = new FixtureTypeBO(); if (!dr.IsDBNull(dr.GetOrdinal("FixtureTypeID"))) { ObjFixture.FixtureID = dr.GetInt32(dr.GetOrdinal("FixtureTypeID")); } if (!dr.IsDBNull(dr.GetOrdinal("FixtureType"))) { ObjFixture.FixtureType = dr.GetString(dr.GetOrdinal("FixtureType")); } if (!dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { ObjFixture.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } fixtureList.Add(ObjFixture); } dr.Close(); } catch (Exception ex) { throw ex; } } } return(fixtureList); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { FixtureTypeBO ObjFixtureBO = new FixtureTypeBO(); ObjFixtureBO.FixtureID = Convert.ToInt32(ViewState["FixtureType_ID"]); ObjFixtureBO.FixtureType = txtFixtureType.Text.Trim(); FixtureTypeBLL ObjFixtureBLL = new FixtureTypeBLL(); string AlertMessage = string.Empty; string message = string.Empty; if (ObjFixtureBO.FixtureID == 0) { ObjFixtureBO.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = ObjFixtureBLL.AddFixtureType(ObjFixtureBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearDetails(); } } else { ObjFixtureBO.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); message = ObjFixtureBLL.UpdateFixtureType(ObjFixtureBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearDetails(); } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); BindFixtureType(true, false); }
/// <summary> /// To Update Fixture Type /// </summary> /// <param name="ObjFixture"></param> /// <returns></returns> public string UpdateFixtureType(FixtureTypeBO ObjFixture) { return((new FixtureTypeDAL()).UpdateFixtureType(ObjFixture)); }
/// <summary> /// To Add Fixture Type /// </summary> /// <param name="ObjFixture"></param> /// <returns></returns> public string AddFixtureType(FixtureTypeBO ObjFixture) { return((new FixtureTypeDAL()).AddFixtureType(ObjFixture)); }