public DTO.LABURNUM.COM.StudentFeeModel SearchAdmissionFeeReceiptDataByDetailId(DTO.LABURNUM.COM.StudentFeeDetailModel model) { if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password)) { API.LABURNUM.COM.StudentFeeDetail dbstudentfeeDetails = new FrontEndApi.StudentFeeDetailApi().GetStudentFeeDetailByID(model.StudentFeeDetailId); DTO.LABURNUM.COM.StudentFeeModel studentFeeModel = new StudentFeeHelper(new FrontEndApi.StudentFeeApi().GetStudentFeeByAdvanceSearch(new DTO.LABURNUM.COM.StudentFeeModel() { StudentId = dbstudentfeeDetails.StudentId, ClassId = dbstudentfeeDetails.ClassId, SectionId = dbstudentfeeDetails.SectionId })).MapSingle(); studentFeeModel.PendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault(); studentFeeModel.CashPaidAmount = dbstudentfeeDetails.CashPaidAmount.GetValueOrDefault(); studentFeeModel.ChequePaidAmount = dbstudentfeeDetails.ChequePaidAmount.GetValueOrDefault(); studentFeeModel.ChequeNumber = dbstudentfeeDetails.ChequeNumber; studentFeeModel.ChequeDate = dbstudentfeeDetails.ChequeDate; return(studentFeeModel); } else { return(null); } }
public DTO.LABURNUM.COM.StudentFeeModel SearchAdmissionFeeReceiptData(DTO.LABURNUM.COM.StudentFeeModel model) { if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password)) { DTO.LABURNUM.COM.StudentFeeModel studentFeeModel = new StudentFeeHelper(new FrontEndApi.StudentFeeApi().GetStudentFeeById(model.StudentFeeId)).MapSingle(); API.LABURNUM.COM.StudentFeeDetail dbstudentfeeDetails = new FrontEndApi.StudentFeeDetailApi().GetFeePaidDetailDuringAdmission(studentFeeModel.StudentId, studentFeeModel.ClassId, studentFeeModel.SectionId, studentFeeModel.AcademicYearId); studentFeeModel.PendingFee = dbstudentfeeDetails.PendingFee.GetValueOrDefault(); studentFeeModel.CashPaidAmount = dbstudentfeeDetails.CashPaidAmount.GetValueOrDefault(); studentFeeModel.ChequePaidAmount = dbstudentfeeDetails.ChequePaidAmount.GetValueOrDefault(); studentFeeModel.ChequeNumber = dbstudentfeeDetails.ChequeNumber; studentFeeModel.ChequeDate = dbstudentfeeDetails.ChequeDate; return(studentFeeModel); } else { return(null); } }
public dynamic SearchFeeResult(DTO.LABURNUM.COM.FeeReportingModel model) { if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password)) { if (model.ClassId == 0 && model.SectionId == 0 && model.StudentId == 0 && model.StartDate.Year == 0001 && model.EndDate.Year == 0001) { return(GetApiResponseModel("Search Creteria Cannot Be Blank.", false, null)); } DTO.LABURNUM.COM.StudentFeeModel studentFeeModel = new Controllers.ReportsController().GetStudentFeeModel(model); List <DTO.LABURNUM.COM.StudentFeeModel> studentFeeList = new StudentFeeHelper(new FrontEndApi.StudentFeeApi().GetStudentFeeByAdvanceSearch(studentFeeModel)).Map(); return(GetApiResponseModel("Successfully Performed.", true, studentFeeList)); } else { return(GetApiResponseModel("Api Access User Name or Password Invalid.", false, null)); } }
private void GetFeeAmountFrosmb() { ddlSessionName.Items.Clear(); SqlConnection con = new SqlConnection(cs); SqlCommand csm = new SqlCommand("select SessionId from dbo.MasterFee where YearOfAdmission = @yearofadmission and DepttId = @depttid", con); csm.Parameters.AddWithValue("@yearofadmission", lblBatch.Text); csm.Parameters.AddWithValue("@depttid", FeeHelper2.ConvertDepartmentNameToId(lblDepttName.Text)); try { ListItem newItem = new ListItem(); newItem.Text = "<Select Session>"; newItem.Value = "0"; ddlSessionName.Items.Add(newItem); con.Open(); SqlDataReader rdr = csm.ExecuteReader(); while (rdr.Read()) { newItem = new ListItem(); newItem.Text = StudentFeeHelper.ConvertSessionIdToSessionName(rdr["SessionId"].ToString()); ddlSessionName.Items.Add(newItem); //ddlSessionName.DataValueField = rdr["SessionId"].ToString(); } rdr.Close(); } catch (Exception) { } finally { con.Close(); } }