public string ApproveRejectUseCase(UseCaseApprovals useCaseApprovals)
{
string _retVal;
SqlConnection objCon = new SqlConnection();
SqlCommand objCom;
try
{
ConnectionString(objCon);
objCom = new SqlCommand("GIOS.GIOS_UCApproveRejectUseCase", objCon);
objCom.CommandType = System.Data.CommandType.StoredProcedure;
objCom.Parameters.Add(new SqlParameter("@intUseCaseID", useCaseApprovals.intUseCaseID));
objCom.Parameters.Add(new SqlParameter("@ysnApproved", useCaseApprovals.ysnApproved));
objCom.Parameters.Add(new SqlParameter("@strComments", useCaseApprovals.strComments));
objCom.Parameters.Add(new SqlParameter("@strUserID", useCaseApprovals.strApproverID));
objCon.Open();
objCom.ExecuteScalar();
objCon.Close();
_retVal = "Success";
}
catch (Exception ex)
{
_retVal = ex.Message;
}
return(_retVal);
}
public ActionResult ApproveUseCases()
{
UseCaseApprovals needsApproval = new UseCaseApprovals()
{
lstUseCaseApprovals = useCase_DAL.ListUseCaseApprovals().ToList()
};
//RequiredSupportTypes requiredSupportTypes = new RequiredSupportTypes();
//requiredSupportTypes.RequiredSupportList = useCase_DAL.ListrequiredSupportTypes().ToList();
return(View(needsApproval.lstUseCaseApprovals));
}
public IEnumerable <UseCaseApprovals> ListUseCaseApprovals()
{
List <UseCaseApprovals> _retVal = new List <UseCaseApprovals>();
SqlConnection objCon = new SqlConnection();
SqlCommand objCom;
UseCaseApprovals toBeApproved;
ConnectionString(objCon);
objCom = new SqlCommand("SELECT [UA].[lngRecordID],[UA].[intUseCaseID], [UC].[strTitle], [UC].[strDescription], [UC].[strHypothesis], [UA].[strBUID],[UA].[ysnApproved],[UA].[strComments],[UA].[dtmCreated],[UA].[strCreatorID],[UA].[dtmApproved],[UA].[strApproverID] " +
"FROM [GIOS].[GIOS].[GIOS_UUseCaseApprovals] UA, GIOS.GIOS.GIOS_UUseCase UC where[UA].[intUseCaseID] = [UC].[intUseCaseID]", objCon);
// objCom.Parameters.Add(new SqlParameter("@strUserName", strUserName));
objCon.Open();
SqlDataReader reader = objCom.ExecuteReader();
while (reader.Read())
{
toBeApproved = new UseCaseApprovals();
toBeApproved.lngRecordID = Convert.ToInt32(reader["lngRecordID"]);
toBeApproved.intUseCaseID = Convert.ToInt32(reader["intUseCaseID"]);
toBeApproved.strUseCaseTitle = reader["strTitle"].ToString();
toBeApproved.strUseCaseDescr = reader["strDescription"].ToString();
toBeApproved.strBUID = reader["strBUID"].ToString();
toBeApproved.ysnApproved = reader["ysnApproved"].ToString();
toBeApproved.strComments = reader["strComments"].ToString();
toBeApproved.strCreatorID = reader["strCreatorID"].ToString();
if (reader["dtmCreated"] == System.DBNull.Value)
{
toBeApproved.dtmCreated = null;
}
else
{
toBeApproved.dtmCreated = Convert.ToDateTime(reader["dtmCreated"]);
}
toBeApproved.strApproverID = reader["strApproverID"].ToString();
if (reader["dtmApproved"] == System.DBNull.Value)
{
toBeApproved.dtmApproved = null;
}
else
{
toBeApproved.dtmApproved = Convert.ToDateTime(reader["dtmApproved"]);
}
_retVal.Add(toBeApproved);
}
reader.Close();
objCon.Close();
return(_retVal);
}
public void CreateEditUseCaseApproval(string AddUpdateFlag, UseCaseApprovals useCaseApprovals)
{
string _retVal;
SqlConnection objCon = new SqlConnection();
SqlCommand objCom;
try
{
ConnectionString(objCon);
objCom = new SqlCommand("GIOS.GIOS_UCAddUpdateUseCaseApproval", objCon)
{
CommandType = System.Data.CommandType.StoredProcedure
};
objCom.Parameters.Add(new SqlParameter("@AddupdateFlag", AddUpdateFlag));
objCom.Parameters.Add(new SqlParameter("@strBUID", useCaseApprovals.strBUID));
objCom.Parameters.Add(new SqlParameter("@intUseCaseID", useCaseApprovals.intUseCaseID));
objCom.Parameters.Add(new SqlParameter("@ysnApproved", ToDBNull(useCaseApprovals.ysnApproved)));
objCom.Parameters.Add(new SqlParameter("@strComments", ToDBNull(useCaseApprovals.strComments)));
if (AddUpdateFlag == "I")
{
objCom.Parameters.Add(new SqlParameter("@strUserID", useCaseApprovals.strCreatorID));
}
else
{
objCom.Parameters.Add(new SqlParameter("@strUserID", useCaseApprovals.strApproverID));
}
objCon.Open();
objCom.ExecuteScalar();
objCon.Close();
_retVal = "Sucess";
}
catch (Exception ex)
{
_retVal = ex.Message;
}
}
