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); }