public ClientVM getClientDetailsByID(int q) { ClientVM data = new ClientVM(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var obj = db.APP_DETAILS.Where(c => c.AppId == q).FirstOrDefault(); if (obj != null) { data.AppName = obj.AppName; data.AppName_mar = obj.AppName_mar; data.State = Convert.ToInt32(obj.State); data.District = Convert.ToInt32(obj.District); data.Tehsil = Convert.ToInt32(obj.Tehsil); data.EmailId = obj.EmailId; data.website = obj.website; data.baseImageUrlCMS = obj.baseImageUrlCMS; data.baseImageUrl = obj.baseImageUrl; data.basePath = obj.basePath; data.Latitude = obj.Latitude; data.Logitude = obj.Logitude; data.AppVersion = obj.AppVersion; data.IsActive = Convert.ToBoolean(obj.IsActive); data.ForceUpdate = Convert.ToBoolean(obj.ForceUpdate); } } return(data); }
public List <DashBoardVM> getAttendenceDetailsOnMap(int AppID) { List <DashBoardVM> Result = new List <DashBoardVM>(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var UserAttendence = (from EA in db.EMPLOYEE_ATTENDANCE join UM in db.AD_USER_MST on EA.ADUM_USER_CODE equals UM.ADUM_USER_CODE where EntityFunctions.TruncateTime(EA.DA_START_DATETIME) == EntityFunctions.TruncateTime(DateTime.Now) & EA.APP_ID == AppID & EA.DA_END_DATETIME == null select new { UserName = UM.ADUM_USER_NAME, InTime = EA.DA_START_DATETIME, InLat = EA.START_LAT, InLong = EA.START_LONG, }).ToList(); foreach (var x in UserAttendence) { Result.Add(new DashBoardVM() { UserName = x.UserName, InTime = Convert.ToDateTime(x.InTime).ToString("hh:mm tt"), InLat = x.InLat.ToString(), InLong = x.InLong.ToString(), }); } } return(Result); }
public AppDetailsVM GetApplicationDetails(int AppId) { using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { AppDetailsVM model = new AppDetailsVM(); var appDetails = (db.APP_DETAILS.Where(x => x.AppId == AppId).FirstOrDefault()); if (appDetails != null) { model.AppId = appDetails.AppId; model.AppName = appDetails.AppName; model.State = appDetails.State; model.Tehsil = appDetails.Tehsil; model.District = appDetails.District; model.EmailId = appDetails.EmailId; model.website = appDetails.website; model.Android_GCM_pushNotification_Key = appDetails.Android_GCM_pushNotification_Key; model.AppVersion = appDetails.AppVersion; model.ForceUpdate = appDetails.ForceUpdate; model.IsActive = appDetails.IsActive; model.CreatedDate = DateTime.Now; return(model); } else { return(null); } } }
public EmployeeVM getEmployeeDetailsByID(int q) { EmployeeVM data = new EmployeeVM(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var task = db.AD_USER_MST.Where(c => c.ADUM_USER_CODE == q).FirstOrDefault(); if (task != null) { data.ADUM_USER_CODE = task.ADUM_USER_CODE; data.SERVER_ID = Convert.ToByte(task.SERVER_ID); data.APP_ID = task.APP_ID; data.ADUM_USER_ID = task.ADUM_LOGIN_ID; data.ADUM_USER_NAME = task.ADUM_USER_NAME; data.ADUM_LOGIN_ID = task.ADUM_LOGIN_ID; data.ADUM_PASSWORD = task.ADUM_PASSWORD; data.ADUM_EMPLOYEE_ID = task.ADUM_EMPLOYEE_ID; data.ADUM_DESIGNATION = task.ADUM_DESIGNATION; data.ADUM_MOBILE = task.ADUM_MOBILE; data.ADUM_EMAIL = task.ADUM_EMAIL; data.LOCAL_USER_NAME = task.LOCAL_USER_NAME; data.PROFILE_IMAGE = "/Images/" + task.PROFILE_IMAGE; data.UPDATE_FLAG = Convert.ToBoolean(task.UPDATE_FLAG); data.AD_USER_TYPE_ID = Convert.ToInt32(task.AD_USER_TYPE_ID); data.IS_ACTIVE = Convert.ToBoolean(task.IS_ACTIVE); } } return(data); }
public List <AttendanceDetailsVM> getAttendenceDetails() { List <AttendanceDetailsVM> Result = new List <AttendanceDetailsVM>(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var UserAttendence = (from EA in db.EMPLOYEE_ATTENDANCE join UM in db.AD_USER_MST on EA.ADUM_USER_CODE equals UM.ADUM_USER_CODE where EntityFunctions.TruncateTime(EA.DA_START_DATETIME) == EntityFunctions.TruncateTime(DateTime.Now) select new { UserName = UM.ADUM_USER_NAME, StartDate = EA.DA_START_DATETIME, EndDate = EA.DA_END_DATETIME, InLat = EA.START_LAT, InLong = EA.END_LAT, }).ToList(); foreach (var x in UserAttendence) { Result.Add(new AttendanceDetailsVM() { UserName = x.UserName, StartDate = Convert.ToDateTime(x.StartDate).ToString("dd/MM/yyyy"), StartTime = Convert.ToDateTime(x.StartDate).ToString("hh:mm tt"), EndDate = (x.EndDate == null ? "" : Convert.ToDateTime(x.EndDate).ToString("dd/MM/yyyy")), EndTime = (x.EndDate == null ? "" : Convert.ToDateTime(x.EndDate).ToString("hh:mm tt")), }); } } return(Result); }
public List <TaxReceiptDetailsVM> getTaxReminderReport(int q, string fromDate, string toDate) { 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()) { var sqlData = (from TC in db.TAX_COLLECTION_DETAIL //join UM in db.AD_USER_MST on EA.ADUM_USER_CODE equals UM.ADUM_USER_CODE where TC.REMINDER_NEW_DATE >= _fdate & TC.REMINDER_NEW_DATE < _tdate select new { TC_ID = TC.TC_ID, TCAT_ID = TC.TCAT_ID, RECEIPT_NO = TC.RECIPT_NO, 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, PAYMENT_DATE = TC.PAYMENT_DATE, }).ToList(); foreach (var x in sqlData) { Result.Add(new TaxReceiptDetailsVM() { TC_ID = x.TC_ID, TCAT_ID = x.TCAT_ID, RECEIPT_NO = x.RECEIPT_NO, 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, PAYMENT_DATE = Convert.ToDateTime(x.PAYMENT_DATE).ToString("dd/MM/yyyy"), }); } } return(Result); }
public List <ClientVM> getClientDetails() { List <ClientVM> result = new List <ClientVM>(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var task = //db.APP_DETAILS.ToList(); (from a in db.APP_DETAILS join b in db.AD_STATE_MST on a.State equals b.STATE_ID join c in db.AD_CITY_MST on a.District equals c.CITY_ID join d in db.AD_TALUKA_MST on a.Tehsil equals d.TALUKA_ID select new { a.AppId, a.AppName, b.STATE_NAME, c.CITY, d.TALUKA_NAME, a.AppVersion, a.ForceUpdate, a.IsActive }).ToList(); foreach (var x in task) { result.Add(new ClientVM() { AppId = x.AppId, AppName = x.AppName, StateName = x.STATE_NAME, TehsilName = x.TALUKA_NAME, DistrictName = x.CITY, AppVersion = x.AppVersion, ForceUpdate = Convert.ToBoolean(x.ForceUpdate), IsActive = Convert.ToBoolean(x.IsActive), }); } } return(result); }
public DashBoardVM DashBoardDetails(int AppId) { DashBoardVM Result = new DashBoardVM(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var UserAttendence = db.EMPLOYEE_ATTENDANCE.Where(c => EntityFunctions.TruncateTime(c.DA_START_DATETIME) == EntityFunctions.TruncateTime(DateTime.Now) & c.DA_END_DATETIME == null & c.APP_ID == AppId).Count(); var TotalUser = db.AD_USER_MST.Where(c => c.APP_ID == AppId).Count(); var TaxReceipt = db.TAX_COLLECTION_DETAIL.Where(c => EntityFunctions.TruncateTime(c.PAYMENT_DATE) == EntityFunctions.TruncateTime(DateTime.Now) & c.TCAT_ID == 1 & c.APP_ID == AppId).Count(); var TaxPayment = db.TAX_COLLECTION_DETAIL.Where(c => EntityFunctions.TruncateTime(c.PAYMENT_DATE) == EntityFunctions.TruncateTime(DateTime.Now) & c.TCAT_ID == 2 & c.APP_ID == AppId).Count(); var Reminder = db.TAX_COLLECTION_DETAIL.Where(c => EntityFunctions.TruncateTime(c.REMINDER_NEW_DATE) == EntityFunctions.TruncateTime(DateTime.Now) & c.APP_ID == AppId).Count(); Result.Attendence = UserAttendence + "/" + TotalUser; Result.TaxReceipt = TaxReceipt.ToString(); Result.TaxPayment = TaxPayment.ToString(); Result.Reminder = Reminder.ToString(); } return(Result); }
public List <TaxReceiptDetailsVM> getTaxReminderDetails(int q) { List <TaxReceiptDetailsVM> Result = new List <TaxReceiptDetailsVM>(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var sqlData = (from TC in db.TAX_COLLECTION_DETAIL //join UM in db.AD_USER_MST on EA.ADUM_USER_CODE equals UM.ADUM_USER_CODE where EntityFunctions.TruncateTime(TC.REMINDER_NEW_DATE) == EntityFunctions.TruncateTime(DateTime.Now) select new { TC_ID = TC.TC_ID, TCAT_ID = TC.TCAT_ID, RECEIPT_NO = TC.RECIPT_NO, 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() { TC_ID = x.TC_ID, TCAT_ID = x.TCAT_ID, RECEIPT_NO = x.RECEIPT_NO, 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); }
public List <SelectListItem> GetDistrictList() { using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var district = new List <SelectListItem>(); SelectListItem itemdistrict = new SelectListItem() { Text = "Select District", Value = "0" }; district = db.AD_CITY_MST.ToList() .Select(x => new SelectListItem { Text = x.CITY, Value = x.CITY_ID.ToString() }).OrderBy(t => t.Text).ToList(); district.Insert(0, itemdistrict); return(district); } }
public List <SelectListItem> GetStateList() { List <SelectListItem> state = new List <SelectListItem>(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { SelectListItem itemstate = new SelectListItem() { Text = "Select State", Value = "0" }; state = db.AD_STATE_MST.ToList() .Select(x => new SelectListItem { Text = x.STATE_NAME, Value = x.STATE_ID.ToString() }).OrderBy(t => t.Text).ToList(); state.Insert(0, itemstate); } return(state); }
public List <SelectListItem> GetTehsilList() { using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var Tehsil = new List <SelectListItem>(); SelectListItem itemTehsil = new SelectListItem() { Text = "Select Tehsil", Value = "0" }; Tehsil = db.AD_TALUKA_MST.ToList() .Select(x => new SelectListItem { Text = x.TALUKA_NAME, Value = x.TALUKA_ID.ToString() }).OrderBy(t => t.Text).ToList(); Tehsil.Insert(0, itemTehsil); return(Tehsil); } }
public List <EmployeeVM> getEmployeeDetails() { List <EmployeeVM> result = new List <EmployeeVM>(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var task = db.AD_USER_MST.ToList(); foreach (var x in task) { result.Add(new EmployeeVM() { ADUM_USER_CODE = x.ADUM_USER_CODE, SERVER_ID = Convert.ToByte(x.SERVER_ID), APP_ID = x.APP_ID, ADUM_USER_ID = x.ADUM_USER_ID, ADUM_USER_NAME = x.ADUM_USER_NAME, ADUM_LOGIN_ID = x.ADUM_LOGIN_ID, ADUM_PASSWORD = x.ADUM_PASSWORD, ADUM_EMPLOYEE_ID = x.ADUM_EMPLOYEE_ID, ADUM_DESIGNATION = x.ADUM_DESIGNATION, ADUM_MOBILE = x.ADUM_MOBILE, ADUM_EMAIL = x.ADUM_EMAIL, LOCAL_USER_NAME = x.LOCAL_USER_NAME, PROFILE_IMAGE = "~/Images/" + x.PROFILE_IMAGE, ADUM_FRDT = Convert.ToDateTime(x.ADUM_FRDT).ToString(), ADUM_TODT = Convert.ToDateTime(x.ADUM_TODT).ToString(), ADUM_STATUS = Convert.ToBoolean(x.ADUM_STATUS), UPDATE_FLAG = Convert.ToBoolean(x.UPDATE_FLAG), LAST_UPDATE = Convert.ToDateTime(x.LAST_UPDATE).ToString(), AD_USER_TYPE_ID = Convert.ToInt32(x.AD_USER_TYPE_ID), MOBILE_ID = x.MOBILE_ID, IS_ACTIVE = Convert.ToBoolean(x.IS_ACTIVE), }); } } return(result); }
public List <AttendanceDetailsVM> getAttendenceReport(string fromDate, string toDate) { List <AttendanceDetailsVM> Result = new List <AttendanceDetailsVM>(); DateTime _fromDate = DateTime.ParseExact(fromDate, "d/M/yyyy", CultureInfo.InvariantCulture); DateTime _fdate = new DateTime(_fromDate.Year, _fromDate.Month, _fromDate.Day, 00, 00, 00, 000); DateTime Dateeee = DateTime.ParseExact(toDate, "d/M/yyyy", CultureInfo.InvariantCulture); DateTime _tdate = new DateTime(Dateeee.Year, Dateeee.Month, Dateeee.Day, 23, 59, 59, 999); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var UserAttendence = (from EA in db.EMPLOYEE_ATTENDANCE join UM in db.AD_USER_MST on EA.ADUM_USER_CODE equals UM.ADUM_USER_CODE where EA.DA_START_DATETIME >= _fdate & EA.DA_START_DATETIME < _tdate orderby EA.DA_ID descending select new { UserName = UM.ADUM_USER_NAME, StartDate = EA.DA_START_DATETIME, EndDate = EA.DA_END_DATETIME, InLat = EA.START_LAT, InLong = EA.END_LAT, }).ToList(); foreach (var x in UserAttendence) { Result.Add(new AttendanceDetailsVM() { UserName = x.UserName, StartDate = Convert.ToDateTime(x.StartDate).ToString("dd/MM/yyyy hh:mm tt"), EndDate = (x.EndDate == null ? "" : Convert.ToDateTime(x.EndDate).ToString("dd/MM/yyyy hh:mm tt")), }); } } return(Result); }
public EmployeeVM Login(EmployeeVM _userinfo) { EmployeeVM _EmployeeVM = new EmployeeVM(); using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var appUser = (db.AD_USER_MST.Where(x => x.ADUM_LOGIN_ID == _userinfo.ADUM_LOGIN_ID && x.ADUM_PASSWORD == _userinfo.ADUM_PASSWORD).FirstOrDefault()); if (appUser != null) { _EmployeeVM.ADUM_LOGIN_ID = appUser.ADUM_LOGIN_ID; _EmployeeVM.APP_ID = appUser.APP_ID; _EmployeeVM.ADUM_USER_NAME = appUser.ADUM_USER_NAME; _EmployeeVM.ADUM_USER_CODE = Convert.ToInt32(appUser.ADUM_USER_CODE); _EmployeeVM.status = "Success"; return(_EmployeeVM); } else { _EmployeeVM.status = "Failure"; return(_EmployeeVM); } } }
public Result EmployeeSave(EmployeeVM _Employee) { Result Result = new Result(); try { using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var obj = db.AD_USER_MST.Where(x => x.ADUM_USER_CODE == _Employee.ADUM_USER_CODE).FirstOrDefault(); if (obj != null) { obj.SERVER_ID = Convert.ToByte(_Employee.SERVER_ID); obj.APP_ID = _Employee.APP_ID; obj.ADUM_USER_ID = _Employee.ADUM_LOGIN_ID; obj.ADUM_USER_NAME = _Employee.ADUM_USER_NAME; obj.ADUM_LOGIN_ID = _Employee.ADUM_LOGIN_ID; obj.ADUM_PASSWORD = _Employee.ADUM_PASSWORD; obj.ADUM_EMPLOYEE_ID = _Employee.ADUM_EMPLOYEE_ID; obj.ADUM_DESIGNATION = _Employee.ADUM_DESIGNATION; obj.ADUM_MOBILE = _Employee.ADUM_MOBILE; obj.ADUM_EMAIL = _Employee.ADUM_EMAIL; obj.LOCAL_USER_NAME = _Employee.LOCAL_USER_NAME; if (_Employee.PROFILE_IMAGE != null) { obj.PROFILE_IMAGE = _Employee.PROFILE_IMAGE; } //obj.ADUM_FRDT = Convert.ToDateTime(_Employee.ADUM_FRDT); //obj.ADUM_TODT = Convert.ToDateTime(_Employee.ADUM_TODT); obj.UPDATE_FLAG = _Employee.UPDATE_FLAG; obj.LAST_UPDATE = DateTime.Now;//Convert.ToDateTime(_Employee.LAST_UPDATE); obj.AD_USER_TYPE_ID = _Employee.AD_USER_TYPE_ID; obj.IS_ACTIVE = _Employee.IS_ACTIVE; } else { AD_USER_MST Master = new AD_USER_MST(); Master.SERVER_ID = Convert.ToByte(_Employee.SERVER_ID); Master.APP_ID = _Employee.APP_ID; Master.ADUM_USER_ID = _Employee.ADUM_LOGIN_ID; Master.ADUM_USER_NAME = _Employee.ADUM_USER_NAME; Master.ADUM_LOGIN_ID = _Employee.ADUM_LOGIN_ID; Master.ADUM_PASSWORD = _Employee.ADUM_PASSWORD; Master.ADUM_EMPLOYEE_ID = _Employee.ADUM_EMPLOYEE_ID; Master.ADUM_DESIGNATION = _Employee.ADUM_DESIGNATION; Master.ADUM_MOBILE = _Employee.ADUM_MOBILE; Master.ADUM_EMAIL = _Employee.ADUM_EMAIL; Master.LOCAL_USER_NAME = _Employee.LOCAL_USER_NAME; Master.PROFILE_IMAGE = _Employee.PROFILE_IMAGE; //Master.ADUM_FRDT = Convert.ToDateTime(_Employee.ADUM_FRDT); //Master.ADUM_TODT = Convert.ToDateTime(_Employee.ADUM_TODT); Master.UPDATE_FLAG = _Employee.UPDATE_FLAG; Master.LAST_UPDATE = DateTime.Now; Master.AD_USER_TYPE_ID = _Employee.AD_USER_TYPE_ID; Master.IS_ACTIVE = _Employee.IS_ACTIVE; db.AD_USER_MST.Add(Master); } db.SaveChanges(); Result.message = "success"; } } catch (Exception ex) { Result.message = "error"; } return(Result); }
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); }
public Result ClientSave(ClientVM _Client) { Result Result = new Result(); try { using (PropertyTaxCollectionCMSMain_Entities db = new PropertyTaxCollectionCMSMain_Entities()) { var obj = db.APP_DETAILS.Where(x => x.AppId == _Client.AppId).FirstOrDefault(); if (obj != null) { obj.AppName = _Client.AppName; obj.AppName_mar = _Client.AppName_mar; obj.State = _Client.State; obj.District = _Client.District; obj.Tehsil = _Client.Tehsil; obj.EmailId = _Client.EmailId; obj.website = _Client.website; obj.baseImageUrlCMS = _Client.baseImageUrlCMS; obj.baseImageUrl = _Client.baseImageUrl; obj.basePath = _Client.basePath; obj.Latitude = _Client.Latitude; obj.Logitude = _Client.Logitude; obj.AppVersion = _Client.AppVersion; obj.IsActive = _Client.IsActive; obj.ForceUpdate = _Client.ForceUpdate; } else { APP_DETAILS Master = new APP_DETAILS(); Master.AppName = _Client.AppName; Master.AppName_mar = _Client.AppName_mar; Master.State = _Client.State; Master.District = _Client.District; Master.Tehsil = _Client.Tehsil; Master.EmailId = _Client.EmailId; Master.website = _Client.website; Master.baseImageUrlCMS = _Client.baseImageUrlCMS; Master.baseImageUrl = _Client.baseImageUrl; Master.basePath = _Client.basePath; Master.Latitude = _Client.Latitude; Master.Logitude = _Client.Logitude; Master.AppVersion = _Client.AppVersion; Master.IsActive = _Client.IsActive; Master.ForceUpdate = _Client.ForceUpdate; db.APP_DETAILS.Add(Master); } db.SaveChanges(); Result.message = "success"; } } catch { Result.message = "error"; } return(Result); }
public AppService(int AppId) { db = new PropertyTaxCollectionCMSChild_Entities(AppId); dbMain = new PropertyTaxCollectionCMSMain_Entities(); }
public DBMain() { dbMain = new PropertyTaxCollectionCMSMain_Entities(); }