public DashBoardVM GetHouseOnMapDetails(int AppId)
{
DashBoardVM model = new DashBoardVM();
try
{
using (var db = new PropertyTaxCollectionCMSChild_Entities(AppId))
{
//DevSwachhBharatMainEntities dbm = new DevSwachhBharatMainEntities();
//var appdetails = dbm.AppDetails.Where(c => c.AppId == AppID).FirstOrDefault();
//List<ComplaintVM> obj = new List<ComplaintVM>();
//if (AppID == 1)
//{
// string json = new WebClient().DownloadString(appdetails.Grampanchayat_Pro + "/api/Get/Complaint?appId=1");
// obj = JsonConvert.DeserializeObject<List<ComplaintVM>>(json).Where(c => Convert.ToDateTime(c.createdDate2).ToString("dd/MM/yyyy") == DateTime.Now.ToString("dd/MM/yyyy")).ToList();
//}
var data = db.SP_HouseTaxCollection_Count().First();
//var date = DateTime.Today;
//var houseCount = db.SP_TotalHouseCollection_Count(date).FirstOrDefault();
if (data != null)
{
model.TotalHouseCount = data.TotalHouseCount;
model.HouseCollection = data.TotalHouseLatLongCount;
// model.TotalScanHouseCount = data.TotalScanHouseCount;
model.TaxPaymentCount = data.TaxPaymentCount;
model.TaxReceiptCount = data.TaxReceiptCount;
model.TaxReminderCount = data.TaxReminderCount;
// model.NotSpecified = data.NotSpecified;
return(model);
}
// String.Format("{0:0.00}", 123.4567);
else
{
return(model);
}
}
}
catch (Exception ex)
{
return(model);
}
}
public AppService(int AppId)
{
db = new PropertyTaxCollectionCMSChild_Entities(AppId);
dbMain = new PropertyTaxCollectionCMSMain_Entities();
}
public List <TaxReceiptDetailsVM> getTaxReceiptReport(int q, string fromDate, string toDate, int AppId)
{
List <TaxReceiptDetailsVM> Result = new List <TaxReceiptDetailsVM>();
DateTime _fromDate = DateTime.ParseExact(fromDate, "d/M/yyyy", CultureInfo.InvariantCulture);
DateTime _fdate = new DateTime(_fromDate.Year, _fromDate.Month, _fromDate.Day, 00, 00, 00, 000); //Today at 00:00:00
DateTime Dateeee = DateTime.ParseExact(toDate, "d/M/yyyy", CultureInfo.InvariantCulture);
DateTime _tdate = new DateTime(Dateeee.Year, Dateeee.Month, Dateeee.Day, 23, 59, 59, 999); // Dateeee.AddDays(1).AddTicks
using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities())
{
PropertyTaxCollectionCMSChild_Entities db1 = new PropertyTaxCollectionCMSChild_Entities(AppId);
var house = db1.HouseMasters.ToList();
var AD_USER_MST = db.AD_USER_MST.ToList();
var TAX_COLLECTION_DETAIL = db.TAX_COLLECTION_DETAIL.Where(c => c.PAYMENT_DATE >= _fdate & c.PAYMENT_DATE < _tdate & c.TCAT_ID == q).ToList();
var sqlData = (from TC in TAX_COLLECTION_DETAIL
join UM in AD_USER_MST on TC.ADUM_USER_CODE equals
UM.ADUM_USER_CODE
join HS in house on TC.HOUSEID equals
HS.houseId
select new
{
ADUM_USER_NAME = UM.ADUM_USER_NAME,
PAYMENT_DATE = TC.PAYMENT_DATE,
TC_ID = TC.TC_ID,
TCAT_ID = TC.TCAT_ID,
RECEIPT_NO = TC.RECIPT_NO,
houseOwner = HS.houseOwner,
TOTAL_AMOUNT = TC.TOTAL_AMOUNT,
RECEIVED_AMOUNT = TC.RECEIVED_AMOUNT,
REMAINING_AMOUNT = TC.REMAINING_AMOUNT,
HOUSEID = TC.HOUSEID,
RECEIVER_NAME = TC.RECEIVER_NAME,
RECEIVER_SIGNATURE = TC.RECEIVER_SIGNATURE_IMAGE,
}).ToList();
foreach (var x in sqlData)
{
Result.Add(new TaxReceiptDetailsVM()
{
ADUM_USER_NAME = x.ADUM_USER_NAME,
TC_ID = x.TC_ID,
TCAT_ID = x.TCAT_ID,
RECEIPT_NO = x.RECEIPT_NO,
House_Owner_NAME = x.houseOwner,
PAYMENT_DATE = Convert.ToDateTime(x.PAYMENT_DATE).ToString("dd/MM/yyyy hh:mm tt"),
TOTAL_AMOUNT = Convert.ToDecimal(x.TOTAL_AMOUNT),
RECEIVED_AMOUNT = Convert.ToDecimal(x.RECEIVED_AMOUNT),
REMAINING_AMOUNT = Convert.ToDecimal(x.REMAINING_AMOUNT),
HOUSEID = x.HOUSEID,
RECEIVER_NAME = x.RECEIVER_NAME,
RECEIVER_SIGNATURE = x.RECEIVER_SIGNATURE,
});
}
}
return(Result);
}
