public static int ProocessNewStudentAddmission(Students newStudent, Admissions newAdmission, FeeCollections newFeeCollection) { using (VedantaEntities ve = new VedantaEntities()) { Students oldStudent = ve.Students.FirstOrDefault(st => st.ID == newStudent.ID); int newStudentId = 0; int oldStudentId = 0; //Add A New Student Record in DataBase if that student does not exists if (oldStudent == null) { newStudent.CreatedDate = DateTime.Now.Date; ve.AddToStudents(newStudent); ve.SaveChanges(); newStudentId = newStudent.ID; } else { oldStudentId = oldStudent.ID; } //If Student is already enrolled with us then no need to add new record for same student if (newStudentId == 0 && oldStudentId > 0) { newStudentId = oldStudentId; } if (newStudentId > 0) { newAdmission.StudentId = newStudentId; Admissions oldAdmission = ve.Admissions.FirstOrDefault(ad => ad.StudentId == newStudentId && ad.CourseId == newAdmission.CourseId); if (oldAdmission == null) { ve.AddToAdmissions(newAdmission); int admResult = ve.SaveChanges(); return(admResult); //if (admResult > 0) //Admission of Student done successfully. //{ // newFeeCollection.AdmissionId = newAdmission.Id; // ve.AddToFeeCollections(newFeeCollection); // return ve.SaveChanges(); //Admission Fee Paid successfully. //} //else // return -2; } else { return(-2); //Student Record Entered but failed to take Admission of student. } } else { return(-1); //Student Record not entered; } } }
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 UpdateAsset(int id, Assets asset) { try { using (VedantaEntities ve = new VedantaEntities()) { Assets updated = ve.Assets.FirstOrDefault(jc => jc.Id == id); if (updated != null) { updated.Code = asset.Code; updated.Name = asset.Name; updated.PurchasedDate = asset.PurchasedDate; updated.LastRepaireDate = asset.LastRepaireDate; updated.LastAuditDate = asset.LastAuditDate; updated.IsWorking = asset.IsWorking; updated.BranchId = asset.BranchId; updated.WarrantyExpiryDate = asset.WarrantyExpiryDate; updated.AMC_Reporesntative = asset.AMC_Reporesntative; updated.AMC_Phone = asset.AMC_Phone; updated.AMC_Email = asset.AMC_Email; updated.AMC_Address = asset.AMC_Address; return(ve.SaveChanges()); } } } catch { return(0); } return(0); }
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 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 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 int PayStudentFees(FeeCollections newFees) { using (VedantaEntities ve = new VedantaEntities()) { ve.AddToFeeCollections(newFees); return(ve.SaveChanges()); } }
public static int SaveClientSettings(ClientSettings clientSetting) { try { using (VedantaEntities ve = new VedantaEntities()) { ClientSettings oldSetting = ve.ClientSettings.FirstOrDefault(cl => cl.ClientId == clientSetting.ClientId); if (oldSetting != null) { //updating the existing settings oldSetting.IsEducationServiceAvailable = clientSetting.IsEducationServiceAvailable; oldSetting.IsAssetServiceAvailable = clientSetting.IsAssetServiceAvailable; oldSetting.IsBusServiceAvailable = clientSetting.IsBusServiceAvailable; oldSetting.IsCerificateServiceAvailable = clientSetting.IsCerificateServiceAvailable; oldSetting.IsDebtorCreditotsServiceAvailable = clientSetting.IsDebtorCreditotsServiceAvailable; oldSetting.IsDemoClassServiceAvailable = clientSetting.IsDemoClassServiceAvailable; oldSetting.IsEnquiryServiceAvailable = clientSetting.IsEnquiryServiceAvailable; oldSetting.IsHostelServiceAvailable = clientSetting.IsHostelServiceAvailable; oldSetting.IsJobServiceAvailable = clientSetting.IsJobServiceAvailable; oldSetting.IsOfficeExpenseServiceAvailable = clientSetting.IsOfficeExpenseServiceAvailable; oldSetting.IsSMSServiceAvailable = clientSetting.IsSMSServiceAvailable; oldSetting.IsStudyMaterialServiceAvailable = clientSetting.IsStudyMaterialServiceAvailable; oldSetting.MaximumNumberOfCourseBrandsPerSchool = clientSetting.MaximumNumberOfCourseBrandsPerSchool; oldSetting.MaximumNumberOfUsersPerSchool = clientSetting.MaximumNumberOfUsersPerSchool; oldSetting.SMSurl = clientSetting.SMSurl; oldSetting.SMSUserId = clientSetting.SMSUserId; oldSetting.SMSPwd = clientSetting.SMSPwd; return(ve.SaveChanges()); } else { //create new settings ve.AddToClientSettings(clientSetting); return(ve.SaveChanges()); } } } catch { return(0); } }
//============================================================== #region SMS public static int SendSMS(SMSNotices newSmsNotice) { using (VedantaEntities ve = new VedantaEntities()) { if (newSmsNotice != null) { ve.AddToSMSNotices(newSmsNotice); return(ve.SaveChanges()); } return(0); } }
public static int DeletePaymentsById(int id) { using (VedantaEntities ve = new VedantaEntities()) { Payments oldPayment = ve.Payments.FirstOrDefault(cs => cs.Id == id); if (oldPayment != null) { ve.DeleteObject(oldPayment); return(ve.SaveChanges()); } return(0); } }
public static int DeleteEmployee(int clientId, string empId) { using (VedantaEntities ve = new VedantaEntities()) { Employees oldEmp = ve.Employees.FirstOrDefault(e => empId.Equals(e.EmployeeId, StringComparison.OrdinalIgnoreCase)); if (oldEmp != null) { oldEmp.IsActive = false; return(ve.SaveChanges()); } return(0); } }
public static int CreateAsset(Assets asset) { try { using (VedantaEntities ve = new VedantaEntities()) { ve.AddToAssets(asset); return(ve.SaveChanges()); } } catch (Exception) { return(0); } }
public static int CreateNewBatch(Batches newBatch) { try { using (VedantaEntities ve = new VedantaEntities()) { ve.AddToBatches(newBatch); return(ve.SaveChanges()); } } catch (Exception) { return(0); } }
public static int UpdateFeeCollection(FeeCollections newFee) { using (VedantaEntities ve = new VedantaEntities()) { FeeCollections oldFee = ve.FeeCollections.FirstOrDefault(st => st.Id == newFee.Id); if (oldFee == null) { return(-1);//Admission record not found. } newFee.AdmissionId = oldFee.AdmissionId; var updatedFee = ve.ApplyCurrentValues(oldFee.GetType().Name, newFee); return(ve.SaveChanges()); } }
public static int CreateClient(Clients client) { try { using (VedantaEntities ve = new VedantaEntities()) { ve.AddToClients(client); return(ve.SaveChanges()); } } catch (Exception) { return(0); } }
public static int AddBranch(Branches newBr) { using (VedantaEntities ve = new VedantaEntities()) { Branches oldBr = ve.Branches.FirstOrDefault(e => e.BranchCode == newBr.BranchCode && e.ClientId == newBr.ClientId); if (oldBr == null) { newBr.IsActive = true; ve.AddToBranches(newBr); return(ve.SaveChanges()); } else { return(-1); } } }
public static int DeleteLedgerByLedgerId(int id) { using (VedantaEntities islObject = new VedantaEntities()) { Payments payment = islObject.Payments.FirstOrDefault(pmt => pmt.ExpenseHeadId == id); if (payment == null) { EXPENSESHEAD ledger = islObject.EXPENSESHEAD.FirstOrDefault(rk => rk.Id == id); if (ledger != null) { islObject.DeleteObject(ledger); return(islObject.SaveChanges()); } } return(0); } }
public static int ActivateBranch(int id, bool isActivating = false) { using (VedantaEntities ve = new VedantaEntities()) { Branches oldBr = ve.Branches.FirstOrDefault(e => e.Id == id); if (oldBr != null) { oldBr.IsActive = isActivating; oldBr.LastUpdatedDate = DateTime.Now.Date; return(ve.SaveChanges()); } else { return(-1); } } }
public static int UpdateStudentDetails(Students newStudent) { using (VedantaEntities ve = new VedantaEntities()) { Students oldStudent = ve.Students.FirstOrDefault(st => st.ID == newStudent.ID); if (oldStudent == null) { return(-1);//Student record not found. } //Updating Student Details //oldStudent.Age = newStudent.Age; //oldStudent.Cell = newStudent.Cell; //oldStudent.City = newStudent.City; //oldStudent.CountryId = newStudent.CountryId; //oldStudent.DOB = newStudent.DOB; //oldStudent.Email = newStudent.Email; //oldStudent.FamilyIncomeSlotId = newStudent.FamilyIncomeSlotId; //oldStudent.FatherName = newStudent.FatherName; //oldStudent.FirstName = newStudent.FirstName; //oldStudent.Gender = newStudent.Gender; //oldStudent.LastName = newStudent.LastName; //oldStudent.MaritalStatusId = newStudent.MaritalStatusId; //oldStudent.MiddleName = newStudent.MiddleName; //oldStudent.MotherName = newStudent.MotherName; //oldStudent.Mothertoungue = newStudent.Mothertoungue; //oldStudent.Nationality = newStudent.Nationality; //oldStudent.OccupationId = newStudent.OccupationId; //oldStudent.PAN = newStudent.PAN; //oldStudent.PassportNo = newStudent.PassportNo; //oldStudent.Phone = newStudent.Phone; //oldStudent.QualificationId = newStudent.QualificationId; //oldStudent.Religion = newStudent.Religion; //oldStudent.StateId = newStudent.StateId; //oldStudent.Street = newStudent.Street; //oldStudent.Street2 = newStudent.Street2; //oldStudent.UIDNo = newStudent.UIDNo; //oldStudent.Zip = newStudent.Zip; var updatedStudents = ve.ApplyCurrentValues(oldStudent.GetType().Name, newStudent); return(ve.SaveChanges()); //return 1; //return ve.AcceptAllChanges(oldStudent.GetType().Name, newStudent); } }
public static int ActivateClient(int id, bool isActive = false) { try { using (VedantaEntities ve = new VedantaEntities()) { Clients updated = ve.Clients.FirstOrDefault(cl => cl.Id == id); if (updated != null) { return(ve.SaveChanges()); } } } catch { return(0); } return(0); }
public static int UpdateBranchDetails(Branches newBr) { using (VedantaEntities ve = new VedantaEntities()) { Branches oldBr = ve.Branches.FirstOrDefault(e => e.Id == newBr.Id); if (oldBr != null) { oldBr.BranchTypeId = newBr.BranchTypeId; oldBr.BranchCode = newBr.BranchCode; oldBr.BranchName = newBr.BranchName; oldBr.Address1 = newBr.Address1; oldBr.Address2 = newBr.Address2; oldBr.City = newBr.City; oldBr.PIN = newBr.PIN; oldBr.StateId = newBr.StateId; oldBr.CountryId = newBr.CountryId; oldBr.Phones = newBr.Phones; oldBr.Email = newBr.Email; oldBr.Fax = newBr.Fax; if (newBr.RegionalOfficeId != null) { oldBr.RegionalOfficeId = newBr.RegionalOfficeId; } if (newBr.ZonalOfficeId != null) { oldBr.ZonalOfficeId = newBr.ZonalOfficeId; } oldBr.CreatedDate = newBr.CreatedDate; oldBr.IsActive = newBr.IsActive; oldBr.LastUpdatedDate = DateTime.Now.Date; oldBr.Remarks = newBr.Remarks; oldBr.Logo = newBr.Logo; oldBr.ContentType = newBr.ContentType; return(ve.SaveChanges()); } else { return(-1); } } }
public static int CloseBranch(Branches newBr) { using (VedantaEntities ve = new VedantaEntities()) { Branches oldBr = ve.Branches.FirstOrDefault(e => e.Id == newBr.Id); if (oldBr != null) { oldBr.IsActive = newBr.IsActive; oldBr.LastUpdatedDate = DateTime.Now.Date; oldBr.Remarks = newBr.Remarks; oldBr.ClosingDate = newBr.ClosingDate; return(ve.SaveChanges()); } else { return(-1); } } }
//===================================================================== #region Ledgers public static int CreateLedger(EXPENSESHEAD ledger) { using (VedantaEntities deo = new VedantaEntities()) { EXPENSESHEAD oldLedger = deo.EXPENSESHEAD.FirstOrDefault(exp => exp.ClientId == ledger.ClientId && ledger.CODE.Equals(exp.CODE, StringComparison.OrdinalIgnoreCase)); if (oldLedger != null) { return(0); } else { if (ledger != null) { deo.AddToEXPENSESHEAD(ledger); return(deo.SaveChanges()); } } } return(0); }
public static int CreatePayment(Payments payment) { using (VedantaEntities deo = new VedantaEntities()) { if (payment != null) { Payments oldPayments = deo.Payments.FirstOrDefault(py => py.BranchId == payment.BranchId && payment.Date == py.Date && payment.VoucherNo.Equals(py.VoucherNo, StringComparison.OrdinalIgnoreCase)); if (oldPayments == null) { deo.AddToPayments(payment); return(deo.SaveChanges()); } else { return(-1); } } } return(0); }
public static int UpdateClient(int id, Clients client, bool isAdmin = false) { try { using (VedantaEntities ve = new VedantaEntities()) { Clients updated = ve.Clients.FirstOrDefault(cl => cl.Id == id); if (updated != null) { updated.Name = client.Name; updated.Lane = client.Lane; updated.Street = client.Street; updated.City = client.City; updated.StateId = client.StateId; updated.Zip = client.Zip; updated.Phone1 = client.Phone1; updated.Phone2 = client.Phone2; updated.Cell = client.Cell; updated.Email = client.Email; updated.Website = client.Website; updated.LastUpdated = DateTime.Now; updated.Logo = client.Logo; updated.ContentType = updated.ContentType; if (isAdmin) { updated.CreateDate = client.CreateDate; updated.ContractStartDate = client.ContractStartDate; updated.ContractEndDate = client.ContractEndDate; } return(ve.SaveChanges()); } } } catch { return(0); } return(0); }
public static int UpdateEmployee(Employees emp) { using (VedantaEntities ve = new VedantaEntities()) { if (emp != null) { var oldEmp = ve.Employees.FirstOrDefault(e => emp.EmployeeId.Equals(e.EmployeeId)); if (oldEmp != null) { if (emp.IsActive == null) { emp.IsActive = oldEmp.IsActive; emp.LastUpdated = DateTime.Now.Date; } ve.ApplyCurrentValues(oldEmp.GetType().Name, emp); return(ve.SaveChanges()); } //var clientWithNewValue = entity.Clients.FirstOrDefault(c => c.Id == oldClient.Id); } return(0); } }
public static int CreateCourseBrand(CourseBrands courseBrand) { try { using (VedantaEntities ve = new VedantaEntities()) { CourseBrands oldBrand = ve.CourseBrands.FirstOrDefault(cb => cb.BranchId == courseBrand.BranchId && courseBrand.Name.Equals(cb.Name, StringComparison.OrdinalIgnoreCase)); if (oldBrand == null) { ve.AddToCourseBrands(courseBrand); return(ve.SaveChanges()); } else { return(0); } } } catch (Exception) { return(0); } }
public static int CreateCourse(Courses course) { try { using (VedantaEntities islObject = new VedantaEntities()) { Courses oldCourse = islObject.Courses.FirstOrDefault(c => c.ClientId == course.ClientId && c.CourseBrandId == course.CourseBrandId && course.CourseCode.Equals(c.CourseCode, StringComparison.OrdinalIgnoreCase)); if (oldCourse == null) { islObject.AddToCourses(course); return(islObject.SaveChanges()); } else { return(0); } } } catch (Exception) { return(0); } }
public static int UpdateLedger(int ledgerId, EXPENSESHEAD newledger) { using (VedantaEntities deo = new VedantaEntities()) { EXPENSESHEAD oldLedger = deo.EXPENSESHEAD.FirstOrDefault(exp => newledger.CODE.Equals(exp.CODE, StringComparison.OrdinalIgnoreCase)); if (oldLedger != null) { EXPENSESHEAD oldledger = deo.EXPENSESHEAD.FirstOrDefault(rk => rk.Id == ledgerId); if (oldledger != null && newledger != null) { oldledger.CODE = newledger.CODE; oldledger.NAME = newledger.NAME; oldledger.LedgerTypeId = newledger.LedgerTypeId; oldledger.OP_BAL = newledger.OP_BAL; return(deo.SaveChanges()); } } else { return(0); } } return(0); }
public static int UpdateAdmissionDetails(Admissions newAdmission) { using (VedantaEntities ve = new VedantaEntities()) { Admissions oldAdmission = ve.Admissions.FirstOrDefault(st => st.Id == newAdmission.Id); if (oldAdmission == null) { return(-1);//Admission record not found. } FeeCollections fee = ve.FeeCollections.FirstOrDefault(fe => fe.AdmissionId == newAdmission.Id && fe.ManualreceiptNumber.Equals(oldAdmission.ManualReceiptNumber, StringComparison.OrdinalIgnoreCase)); if (fee != null) { fee.Amount = newAdmission.DownPayment; fee.Description = newAdmission.Description; fee.TotalReceived = newAdmission.DownPayment; fee.PaymentDate = newAdmission.AdmissionDate; fee.PaymentHeadId = 1; fee.PaymentModeId = newAdmission.PaymentModeId; } newAdmission.StudentId = oldAdmission.StudentId; var updatedAdmission = ve.ApplyCurrentValues(oldAdmission.GetType().Name, newAdmission); return(ve.SaveChanges()); } }