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);
}
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("");
}
}
public bool Add(string WarehouseNo, string TrackingNo, List <GradingByBLL> list)
{
//Utility.LogException(new Exception(TrackingNo.ToString()));
SqlTransaction trans;
SqlConnection conn = Connection.getConnection();
bool isSaved = false;
trans = conn.BeginTransaction();
try
{
SamplingResultBLL obj = new SamplingResultBLL();
obj = obj.GetSamplingResultById(this.SamplingResultId);
//Tod Do if the code is from Regrading then the Tracking Number should change.
string TranNoGradedispute = "";
TranNoGradedispute = TrackingNo;
//if not from regrading.
if (TranNoGradedispute == "")
{
throw new Exception("Unable to get Tracking Number.");
}
this.Id = Guid.NewGuid();
this.GradingCode = GetRandomCode(WarehouseNo);
// TODO - Complete Work flow intgeration.
//this.TrackingNo = TranNoGradedispute;
this.TrackingNo = TrackingNo;
isSaved = GradingDAL.InsertGrading(this, trans);
if (isSaved == true)
{
// add Graders.
GradingByBLL objGradingBy = new GradingByBLL();
isSaved = objGradingBy.Add(this.Id, list, trans);
if (isSaved == false)
{
throw new CodeGenerationException("Can Not generarte Grading Code Exception");
}
else
{
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrail(this, WFStepName.GenerateGradingCode.ToString(), UserBLL.GetCurrentUser(), "Get Grading Code");
if (at == 1)
{
isSaved = true;
}
else
{
isSaved = false;
}
}
}
else
{
throw new CodeGenerationException("Can Not generarte Grading Code Exception");
}
if (isSaved == true)
{
HttpContext.Current.Session["msg"] = WFTransaction.Request(TrackingNo);
WFTransaction.WorkFlowManager(TrackingNo);
trans.Commit();
}
return(isSaved);
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
trans.Dispose();
conn.Close();
}
}
