public SqlDataReader GetGradersByGradingIdDataReader(Guid GradingId, SqlConnection conn)
{
SqlDataReader reader = null;
reader = GradingByDAL.GetGradersByGradingIdDataReader(GradingId, conn);
return(reader);
}
public List <GradingByBLL> GetByGradingId(Guid GradingId)
{
List <GradingByBLL> listComplete = null;;
List <GradingByBLL> list = new List <GradingByBLL>();
list = GradingByDAL.GetSupervisorByGradingId(GradingId);
EmployeeAttendanceBLL objEmp = new EmployeeAttendanceBLL();
List <UserBLL> empList = new List <UserBLL>();
empList = UserRightBLL.GetUsersWithRight("Grader");
if (empList != null && list != null)
{
if (empList.Count > 0 && list.Count > 0)
{
var q = from Graders in list
join UserDetail in empList on Graders.UserId equals UserDetail.UserId
select new { Graders.IsSupervisor, UserDetail.FullName };
listComplete = new List <GradingByBLL>();
foreach (var i in q)
{
GradingByBLL o = new GradingByBLL();
o.isSupervisor = i.IsSupervisor;
o.GraderName = i.FullName;
listComplete.Add(o);
}
}
}
return(listComplete);
}
//oublic Functions
public bool Add(Guid Id, List <GradingByBLL> list, SqlTransaction tran)
{
if (list.Count > 0)
{
try
{
string strAt = "";
foreach (GradingByBLL i in list)
{
bool isSaved = false;
i.GradingId = Id;
isSaved = GradingByDAL.InsertGraders(i, tran);
if (isSaved == false)
{
return(false);
}
else
{
strAt += "[(Id-" + i.Id.ToString() + "),(GradingId-" + i.GradingId.ToString() + "),(UserId-" +
i.UserId.ToString() + "),(Status-" + i.Status.ToString() + "),(isSupervisor-" + isSupervisor.ToString() + "),(CreatedBy"
+ UserBLL.GetCurrentUser().ToString() + ")] ; ";
}
}
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrailStringFormat("New Data added", strAt, WFStepsName.GenerateGradingCode.ToString(), UserBLL.GetCurrentUser(), "Add Grader");
if (at == 1)
{
return(true);
}
else
{
return(false);
}
}
catch
{
new Exception("Unable to Add Graders.");
}
}
return(false);
}
public string GetSupGraderNameByGradingId(Guid GradingId)
{
List <GradingByBLL> list = null;
list = GradingByDAL.GetSupervisorByGradingId(GradingId);
if (list != null)
{
if (list.Count() == 1)
{
GradingByBLL o = list[0];
return(UserRightBLL.GetUserNameByUserId(o.UserId));
}
else
{
return("");
}
}
else
{
return("");
}
}
