public bool UpdateIncomingClaim(IncomingClaims Claim)
{
if (Claim != null)
{
_session.Transact(session => session.Update(Claim));
return(true);
}
else
{
return(false);
}
}
public bool ReceiveNewIncomingClaim(IncomingClaims claim)
{
if (claim != null)
{
_session.Transact(session => session.Save(claim));
//claims Department
//var notification = _helpersvc.GetNotificationTable(4);
//send notification for each guy in the role to notify that a new staff was added.
//_helpersvc.PushUserNotification(_userService.GetUser(claim.receivedBy).Guid.ToString().ToLower(), String.Format("New Claim [{1}] was received from {0} .", _providersvc.GetProvider(claim.providerid).Name, claim.Id), Utility.NotificationTarget.User, string.Empty, Utility.NotificationType.Persistent, UniquePageHelper.GetUrl<Pages.IncomingClaimsPage>());
return(true);
}
return(false);
}
public IncomingClaims getincomingClaimByMonthandYear(int providerid, int month, int year)
{
string monthstring = month.ToString();
IQueryOver <IncomingClaims, IncomingClaims> query = _session.QueryOver <IncomingClaims>().Where(x => x.IsDeleted == false && x.month_string == monthstring && x.year == year && x.providerid == providerid && x.IsRemoteSubmission == true);
IncomingClaims response = new IncomingClaims();
if (query.RowCount() > 0)
{
foreach (IncomingClaims item in query.List().OrderByDescending(x => x.CreatedOn))
{
if (item.ClaimBatch.status == ClaimBatchStatus.Capturing)
{
//found our guy
response = item;
break;
}
}
}
return(response);
}
public IList <IncomingClaims> QueryAllIncomingClaims(out int totalRecord, out int totalcountinresult, string search, int start, int lenght, string sortColumn, string sortOrder, int scrProvider, int addedBy, string scrDeliveredBy, int month, int year, int transferedTo, bool useDate, DateTime scrFromDate, DateTime scrToDate, int otherFilters, int trackingid)
{
IQueryOver <IncomingClaims, IncomingClaims> query = _session.QueryOver <IncomingClaims>().Where(x => x.IsDeleted == false);
//if(addedBy > -1)
//{
// query.Where(x => x.receivedBy == addedBy);
//}
if (scrProvider > -1)
{
query.Where(x => x.providerid == scrProvider);
}
//added else
else
{
}
if (!string.IsNullOrEmpty(scrDeliveredBy))
{
query.Where(x => x.deliveredby == scrDeliveredBy.ToUpper() && x.deliveredby == scrDeliveredBy.ToLower());
}
else
{
}
if (useDate)
{
DateTime datete = Convert.ToDateTime(scrToDate);
int dd = datete.Day;
int dmonth = datete.Month;
int dyear = datete.Year;
string time = "23:59";
DateTime enddate = Convert.ToDateTime(string.Format("{0}/{1}/{2} {3}", dmonth, dd, dyear, time));
query.Where(Restrictions.On <Enrollee>(a => a.CreatedOn).IsBetween(scrFromDate).And(enddate));
}
else
{
}
if (year > -1 && trackingid < 0)
{
query.Where(x => x.year == year);
}
else
{
}
if (month > -1)
{
//query.Where(x => x.month == month);
string monthstr = month.ToString();
query.WhereRestrictionOn(x => x.month_string).IsInsensitiveLike(monthstr, MatchMode.Anywhere);
//if(query.WhereRestrictionOn(x => x.month_string).IsInsensitiveLike(",", MatchMode.Anywhere).RowCount() > 0)
//{
// //contains the coma guys
// foreach(var item in )
// var states = (List<int>)query.WhereRestrictionOn(x => x.month_string).IsInsensitiveLike(",", MatchMode.Anywhere).SelectList(a => a.Select(p => p.Id)).List<int>();
//}
}
//added else
else
{
}
if (trackingid > -1)
{
IList <Entities.ClaimBatch> claimlist = _session.QueryOver <Entities.ClaimBatch>().Where(v => v.Id == trackingid).List <Entities.ClaimBatch>();
List <int> intlist = new List <int>();
if (claimlist.Any())
{
IncomingClaims first = claimlist.FirstOrDefault().IncomingClaims.FirstOrDefault();
if (first != null)
{
intlist.Add(first.Id);
}
//added else
else
{
}
}
query.WhereRestrictionOn(x => x.Id).IsIn(intlist);
}
totalRecord = query.RowCount();
totalcountinresult = totalRecord;
IList <IncomingClaims> list = query.OrderBy(x => x.CreatedOn).Desc.Skip(start).Take(lenght).List();
return(list);
}
public static string GetClaimsNarrations(Entities.ClaimBatch batch)
{
//if (batch == null)
//{
// return "";
//}
//var incomingclaimsorder = batch.Claims.OrderBy(x => x.ServiceDate);
//var response = "";
//var year = new List<int>();
//foreach (var item in incomingclaimsorder)
//{
// if (!year.Contains(Convert.ToDateTime(item.ServiceDate).Year) && Convert.ToDateTime(item.ServiceDate).Year > 2014)
// {
// year.Add(Convert.ToDateTime(item.ServiceDate).Year);
// }
//}
//var count = 0;
//foreach (var item in year)
//{
// if (count > 0)
// {
// response = response + "|";
// }
// count++;
// var monthlist = new List<int>();
// var claimsforyear = incomingclaimsorder.Where(x => Convert.ToDateTime(x.ServiceDate).Year == item).OrderBy(x => x.ServiceDate);
// foreach (var itemo in claimsforyear)
// {
// if (!monthlist.Contains(Convert.ToDateTime(itemo.ServiceDate).Month))
// {
// monthlist.Add(Convert.ToDateTime(itemo.ServiceDate).Month);
// }
// }
// foreach (var month in monthlist)
// {
// response = response + string.Format("{0},", CurrentRequestData.CultureInfo.DateTimeFormat.GetMonthName(month));
// }
// response = response + " " + item.ToString();
//}
string response = "";
IncomingClaims income = batch.IncomingClaims.FirstOrDefault();
if (income != null)
{
if (!string.IsNullOrEmpty(income.month_string) && income.month_string.Split(',').Count() > 0)
{
foreach (string itemmm in income.month_string.Split(','))
{
response = response + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToInt32(itemmm)) + ",";
}
response = response + income.year.ToString();
}
}
return(response);
}
