public static List <WebConnection.Services.CustomerService> ReturnCustomerOperation(int Shmo, string FromDate = "", string ToDate = "")
{
using (var context = new WebConnection.Model.WebEntities())
{
var FinalResult = new List <WebConnection.Services.CustomerService>();
Nullable <decimal> actBed = 0;
Nullable <decimal> actBes = 0;
string tashkhis = "--";
IQueryable <WebConnection.Model.cust_act> Result = context.cust_act.Where(a => a.shmo == Shmo).OrderBy(i => i.date);
if (FromDate != string.Empty)
{
Result = Result.Where(a => a.date.CompareTo(FromDate) >= 0);
actBed = context.cust_act.AsNoTracking().Where(i => i.shmo == Shmo & i.date.CompareTo(FromDate) < 0 & i.isActive != false).Sum(i => (Nullable <decimal>)i.act_bed);
actBes = context.cust_act.AsNoTracking().Where(i => i.shmo == Shmo & i.date.CompareTo(FromDate) < 0 & i.isActive != false).Sum(i => (Nullable <decimal>)i.act_bes);
tashkhis = actBed > actBes ? "بد" : actBes > actBed ? "بس" : "--";
FinalResult.Add(new Services.CustomerService
{
Date = "--",
UserName = "******",
Explain = "حساب قبلي",
Bed = actBed ?? 0,
Bes = actBes ?? 0,
BedSubBes = (actBed ?? 0) - (actBes ?? 0),
Status = tashkhis,
Ghno = 0,
ActID = 0,
RowID = 0,
MainRowID = 0,
});
}
if (ToDate != string.Empty)
{
Result = Result.Where(a => a.date.CompareTo(ToDate) <= 0);
}
FinalResult.AddRange((from read in Result
select new WebConnection.Services.CustomerService
{
Date = read.date,
UserName = read.user_id,
Explain = read.act_dis,
Bed = read.act_bed,
Bes = read.act_bes,
BedSubBes = 0,
Status = string.Empty,
Ghno = read.ghno,
ActID = read.act_id,
RowID = 0,
MainRowID = read.rdf_,
}).ToList());
int j = 0;
FinalResult = FinalResult.OrderBy(a => a.MainRowID).OrderBy(a => a.Date).ToList();
FinalResult.ForEach(a => a.RowID = j++);
FinalResult.ForEach(a => a.BedSubBes = (a.RowID >= 1 ? (FinalResult.Single(b => b.RowID == a.RowID - 1).BedSubBes) : 0) + a.Bed - a.Bes);
FinalResult.ForEach(a => a.Status = a.BedSubBes > 0 ? "بد" : a.BedSubBes < 0 ? "بس" : "--");
FinalResult.ForEach(a => a.BedSubBes = Math.Abs(a.BedSubBes));
return(FinalResult);
}
}
public static WebConnection.Services.CustomerService ReturnCustomerInstance(int Shmo)
{
using (var context = new WebConnection.Model.WebEntities())
{
var Res = context.CUSTOMERS.Single(a => a.SHMO == Shmo);
return(new WebConnection.Services.CustomerService
{
AbsMan = Math.Abs(Res.man),
Address = Res.addre,
Cell = Res.cell,
CustomerCode = Res.code,
CustomerGroupID = Res.group_rdf,
CustomerID = Res.SHMO,
CustomerName = Res.MONAME,
RealMan = Res.man,
Status = Res.man > 0 ? "بدهكار" : Res.man < 0 ? "بستانكار" : "--",
Tell1 = Res.tell1,
});
}
}
public static List <WebConnection.Services.CustomerService> ReturnCustomerList()
{
using (var context = new WebConnection.Model.WebEntities())
{
var Res = context.CUSTOMERS.AsNoTracking();
return((from read in Res
select new WebConnection.Services.CustomerService
{
AbsMan = Math.Abs(read.man),
Address = read.addre,
Cell = read.cell,
CustomerCode = read.code,
CustomerGroupID = read.group_rdf,
CustomerID = read.SHMO,
CustomerName = read.MONAME,
RealMan = read.man,
Status = read.man > 0 ? "بدهكار" : read.man < 0 ? "بستانكار" : "--",
Tell1 = read.tell1,
}).Take(100).ToList());
}
}
