public static int UpdateBatch(Batches batch) { using (VedantaEntities ve = new VedantaEntities()) { //Batches oldBatch = ve.Batches.FirstOrDefault(bt => bt.Id != batch.Id && !bt.BatchCode.Equals(batch.BatchCode, StringComparison.OrdinalIgnoreCase)); //if (oldBatch == null) //{ Batches currentBatch = ve.Batches.FirstOrDefault(bt => bt.Id == batch.Id); if (currentBatch != null) { currentBatch.BatchCode = batch.BatchCode; currentBatch.BatchStartTime = batch.BatchStartTime; currentBatch.BatchEndTime = batch.BatchEndTime; currentBatch.BatchName = batch.BatchName; currentBatch.StudentStrength = batch.StudentStrength; int result = ve.SaveChanges(); if (result > 0) { return(result); } } //} return(0); } }
public static List <vw_BatchList> GetBatchList(int clientId, int branchId) { using (VedantaEntities ve = new VedantaEntities()) { return(ve.vw_BatchList.Where(bt => bt.ClientId == clientId && bt.BranchId == branchId).ToList()); } }
public static List <vw_BatchList> GetBatchList() { using (VedantaEntities ve = new VedantaEntities()) { return(ve.vw_BatchList.ToList()); } }
public static Batches GetBatchDetailsById(int id) { using (VedantaEntities ve = new VedantaEntities()) { return(ve.Batches.FirstOrDefault(b => b.Id == id)); } }
public static List <vw_CourseBrands> GetCourseBrands(int clientId, int?branchId) { try { using (VedantaEntities ve = new VedantaEntities()) { if (branchId != null) { // Course List of Selected school return((from courseBrands in ve.vw_CourseBrands where courseBrands.ClientId == clientId && courseBrands.BranchId == (int)branchId select courseBrands).ToList()); } else { // Course List of all schools return((from courseBrands in ve.vw_CourseBrands where courseBrands.ClientId == clientId select courseBrands).ToList()); } } } catch { return(null); } }
public static List <vw_Users_Lists> GetUsersList() { using (VedantaEntities ve = new VedantaEntities()) { return(ve.vw_Users_Lists.ToList()); } }
public static int UpdateCourse(int id, Courses course) { try { using (VedantaEntities islObject = new VedantaEntities()) { Courses updated = islObject.Courses.FirstOrDefault(jc => jc.Id == id); if (updated != null) { updated.CourseName = course.CourseName; updated.Duration_In_Months = course.Duration_In_Months; updated.FastTrackDuration = course.FastTrackDuration; updated.CourseFees = course.CourseFees; updated.MinimumDownPayment = course.MinimumDownPayment; updated.MaximumDiscountAmount = course.MaximumDiscountAmount; updated.MaximumNumberOfInstallments = course.MaximumNumberOfInstallments; updated.InstallmentAmount = course.InstallmentAmount; updated.CourseCode = course.CourseCode; updated.TotalInstallmentAmount = course.TotalInstallmentAmount; return(islObject.SaveChanges()); } } } catch { return(0); } return(0); }
public static List <vw_Users_Lists> GetUsersList(int clientId, int zoneId, int regionId) { using (VedantaEntities ve = new VedantaEntities()) { return(ve.vw_Users_Lists.Where(ul => ul.ClientId == clientId && ul.ZoneId == zoneId && ul.RegionId == regionId).ToList()); } }
public static List <SearchedEmployees> GetSearchedEmployeesList(string searchText) { using (VedantaEntities ve = new VedantaEntities()) { List <SearchedEmployees> empAll = (from empls in ve.vw_Employees where ( empls.EmployeeId.StartsWith(searchText) || empls.FirstName.StartsWith(searchText) || empls.LastName.StartsWith(searchText) || empls.City.StartsWith(searchText) || empls.BranchName.StartsWith(searchText) || empls.BranchCode.StartsWith(searchText) || empls.RankName.StartsWith(searchText) || empls.State.StartsWith(searchText) ) select new SearchedEmployees { Name = (empls.FirstName + " " + (empls.MiddleName ?? string.Empty) + " " + (empls.LastName ?? string.Empty)), Id = empls.EmployeeId, City = empls.City, State = empls.State, Branch = empls.BranchName, Designation = empls.RankName }).ToList(); return(empAll); } }
public static vw_Users_Lists GetUserDetailsByUserName(string usrName) { using (VedantaEntities ve = new VedantaEntities()) { return(ve.vw_Users_Lists.FirstOrDefault(u => u.UserName.Equals(usrName, StringComparison.OrdinalIgnoreCase))); } }
public static List <vw_Courses> GetCourses(int clientId, int courseBrandId, int?schoolId) { try { using (VedantaEntities islObject = new VedantaEntities()) { if (schoolId != null) { // Course List of Selected school return((from courses in islObject.vw_Courses where courses.ClientId == clientId && courses.CourseBrandId == courseBrandId && courses.BranchId == (int)schoolId select courses).ToList()); } else { // Course List of all schools return((from courses in islObject.vw_Courses where courses.ClientId == clientId && courses.CourseBrandId == courseBrandId select courses).ToList()); } } } catch { return(null); } }
public static List <vw_PaymentList> GetPaymentList(int clinetId, int branchId, int paymentType, bool isBranchSession = false) { using (VedantaEntities deo = new VedantaEntities()) { bool canSeeFrenchisesRecord = false; ClientSettings clientSettings = deo.ClientSettings.FirstOrDefault(cs => cs.ClientId == clinetId); if (clientSettings != null) { canSeeFrenchisesRecord = clientSettings.CanSeeFrenchisesAccount ?? true; } if (isBranchSession == true || canSeeFrenchisesRecord == true) { return((from payment in deo.vw_PaymentList where payment.ClientId == clinetId && payment.LedgerTypeId == paymentType && payment.BranchId == branchId select payment).ToList()); } else { return((from payment in deo.vw_PaymentList where payment.ClientId == clinetId && payment.LedgerTypeId == paymentType && payment.BranchId == branchId && payment.BranchTypeId == 1 select payment).ToList()); } } }
public static SelectList GetRoleList(string[] rolesToHide) { using (VedantaEntities ve = new VedantaEntities()) { // string showAdmin = System.Web.Configuration.WebConfigurationManager.AppSettings["ShowAdminRole"]; List <UserRoles> rolesList = new List <UserRoles>(); if (rolesToHide != null && rolesToHide.Count() > 0) { rolesList = (from roles in ve.aspnet_Roles where !rolesToHide.Contains(roles.LoweredRoleName) select new UserRoles { RoleId = roles.RoleId, UserRole = roles.RoleName } ).ToList(); } else { rolesList = (from roles in ve.aspnet_Roles select new UserRoles { RoleId = roles.RoleId, UserRole = roles.RoleName } ).ToList(); } return(new SelectList(rolesList, "roleId", "UserRole")); } }
public static EXPENSESHEAD GetLedgerDetailsByLedgerId(int expId) { using (VedantaEntities deo = new VedantaEntities()) { return(deo.EXPENSESHEAD.FirstOrDefault(exp => exp.Id == expId)); } }
public static List <vw_PaymentList> GetHeadWisePaymentList(int clinetId, int paymentType, int headId, DateTime fromDate, DateTime DateTo) { using (VedantaEntities deo = new VedantaEntities()) { bool canSeeFrenchisesRecord = false; ClientSettings clientSettings = deo.ClientSettings.FirstOrDefault(cs => cs.ClientId == clinetId); if (clientSettings != null) { canSeeFrenchisesRecord = clientSettings.CanSeeFrenchisesAccount ?? true; } if (canSeeFrenchisesRecord == false) { return((from payment in deo.vw_PaymentList where payment.ClientId == clinetId && payment.LedgerTypeId == paymentType && payment.ExpenseHeadId == headId && (payment.BranchId == null || (payment.BranchId != null && payment.BranchTypeId == 1)) && payment.Date >= fromDate.Date && payment.Date <= DateTo.Date select payment).ToList()); } else { return((from payment in deo.vw_PaymentList where payment.ClientId == clinetId && payment.LedgerTypeId == paymentType && payment.ExpenseHeadId == headId && payment.Date >= fromDate.Date && payment.Date <= DateTo.Date select payment).ToList()); } } }
public static int EditPayment(Payments payment) { using (VedantaEntities deo = new VedantaEntities()) { if (payment != null) { Payments oldPayment = deo.Payments.FirstOrDefault(py => py.Id == payment.Id); if (oldPayment != null) { Payments existingPayment = deo.Payments.FirstOrDefault(py => py.BranchId == payment.BranchId && py.Id != payment.Id && payment.Date == py.Date && payment.VoucherNo.Equals(py.VoucherNo, StringComparison.OrdinalIgnoreCase)); if (existingPayment == null) { oldPayment.Amounts = payment.Amounts; oldPayment.BANK = payment.BANK; oldPayment.BranchId = payment.BranchId; oldPayment.CHQ_DATE = payment.CHQ_DATE; oldPayment.CHQ_NO = payment.CHQ_NO; oldPayment.Date = payment.Date; oldPayment.ExpenseHeadId = payment.ExpenseHeadId; oldPayment.Narration = payment.Narration; oldPayment.PaidTo = payment.PaidTo; oldPayment.PaymentModeId = payment.PaymentModeId; oldPayment.Remarks = payment.Remarks; oldPayment.VoucherNo = payment.VoucherNo; return(deo.SaveChanges()); } else { return(-1);//same voucher number and same date exits for this branch. } } } } return(0); }
public static int AddEmployee(Employees emp) { using (VedantaEntities ve = new VedantaEntities()) { Employees oldEmp = ve.Employees.FirstOrDefault(e => emp.EmployeeId.Equals(e.EmployeeId)); if (oldEmp == null) { if (emp.BranchId != null) { Utilities.BranchRegionZones brz = Utilities.GetRegionAndZoneByBranchId(emp.BranchId.Value); if (brz != null && brz.ZoneId > 0 && brz.RegionId > 0) { emp.RegionId = brz.RegionId; emp.ZoneId = brz.ZoneId; } } if (emp.RegionId != null) { emp.ZoneId = Utilities.GetRegionZoneId(emp.RegionId.Value); } emp.IsActive = true; emp.CreatedDate = DateTime.Now.Date; ve.AddToEmployees(emp); return(ve.SaveChanges()); } else { return(-1); } } }
public static List <vw_PaymentList> GetExpenseSummary(int clinetId, int branchId, int paymentType) { using (VedantaEntities deo = new VedantaEntities()) { // return deo.vw_PaymentList.Where(pl => pl.ClientId == clinetId && pl.BranchId == branchId && pl.LedgerTypeId == paymentType).GroupBy(p => new { p.Date, p.ExpenseHeadName }).ToList(); } return(null); }
public static List <vw_ExpenseHeads> GetLedgerMasterList() { using (VedantaEntities deo = new VedantaEntities()) { return((from ledger in deo.vw_ExpenseHeads select ledger).OrderBy(ld => ld.LedgerType).ToList()); } }
public static List <vw_Student_Lists> GetStudentsList() { using (VedantaEntities ve = new VedantaEntities()) { return((from stds in ve.vw_Student_Lists select stds).ToList()); } }
public static int PayStudentFees(FeeCollections newFees) { using (VedantaEntities ve = new VedantaEntities()) { ve.AddToFeeCollections(newFees); return(ve.SaveChanges()); } }
public static List <vw_Branches> GetBranchesList() { using (VedantaEntities ve = new VedantaEntities()) { return((from br in ve.vw_Branches select br).ToList()); } }
public static List <vw_FeeCollections> GetStudentsPaidFeesByAdmissionId(int admissionId) { using (VedantaEntities ve = new VedantaEntities()) { return((from stds in ve.vw_FeeCollections where stds.AdmissionId == admissionId select stds).ToList()); } }
public static List <vw_Admissions> GetStudentsListByCourseId(int courseId) { using (VedantaEntities ve = new VedantaEntities()) { return((from stds in ve.vw_Admissions where stds.CourseId == courseId select stds).ToList()); } }
public static List <vw_Student_Lists> GetClientStudentsList(int clientId) { using (VedantaEntities ve = new VedantaEntities()) { return((from stds in ve.vw_Student_Lists where stds.ClientId == clientId select stds).ToList()); } }
public static List <vw_Branches> GetBranchesList(int clientId) { using (VedantaEntities ve = new VedantaEntities()) { return((from br in ve.vw_Branches where br.ClientId == clientId select br).ToList()); } }
public static int IndiaCountryCode = GetDefaultCountryCode(); //for India; public static int GetDefaultCountryCode() { using (VedantaEntities islObject = new VedantaEntities()) { int defaultCountryCode = 0; defaultCountryCode = islObject.Countries.FirstOrDefault(cn => cn.Name == "India").Id; return(defaultCountryCode); } }
public static List <vw_Employees> GetEmployeesList(string searchText, int?clientId, int?branchId) { using (VedantaEntities ve = new VedantaEntities()) { List <vw_Employees> evar = new List <vw_Employees>(); if (clientId == null && branchId == null) { evar = (from empls in ve.vw_Employees where (empls.EmployeeId.StartsWith(searchText) || empls.FirstName.StartsWith(searchText) || empls.LastName.StartsWith(searchText) || empls.City.StartsWith(searchText) || empls.BranchName.StartsWith(searchText) || empls.BranchCode.StartsWith(searchText) || empls.RankName.StartsWith(searchText) || empls.State.StartsWith(searchText) ) select empls).ToList(); } else { if (branchId == null) { evar = (from empls in ve.vw_Employees where empls.ClientId == clientId && (empls.EmployeeId.StartsWith(searchText) || empls.FirstName.StartsWith(searchText) || empls.LastName.StartsWith(searchText) || empls.City.StartsWith(searchText) || empls.BranchName.StartsWith(searchText) || empls.BranchCode.StartsWith(searchText) || empls.RankName.StartsWith(searchText) || empls.State.StartsWith(searchText) ) select empls).ToList(); } else { evar = (from empls in ve.vw_Employees where empls.ClientId == clientId && empls.BranchId == branchId && (empls.EmployeeId.StartsWith(searchText) || empls.FirstName.StartsWith(searchText) || empls.LastName.StartsWith(searchText) || empls.City.StartsWith(searchText) || empls.BranchName.StartsWith(searchText) || empls.BranchCode.StartsWith(searchText) || empls.RankName.StartsWith(searchText) || empls.State.StartsWith(searchText) ) select empls).ToList(); } } return(evar); } }
public static int GetRegionZoneId(int regionId) { using (VedantaEntities ve = new VedantaEntities()) { RegionalOffices rn = ve.RegionalOffices.FirstOrDefault(br => br.Id == regionId); int zoneId = (rn != null ? rn.ZonalOfficeId.Value : 0); return(zoneId); } }
public static List <vw_Employees> GetEmployeesList(int clientId, int branchId) { using (VedantaEntities ve = new VedantaEntities()) { return((from empl in ve.vw_Employees where empl.IsActive == true && empl.ClientId == clientId && empl.BranchId == branchId select empl).ToList()); } }