/// <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));
}
