/// <summary>
/// To fetch Project name from database
/// </summary>
/// <param name="PROJECTID"></param>
/// <returns></returns>
public Compare_projectList Getprojectname(string PROJECTID)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_PROJECTNAME";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Compare_projectBO ObjPc = null;
Compare_projectList ObjPcList = new Compare_projectList();
while (dr.Read())
{
ObjPc = new Compare_projectBO();
ObjPc.ProjectID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PROJECTID"))));
ObjPc.ProjectName = dr.GetValue(dr.GetOrdinal("PROJECTNAME")).ToString();
ObjPcList.Add(ObjPc);
}
dr.Close();
return(ObjPcList);
}
/// <summary>
/// To Get data from database
/// </summary>
/// <param name="Compare_projectBOObj"></param>
/// <returns></returns>
public Compare_projectList Getdata(Compare_projectBO Compare_projectBOObj)
{
Compare_ProjectDAL Compare_ProjectDAL = new Compare_ProjectDAL();
try
{
return(Compare_ProjectDAL.Getdata(Compare_projectBOObj));
}
catch
{
throw;
}
finally
{
Compare_ProjectDAL = null;
}
}
/// <summary>
/// To compare items in both the listboxes
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCompare_Click(object sender, EventArgs e)
{
System.Text.StringBuilder projectsSB = new System.Text.StringBuilder();
Compare_ProjectBLL Compare_ProjectBLLobj = new Compare_ProjectBLL();
Compare_projectBO Compare_projectBOObj = new Compare_projectBO();
foreach (ListItem lstItem in LstProjectcomp.Items)
{
projectsSB.Append(lstItem.Value + ",");
}
if (projectsSB.Length > 0)
{
projectsSB = projectsSB.Remove(projectsSB.Length - 1, 1);
Compare_projectBOObj.CompairID = projectsSB.ToString();
}
grdcompareprjt.DataSource = Compare_ProjectBLLobj.Getdata(Compare_projectBOObj);
grdcompareprjt.DataBind();
//tblProjectHeader.Visible = true;
}
/// <summary>
/// To Get data from database
/// </summary>
/// <param name="Compare_projectBOObj"></param>
/// <returns></returns>s
public Compare_projectList Getdata(Compare_projectBO Compare_projectBOObj)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_COMPARE_PROJECTS";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PROJECTIDS_", OracleDbType.Varchar2, 100).Value = Compare_projectBOObj.CompairID;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Compare_projectBO objPRJBO = null;
Compare_projectList objPRJList = new Compare_projectList();
while (dr.Read())
{
objPRJBO = new Compare_projectBO();
objPRJBO.ProjectID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PROJECTID"))));
objPRJBO.ProjectName = dr.GetValue(dr.GetOrdinal("projectcode")).ToString();
objPRJBO.TotalestBudget = (Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("TOTALESTBUDGET"))));
objPRJBO.Option1 = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Option1"))));
objPRJBO.Option2 = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Option2"))));
objPRJBO.Option3 = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Option3"))));
objPRJBO.Option4 = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Option4"))));
objPRJBO.Option5 = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Option5"))));
objPRJList.Add(objPRJBO);
}
dr.Close();
return(objPRJList);
}
