public ActionResult AgentTotalDetail(int id)
{
OpdMedicalProvider OMPro = new OpdMedicalProvider();
OpdMedicalDetailModel model = new OpdMedicalDetailModel();
model.OpdMedicalDetailList = OMPro.GetAgentDetail(id);
return(View(model));
}
public List <OpdMedicalDetailModel> GetAgentAndtotalAmount()
{
using (EHMSEntities ent = new EHMSEntities())
{
List <OpdMedicalDetailModel> model = new List <OpdMedicalDetailModel>();
var getopdid = (from b in ent.OpdMedicalDetails
select b.AgentId).Distinct().ToList();
foreach (var item in getopdid)
{
OpdMedicalDetailModel obj = new OpdMedicalDetailModel();
obj.AgentId = AutoMapper.Mapper.Map <IEnumerable <OpdMedicalDetail>, IEnumerable <OpdMedicalDetailModel> >(ent.OpdMedicalDetails).Where(x => x.AgentId == item).Select(x => x.AgentId).FirstOrDefault();
obj.Amount = AutoMapper.Mapper.Map <IEnumerable <OpdMedicalDetail>, IEnumerable <OpdMedicalDetailModel> >(ent.OpdMedicalDetails).Where(x => x.AgentId == item).Sum(x => x.Commission);
model.Add(obj);
}
return(model);
}
}
public List <OpdModel> Getlist()
{
using (EHMSEntities ent = new EHMSEntities())
{
List <OpdModel> model = new List <OpdModel>();
var getopdid = (from b in ent.OpdMedicalDetails
join l in ent.OpdMasters on b.OpdMasterId equals l.OpdID
select b).ToList();
foreach (var item in getopdid)
{
OpdModel obj = new OpdModel();
obj = AutoMapper.Mapper.Map <IEnumerable <OpdMaster>, IEnumerable <OpdModel> >(ent.OpdMasters).Where(x => x.OpdID == item.OpdMasterId).SingleOrDefault();
model.Add(obj);
}
foreach (var item1 in model)
{
var data = ent.OpdMedicalDetails.Where(x => x.OpdMasterId == item1.OpdID).FirstOrDefault();
if (data != null)
{
OpdMedicalDetailModel m = new OpdMedicalDetailModel()
{
OpdMasterId = data.OpdMasterId,
OpdMedicalDetailId = data.OpdMedicalDetailId,
ManPowerId = data.ManPowerId,
AgentId = data.AgentId,
PreHolo = data.PreHolo,
Amount = data.Amount,
Commission = data.Commission,
CreatedDate = data.CreatedDate,
CreatedBy = data.CreatedBy,
status = data.status
};
item1.OpdMedicalDetailModel = m;
}
}
return(model);
}
}
