public bool Add(List <GradingResultDetailBLL> list, SqlTransaction trans, Nullable <Guid> Id)
{
bool isSaved = false;
if (Id == null)
{
trans.Rollback();
trans.Dispose();
return(false);
}
try
{
string str = "Grading Factors(";
foreach (GradingResultDetailBLL obj in list)
{
obj.GradingResultId = (Guid)Id;
obj.Id = Guid.NewGuid();
isSaved = GradingResultDetailDAL.InsertGradingResultDetail(obj, trans);
if (isSaved == false)
{
throw new Exception("Unable to insert Grading Factor Values");
}
else
{
str += "[Id-" + obj.Id.ToString() + " ,GradingResultId-" + obj.GradingResultId.ToString() +
" ,GradingFactorId-" + obj.GradingFactorId.ToString() + " , RecivedValue-" + obj.RecivedValue.ToString() +
" , Status-" + obj.Status.ToString() + ", CreateBy-" + UserBLL.GetCurrentUser() + "];";
}
}
str += ")";
isSaved = true;
AuditTrailBLL objAt = new AuditTrailBLL();
int at = -1;
at = objAt.saveAuditTrailStringFormat(str, "New data Added", WFStepName.AddGradingResult.ToString(), UserBLL.GetCurrentUser(), "Add Grading Factor Values");
if (at != 1)
{
isSaved = false;
throw new Exception("Unbale to add Audit Trail-Grading Factor Value.");
}
else
{
isSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(isSaved);
}
public Nullable <float> GetGradingResultDetialByGradingResdultIdTotalValue(Guid GradingResultId)
{
Nullable <float> totalValue = null;
List <GradingResultDetailBLL> list = new List <GradingResultDetailBLL>();
list = GradingResultDetailDAL.GetGradingResultWithTotalValue(Id);
if (list == null)
{
return(null);
}
else
{
totalValue = 0;
foreach (GradingResultDetailBLL i in list)
{
totalValue += float.Parse(i.RecivedValue);
}
return(totalValue);
}
}
public bool UpdateEach(Guid Id, string Value)
{
//get the old
SqlTransaction tran;
SqlConnection conn = Connection.getConnection();
bool isSaved = false;
GradingResultDetailBLL objOld = GradingResultDetailDAL.GetGradingResultDetailById(Id);
GradingResultDetailBLL objNew = objOld;
objNew.RecivedValue = Value;
tran = conn.BeginTransaction();
try
{
isSaved = GradingResultDetailDAL.UpdateGradingResultDetailEach(Id, Value, tran);
AuditTrailBLL objAt = new AuditTrailBLL();
int x = objAt.saveAuditTrail(objOld, objNew, Utility.GetApplicationName(), UserBLL.GetCurrentUser(), "Update Grading factorValue");
if (x == 1 && isSaved == true)
{
tran.Commit();
}
else if (isSaved == true && x == -1)
{
tran.Rollback();
isSaved = false;
objAt.RoleBack();
}
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Dispose();
conn.Close();
}
return(isSaved);
}
public SqlDataReader GetGradingResultDetailByGradingIdDataReader(Guid GradingId, SqlConnection conn)
{
return(GradingResultDetailDAL.GetGradingResultDetailByGradingIdDataReader(GradingId, ref conn));
}
public List <GradingResultDetailBLL> GetGradingResultDetailByGradingResultId(Guid Id)
{
return(GradingResultDetailDAL.GetGradingResultDetailByGradingResultId(Id));
}
