public int SaveExpenses(ExpensesModel model) { int result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@AutoExpensesID", model.AutoExpensesID); sqlService.AddParameter("@Particulars", model.Particulars); sqlService.AddParameter("@ExpensesBillNo", model.ExpensesBillNo); sqlService.AddParameter("@ShopName", model.ShopName); sqlService.AddParameter("@Quantity", model.Quantity); sqlService.AddParameter("@Amount", model.Amount); sqlService.AddParameter("@PaymentMode", model.PaymentMode); sqlService.AddParameter("@PurchasesDate", model.PurchasesDate); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_SaveExpenses"); result = (int)((short)sqlService.Parameters["@Result"].Value); } } catch (Exception ex) { throw ex; } return(result); }
public short DepositMonthlyFee(MonthlyFeeDepositModel monthlyFeeDeposit) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@ReceiptNo", monthlyFeeDeposit.FeeReceiptNo); sqlService.AddParameter("@AmountDeposit", monthlyFeeDeposit.AmountDeposit); sqlService.AddParameter("@AmountDues", monthlyFeeDeposit.AmountDues); sqlService.AddParameter("@FeeDepositDate", monthlyFeeDeposit.FeeDepositDate); sqlService.AddParameter("@FineDetailsXML", monthlyFeeDeposit.FineDetailsXML); sqlService.AddParameter("@Student_ID", monthlyFeeDeposit.Student_ID); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_DepositFee"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short SaveClassFeeSetting(Class_Fee_Setting_Model classFeeSettingModels) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@ClassFeeID", classFeeSettingModels.ClassFeeID); sqlService.AddParameter("@ClassID", classFeeSettingModels.ClassID); sqlService.AddParameter("@FeeTypeID", classFeeSettingModels.FeeTypeID); sqlService.AddParameter("@FeeAmount", classFeeSettingModels.FeeAmount); sqlService.AddParameter("@Active", classFeeSettingModels.Active); sqlService.AddParameter("@IsApplicableOnStaffChild", classFeeSettingModels.IsApplicableOnStaffChild); sqlService.AddParameter("@AmountForStaffChild", classFeeSettingModels.AmountForStaffChild); sqlService.AddParameter("@Academic_Year", classFeeSettingModels.AcademicYear); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_SaveClassFeeSetting"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short Save_Student_Fee_Info(long Student_ID, long?Receipt_No, string Student_Fee_Info_Type_Code, int Academic_Year, string MonthValuesDelimiterSeprated, int?Half_Tution_Fee_Amount) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Student_ID", Student_ID); sqlService.AddParameter("@Months_Comma_Seprated", MonthValuesDelimiterSeprated); sqlService.AddParameter("@Academic_Year", Academic_Year); sqlService.AddParameter("@Receipt_No", Receipt_No); sqlService.AddParameter("@Student_Fee_Info_Type_Code", Student_Fee_Info_Type_Code); sqlService.AddParameter("@Half_Tution_Fee_Amount", Half_Tution_Fee_Amount); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Save_Student_Fee_Info"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short USP_Save_Student_TC_Info(Student_TC_Model_Info model) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Sequence_No", model.Sequence_No); sqlService.AddParameter("@Student_ID", model.Student_ID); sqlService.AddParameter("@Reason_ID", model.Reason_ID); sqlService.AddParameter("@TC_Number", model.TC_Number); sqlService.AddParameter("@TC_Date", model.TC_Date); sqlService.AddParameter("@Academic_Year", model.Academic_Year); sqlService.AddParameter("@TC_Fee_Amount", model.TC_Fee_Amount); sqlService.AddOutputParameter("@Result_OUT", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Save_Student_TC_Info"); result = (short)sqlService.Parameters["@Result_OUT"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short Save_Admission_Fee(long Student_ID, long?Sequence_No_Student_Fee_Info, string Fee_Details_XML, int Academic_Year, string MonthValuesDelimiterSeprated, DateTime Admission_Fee_Date) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Student_ID", Student_ID); sqlService.AddParameter("@Sequence_No_Student_Fee_Info", Sequence_No_Student_Fee_Info); sqlService.AddParameter("@Fee_Details_XML", Fee_Details_XML); sqlService.AddParameter("@Months_Comma_Seprated", MonthValuesDelimiterSeprated); sqlService.AddParameter("@Academic_Year", Academic_Year); sqlService.AddParameter("@Admission_Fee_Date", Admission_Fee_Date); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Save_Admission_Fee"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short SaveSchoolDetails(SchoolModel schoolModel) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@SchoolID", schoolModel.SchoolID); sqlService.AddParameter("@SchoolName", schoolModel.SchoolName); sqlService.AddParameter("@Address", schoolModel.Address); sqlService.AddParameter("@PhoneNo", schoolModel.PhoneNo); sqlService.AddParameter("@ESTD", schoolModel.ESTD); sqlService.AddParameter("@AffiliationNo", schoolModel.AffiliationNo); sqlService.AddParameter("@SchoolNo", schoolModel.SchoolNo); sqlService.AddParameter("@SchoolLogo", schoolModel.SchoolLogo); sqlService.AddParameter("@IsReAdmission", schoolModel.IsReAdmission); sqlService.AddParameter("@ReAdmissionAmount", schoolModel.ReAdmissionAmount); sqlService.AddParameter("@FormTextLine1", schoolModel.FormTextLine1); sqlService.AddParameter("@FormTextLine2", schoolModel.FormTextLine2); sqlService.AddParameter("@FormTextLine3", schoolModel.FormTextLine3); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_SaveSchoolDetails"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public void Check_Is_Fee_Setting_Is_Saved(int Academic_Year, out string Is_Fee_Setting_Saved, out string Is_Class_Fee_Setting_Saved) { try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Academic_Year", Academic_Year); sqlService.AddOutputParameter("@Is_Fee_Setting_Saved", SqlDbType.Char, DBNull.Value, 1); sqlService.AddOutputParameter("@Is_Class_Fee_Setting_Saved", SqlDbType.Char, DBNull.Value, 1); sqlService.ExecuteSPNonQuery("dbo.USP_Check_Is_Fee_Setting_Is_Saved"); Is_Fee_Setting_Saved = (string)sqlService.Parameters["@Is_Fee_Setting_Saved"].Value; Is_Class_Fee_Setting_Saved = (string)sqlService.Parameters["@Is_Class_Fee_Setting_Saved"].Value; } } catch (Exception ex) { throw ex; } }
public short SaveStudentDetails(StudentViewModel studentViewModel) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@StudentID", studentViewModel.StudentModel.StudentID); sqlService.AddParameter("@AddressID", studentViewModel.AddressModel.AddressID); sqlService.AddParameter("@ExSchoolID", studentViewModel.ExSchoolModel.ExSchoolID); sqlService.AddParameter("@RegistrationNo", studentViewModel.StudentModel.RegistrationNo); sqlService.AddParameter("@FirstName", studentViewModel.StudentModel.FirstName); sqlService.AddParameter("@MiddleName", studentViewModel.StudentModel.MiddleName); sqlService.AddParameter("@LastName", studentViewModel.StudentModel.LastName); sqlService.AddParameter("@BirthDate", studentViewModel.StudentModel.BirthDate); sqlService.AddParameter("@RegistrationDate", studentViewModel.StudentModel.RegistrationDate); sqlService.AddParameter("@GenderID", studentViewModel.StudentModel.GenderID); sqlService.AddParameter("@FatherName", studentViewModel.StudentModel.FatherName); sqlService.AddParameter("@MotherName", studentViewModel.StudentModel.MotherName); sqlService.AddParameter("@IsTcSubmit", studentViewModel.StudentModel.IsTcSubmit); sqlService.AddParameter("@IsStaffChild", studentViewModel.StudentModel.IsStaffChild); sqlService.AddParameter("@IsActive", studentViewModel.StudentModel.IsActive); sqlService.AddParameter("@Address", studentViewModel.AddressModel.Address); sqlService.AddParameter("@Pincode", studentViewModel.AddressModel.Pincode); sqlService.AddParameter("@LandlineNumber", studentViewModel.AddressModel.LandlineNumber); sqlService.AddParameter("@MobileNo1", studentViewModel.AddressModel.MobileNo1); sqlService.AddParameter("@MobileNo2", studentViewModel.AddressModel.MobileNo2); sqlService.AddParameter("@ExSchoolName", studentViewModel.ExSchoolModel.SchoolName); sqlService.AddParameter("@ExSchoolTCNumber", studentViewModel.ExSchoolModel.TCNumber); sqlService.AddParameter("@EnrollmentClassID", studentViewModel.ExSchoolModel.EnrollmentClass); sqlService.AddParameter("@ExSchoolAddress", studentViewModel.ExSchoolModel.Address); sqlService.AddParameter("@ExSchoolContactNo", studentViewModel.ExSchoolModel.ContactNo); sqlService.AddParameter("@CurrentClass", studentViewModel.StudentModel.CurrentClass); sqlService.AddParameter("@CurrentSection", studentViewModel.StudentModel.CurrentSection); sqlService.AddParameter("@ExSchoolTCImage", (studentViewModel.ExSchoolModel.TCImage == null) ? SqlBinary.Null : studentViewModel.ExSchoolModel.TCImage); sqlService.AddParameter("@StudentImage", (studentViewModel.StudentModel.StudentImage == null) ? SqlBinary.Null : studentViewModel.StudentModel.StudentImage); sqlService.AddParameter("@TCFileType", studentViewModel.ExSchoolModel.TCFileType); sqlService.AddParameter("@CountryID", studentViewModel.StudentModel.CountryID); sqlService.AddParameter("@ReligionID", studentViewModel.StudentModel.ReligionID); sqlService.AddParameter("@CasteID", studentViewModel.StudentModel.CasteID); sqlService.AddParameter("@TransportRouteID", studentViewModel.StudentModel.TransportRouteID); sqlService.AddParameter("@Is_RTE_Student", studentViewModel.StudentModel.Is_RTE_Student); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Save_Registration_Details"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public string IsMonthlyFeeGenerated(int CrrentAcademicYear, out int LastMonthNo) { string text = string.Empty; string result; using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Academic_Year", CrrentAcademicYear); sqlService.AddOutputParameter("@Last_Month_No", SqlDbType.SmallInt); text = sqlService.ExecuteSPScalar("dbo.USP_IsMonthlyFeeGenerated"); LastMonthNo = (int)((short)sqlService.Parameters["@Last_Month_No"].Value); result = text; } return(result); }
public string Update_SMS_Status_All_Class(string SMS_ID) { try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@SMS_ID", SMS_ID); sqlService.AddOutputParameter("@Result_OUT", SqlDbType.VarChar, 10); sqlService.ExecuteSPNonQuery("dbo.USP_Update_SMS_Status_All_Class"); return((string)sqlService.Parameters["@Result_OUT"].Value); } } catch (Exception ex) { throw ex; } }
public void Check_Class_Fee_Setting_For_Previous_Academic_Year(int Academic_Year, out string Is_Record_Exists_Out) { try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Academic_Year", Academic_Year); sqlService.AddOutputParameter("@Is_Record_Exists_OUT", SqlDbType.Char, DBNull.Value, 1); sqlService.ExecuteSPNonQuery("dbo.USP_CHECK_CLASS_FEE_SETTING_FOR_PREVIOUS_ACADEMIC_YEAR"); Is_Record_Exists_Out = (string)sqlService.Parameters["@Is_Record_Exists_OUT"].Value; } } catch (Exception ex) { throw ex; } }
public string Log_SMS_Individual(string Mobile_Number, string SMS_Text) { try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@SMS_Text", SMS_Text); sqlService.AddParameter("@Mobile_Number", Mobile_Number); sqlService.AddOutputParameter("@Result_OUT", SqlDbType.VarChar, 10); sqlService.ExecuteSPNonQuery("dbo.USP_Log_SMS_Individual"); return((string)sqlService.Parameters["@Result_OUT"].Value); } } catch (Exception ex) { throw ex; } }
public string Is_Valid_Fee_Receipt_No(long Fee_Receipt_No_IN) { string result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Fee_Receipt_No_IN", Fee_Receipt_No_IN); sqlService.AddOutputParameter("@Return_OUT", SqlDbType.Char, DBNull.Value, 1); sqlService.ExecuteSPNonQuery("dbo.USP_Is_Valid_Fee_Receipt_No"); result = (string)sqlService.Parameters["@Return_OUT"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short SavePurchasesFee(string purchasesFeeXML) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@PurchasesFeeXML", purchasesFeeXML); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_SavePurchasesFee"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short Copy_Class_Fee_Setting(int Academic_Year) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Academic_Year", Academic_Year); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.Usp_Copy_Class_Fee_Setting"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public int DeleteExpenses(long ExpensesID) { int result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@AutoExpensesID", ExpensesID); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_DeleteExpenses"); result = (int)((short)sqlService.Parameters["@Result"].Value); } } catch (Exception ex) { throw ex; } return(result); }
public short Delete_Advance_Pay(long Receipt_No) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Receipt_No", Receipt_No); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Delete_Advance_Pay"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short Delete_TC_Details(long?Student_ID) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Student_ID", Student_ID); sqlService.AddOutputParameter("@Result_OUT", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Delete_TC_Details"); result = (short)sqlService.Parameters["@Result_OUT"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short Multiple_Receipt_Fee_Paid(string Fee_Details_xml) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Fee_Details_xml_IN", Fee_Details_xml); sqlService.AddOutputParameter("@Result_OUT", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Multiple_Receipt_Fee_Paid"); result = (short)sqlService.Parameters["@Result_OUT"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short TakeBackUp(string filePath, string dbName) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@FilePath", filePath); sqlService.AddParameter("@DBName", dbName); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_DatabaseBackUp"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short GenerateMonthlyFee(string Months, int AcademicYear) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@MonthValuesDelimiterSeprated", Months); sqlService.AddParameter("@AcademicYear", AcademicYear); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_GenerateMonthlyFee_Multiple_Months"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short Update_Deposit_Date(long Fee_Transaction_ID_IN, DateTime New_Deposit_Date_IN) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@Fee_Transaction_ID_IN", Fee_Transaction_ID_IN); sqlService.AddParameter("@New_Deposit_Date_IN", New_Deposit_Date_IN); sqlService.AddOutputParameter("@Result_OUT", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_Update_Deposit_Date"); result = (short)sqlService.Parameters["@Result_OUT"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short SaveTransportRoute(TransportRouteModel transportModel) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@RouteID", transportModel.RouteID); sqlService.AddParameter("@RouteName", transportModel.RouteName); sqlService.AddParameter("@Amount", transportModel.Amount); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_SaveTransportRoute"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public short SaveFeeType(FeeTypeModel feeTypeModel) { short result; try { using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@FeeTypeID", feeTypeModel.FeeTypeID); sqlService.AddParameter("@FeeType", feeTypeModel.FeeType); sqlService.AddParameter("@Active", feeTypeModel.Active); sqlService.AddParameter("@IsPurchasable", feeTypeModel.IsPurchasable); sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt); sqlService.ExecuteSPNonQuery("dbo.USP_SaveFeeType"); result = (short)sqlService.Parameters["@Result"].Value; } } catch (Exception ex) { throw ex; } return(result); }
public StudentFineViewModel GetStudentFineDetails(StudentFineViewModel studentFine, out short isBillPaid) { StudentFineViewModel studentFineViewModel; using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings)) { sqlService.AddParameter("@ClassID", SqlDbType.SmallInt, studentFine.ClassID); sqlService.AddParameter("@SectionID", SqlDbType.SmallInt, studentFine.SectionID); sqlService.AddParameter("@FineDate", SqlDbType.Date, studentFine.FineDate); sqlService.AddParameter("@FineTypeID", SqlDbType.SmallInt, studentFine.FineTypeID); sqlService.AddOutputParameter("@ISBillPaid", SqlDbType.SmallInt); using (SqlDataReader sqlDataReader = sqlService.ExecuteSPReader("dbo.USP_GetStudentFineDetails")) { this._studentFineViewModel = new StudentFineViewModel(); this._studentFineViewModel.ListStudent = sqlDataReader.MapToList <StudentFineViewModel>(); sqlDataReader.NextResult(); this._studentFineViewModel.ListStudentFine = sqlDataReader.MapToList <StudentFineViewModel>(); sqlDataReader.NextResult(); isBillPaid = (short)sqlService.Parameters["@ISBillPaid"].Value; studentFineViewModel = this._studentFineViewModel; } } return(studentFineViewModel); }