/// <summary>
/// To Fetch Tribe List
/// </summary>
/// <returns></returns>
public TribeList FetchTribeList()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETTRIBEDETAILS";
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);
TribeBO objTribeBO = null;
TribeList TribeListObj = new TribeList();
while (dr.Read())
{
objTribeBO = new TribeBO();
objTribeBO.TribeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("TRIBEID")));
objTribeBO.TribeName = dr.GetString(dr.GetOrdinal("TRIBENAME"));
TribeListObj.Add(objTribeBO);
}
dr.Close();
return(TribeListObj);
}
/// <summary>
/// To Get Tribe By Id
/// </summary>
/// <param name="TribeID"></param>
/// <returns></returns>
public TribeBO GetTribeById(int TribeID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETTRIBEDETAILSBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("TrbID", TribeID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TribeBO TribeBOObj = null;
TribeList TribeListObj = new TribeList();
TribeBOObj = new TribeBO();
while (dr.Read())
{
//if (ColumnExists(dr, "TRIBEID") && !dr.IsDBNull(dr.GetOrdinal("TRIBEID")))
// TribeBOObj.TribeID = Convert.ToInt32(dr.GetString(dr.GetOrdinal("TRIBEID")));
if (ColumnExists(dr, "TRIBENAME") && !dr.IsDBNull(dr.GetOrdinal("TRIBENAME")))
{
TribeBOObj.TribeName = Convert.ToString(dr.GetValue(dr.GetOrdinal("TRIBENAME")));
}
}
dr.Close();
return(TribeBOObj);
}
/// <summary>
/// used to fetch details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetClansname()
{
TribeBO objtribe = (new TribeBLL()).GetTribeById(Convert.ToInt32(ViewState["TRIBE_ID"]));
if (objtribe != null)
{
Master.PageHeader = "Clans for " + objtribe.TribeName;
}
}
/// <summary>
/// Get details from Database
/// </summary>
private void GetTribeDetails()
{
TribeBLL TribeBLLObj = new TribeBLL();
int TribeID = 0;
if (ViewState["TRIBEID"] != null)
{
TribeID = Convert.ToInt32(ViewState["TRIBEID"]);
}
TribeBO TribeBOObj = new TribeBO();
TribeBOObj = TribeBLLObj.GetTribeById(TribeID);
txtTribe.Text = TribeBOObj.TribeName;
}
/// <summary>
/// To EDIT Tribe
/// </summary>
/// <param name="TribeBOObj"></param>
/// <returns></returns>
public string EDITTribe(TribeBO TribeBOObj)
{
TribeDAL TribeDALObj = new TribeDAL();
try
{
return(TribeDALObj.EDITTribe(TribeBOObj));
}
catch
{
throw;
}
finally
{
TribeDALObj = null;
}
}
/// <summary>
/// To Insert Into Tribe Master
/// </summary>
/// <param name="TribeBOObj"></param>
/// <returns></returns>
public string InsertIntoTribeMaster(TribeBO TribeBOObj)
{
TribeDAL TribeDALObj = new TribeDAL();
try
{
return(TribeDALObj.InsertIntoTribeMaster(TribeBOObj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
TribeDALObj = null;
}
}
/// <summary>
/// Edit Data into Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void EditTribeDetails()
{
TribeBLL TribeBLLObj = new TribeBLL();
string message = "";
try
{
TribeBO TribeBOObj = new TribeBO();
if (ViewState["TRIBEID"] != null)
{
TribeBOObj.TribeID = Convert.ToInt32(ViewState["TRIBEID"].ToString());
}
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
TribeBOObj.TribeName = txtTribe.Text.ToString().Trim();
TribeBOObj.UpdatedBy = Convert.ToInt32(uID);
message = TribeBLLObj.EDITTribe(TribeBOObj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
txtTribe.Text = string.Empty;
SetUpdateMode(false);
BindGrid(true, true);
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
TribeBLLObj = null;
}
}
/// <summary>
/// Save and Update Data into Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveTribeDetails()
{
TribeBOObj = new TribeBO();
string message = "";
string Tribe = string.Empty;
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
Tribe = txtTribe.Text.ToString().Trim();
TribeBOObj.TribeName = Tribe;
TribeBOObj.CreatedBy = Convert.ToInt32(uID);
TribeBLLObj = new TribeBLL();
try
{
message = TribeBLLObj.InsertIntoTribeMaster(TribeBOObj);
txtTribe.Text = string.Empty;
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
BindGrid(true, true);
}
catch (Exception ee)
{
throw ee;
}
finally
{
TribeBLLObj = null;
}
}
/// <summary>
/// To EDIT Tribe
/// </summary>
/// <param name="TribeBOObj"></param>
/// <returns></returns>
public string EDITTribe(TribeBO TribeBOObj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_EDITTRIBE", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
string result = string.Empty;
try
{
dcmd.Parameters.Add("TrbID", TribeBOObj.TribeID);
dcmd.Parameters.Add("TrbName", TribeBOObj.TribeName);
dcmd.Parameters.Add("TrbUpdate", TribeBOObj.UpdatedBy);
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 Insert Into Tribe Master
/// </summary>
/// <param name="TribeBOObj"></param>
/// <returns></returns>
public string InsertIntoTribeMaster(TribeBO TribeBOObj)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
con.Open();
OracleCommand cmd = new OracleCommand("USP_MST_INSERTINTOTRIBEMASTER", con);
cmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(cmd.CommandType);
string result = string.Empty;
try
{
cmd.Parameters.Add("TrbName", TribeBOObj.TribeName);
cmd.Parameters.Add("CrtBy", TribeBOObj.CreatedBy);
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null)
{
result = cmd.Parameters["errorMessage_"].Value.ToString();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}
}
