public List<ABiRemark> getInvoiceRemarks(int invoiceId, int userId)
{
List<ABiRemark> ivRemarks = getInvoiceRemarks(invoiceId);
VPBLL.Users.UsersHelper uh = new Users.UsersHelper();
var ur = uh.GetUserRole(userId);
if (ur != null)
{
return (from o in ivRemarks
where o.RoleID == ur.RoleID
&& (o.UserID == userId || !o.UserID.HasValue)
select o).ToList();
}
return new List<ABiRemark>();
}
/// <summary>
/// Add or update the remark info.
/// </summary>
/// <param name="remark"></param>
/// <returns></returns>
public ABiRemark setInvoiceRemark(ABiRemark remark)
{
if (remark.ID > 0)
{
//update the remark
var obj = dbContent.ABi_Remark.FirstOrDefault(o => o.ABi_Remark_ID == remark.ID);
var users = new Users.UsersHelper().getUsers(remark.Username);
if (obj != null && users != null && users.Count > 0)
{
obj.ABi_Invoice_ID = remark.InvoiceID;
obj.ABi_Admin_User_ID = users[0].ABi_Admin_Users_ID;
obj.DateModified = DateTime.Now;
obj.Remark = remark.Remark;
obj.RemarkPerson = remark.RemarkPerson;
obj.ABi_Admin_Role_ID = remark.RoleID;
if (remark.RoleID == 3)
{
var ivObj = dbContent.ABi_Invoice.FirstOrDefault(o => o.ABi_Invoice_ID == remark.InvoiceID);
if (ivObj != null)
{
if (ivObj.InvoiceStatus == "1")
{
ivObj.InvoiceStatus = "2";
}
}
}
dbContent.SaveChanges();
//remark.ID = obj.ABi_Remark_ID;
}
}
else
{
//insert the remark
var users = new Users.UsersHelper().getUsers(remark.Username);
if (users != null && users.Count > 0)
{
var r = new VPDAL.ABi_Remark()
{
ABi_Invoice_ID = remark.InvoiceID,
ABi_Admin_User_ID = users[0].ABi_Admin_Users_ID,
DateCreated = DateTime.Now,
Remark = remark.Remark,
RemarkPerson = remark.RemarkPerson,
DateModified = DateTime.Now,
ABi_Admin_Role_ID = remark.RoleID
};
dbContent.AddToABi_Remark(r);
dbContent.SaveChanges();
remark.ID = r.ABi_Remark_ID;
}
}
return remark;
}
/// <summary>
/// Get all the remarks of the invoice
/// </summary>
/// <param name="invoiceId"></param>
/// <returns></returns>
public List<ABiRemark> getInvoiceRemarks(int invoiceId)
{
List<ABiRemark> result = new List<ABiRemark>();
Users.UsersHelper uh = new Users.UsersHelper();
try
{
result = (from o in dbContent.ABi_Remark
join u in dbContent.ABi_Admin_Users on o.ABi_Admin_User_ID equals u.ABi_Admin_Users_ID into users
from u in users.DefaultIfEmpty()
from r in dbContent.ABi_Admin_Roles
where o.ABi_Invoice_ID == invoiceId
//&& (o.ABi_Admin_User_ID == null || u.ABi_Admin_Users_ID == o.ABi_Admin_User_ID)
&& r.ABi_Admin_Roles_ID == o.ABi_Admin_Role_ID
select new ABiRemark()
{
ID = o.ABi_Remark_ID,
InvoiceID = o.ABi_Invoice_ID,
Remark = o.Remark,
RemarkPerson = o.RemarkPerson,
RoleName = r.RoleName,//uh.GetUserRole(o.ABi_Admin_User_ID ?? 0).RoleName,
Username = o.ABi_Admin_User_ID == null ? o.RemarkPerson : u.Username,//uh.getUsersByID(o.ABi_Admin_User_ID ?? 0)[0].Username,
DateCreated = o.DateCreated,
RoleID = o.ABi_Admin_Role_ID ?? 0,
UserID = o.ABi_Admin_User_ID
}).ToList();
}
catch (Exception ex)
{
logger.LogError(ex.Message);
}
return result;
}
