/// <summary>
/// To Get All Positions
/// </summary>
/// <returns></returns>
public PositionList GetAllPositions()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ALLPOSITIONS";
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);
PositionBO objPosition = null;
PositionList PositionList = new PositionList();
while (dr.Read())
{
objPosition = new PositionBO();
objPosition.PositionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("POSITIONID")));
objPosition.PositionName = dr.GetString(dr.GetOrdinal("POSITION"));
objPosition.PositionIsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
PositionList.Add(objPosition);
}
dr.Close();
return(PositionList);
}
/// <summary>
/// To get position from database based on ID
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetPositionByID()
{
PositionBLL PositionBLLobj = new PositionBLL();
int PositionID = 0;
if (ViewState["PositionID"] != null)
{
PositionID = Convert.ToInt32(ViewState["PositionID"]);
}
PositionBO PositionObj = new PositionBO();
PositionObj = PositionBLLobj.GetPositionById(PositionID);
txtPosition.Text = PositionObj.PositionName;
txtPositionID.Text = PositionObj.PositionID.ToString();
}
/// <summary>
/// To EDIT POSITION
/// </summary>
/// <param name="PositionBOObj"></param>
/// <returns></returns>
public string EDITPOSITION(PositionBO PositionBOObj)
{
PositionDAL PositionDAL = new PositionDAL(); //Data pass -to Database Layer
try
{
return(PositionDAL.EDITPOSITION(PositionBOObj));
}
catch
{
throw;
}
finally
{
PositionDAL = null;
}
}
/// <summary>
/// TO EDIT POSITION
/// </summary>
/// <param name="PositionBOObj"></param>
/// <returns></returns>
public string EDITPOSITION(PositionBO PositionBOObj)
{
string returnResult = string.Empty;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_UPDATEPOSITION", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("PositionName_", PositionBOObj.PositionName);
dcmd.Parameters.Add("PositionID_", PositionBOObj.PositionID);
dcmd.Parameters.Add("UpdatedBY", PositionBOObj.UserID);
//return dcmd.ExecuteNonQuery();
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
returnResult = dcmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(returnResult);
}
//get the data in mst_Concern table using USP_MST_GETSELECTCONCERN-SP signal Data based on ID
/// <summary>
/// To Get Position By Id
/// </summary>
/// <param name="PositionID"></param>
/// <returns></returns>
public PositionBO GetPositionById(int PositionID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETSELECTPOSITION";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PositionID_", PositionID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PositionBO PositionBOObj = null;
PositionList PositionList = new PositionList();
PositionBOObj = new PositionBO();
while (dr.Read())
{
if (ColumnExists(dr, "POSITION") && !dr.IsDBNull(dr.GetOrdinal("POSITION")))
{
PositionBOObj.PositionName = dr.GetString(dr.GetOrdinal("POSITION"));
}
if (ColumnExists(dr, "POSITIONID") && !dr.IsDBNull(dr.GetOrdinal("POSITIONID")))
{
PositionBOObj.PositionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("POSITIONID")));
}
if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
PositionBOObj.PositionIsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(PositionBOObj);
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string AlertMessage = string.Empty;
string message = string.Empty;
PositionBLL PositionBLLOBJ = new PositionBLL();
PositionBO PositionBOObj = new PositionBO();
int uID = Convert.ToInt32(Session["USER_ID"].ToString());
if (txtPositionID.Text.ToString().Trim() == "0")
{
try
{
PositionBOObj.PositionName = txtPosition.Text.ToString().Trim();
PositionBOObj.UserID = uID;
message = PositionBLLOBJ.InsertPosition(PositionBOObj);
AlertMessage = "alert('" + message + "');";
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
if (message != "")
{
Clear();
BindGrid(true, true);
txtPositionID.Text = "0";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
PositionBLLOBJ = null;
}
}
else
{
try
{
PositionBOObj.PositionName = txtPosition.Text.ToString().Trim();
PositionBOObj.PositionID = Convert.ToInt32(txtPositionID.Text.ToString().Trim());
PositionBOObj.UserID = Convert.ToInt32(uID);
message = PositionBLLOBJ.EDITPOSITION(PositionBOObj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
// ClearDetails();
Clear();
SetUpdateMode(false);
BindGrid(true, true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
PositionBLLOBJ = null;
}
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
