public ResultEntity GetPaymentHistory(GetPaymentEntity paymentEntity) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { SqlParameter[] sqlParameter = new SqlParameter[4]; sqlParameter[0] = new SqlParameter("@STU_CODE", paymentEntity.stuCode); sqlParameter[1] = new SqlParameter("@ACADEMIC_YEAR", paymentEntity.academicYear); sqlParameter[2] = new SqlParameter("@COURSE", paymentEntity.courseId); sqlParameter[3] = new SqlParameter("@REPORT_ID", Convert.ToInt32(paymentEntity.reportId)); DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_STUDENT_PAYMENT_HISTORY", sqlParameter); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity GetPaymentDeatils(GetPaymentEntity paymentEntity) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { // UserEntity objUserEntity = UserEntity.GetInstance(); SqlParameter[] sqlParameter = new SqlParameter[9]; sqlParameter[0] = new SqlParameter("@STU_CODE", paymentEntity.stuCode); sqlParameter[1] = new SqlParameter("@ACADEMIC_YEAR", paymentEntity.academicYear); sqlParameter[2] = new SqlParameter("@COURSE", paymentEntity.courseId); sqlParameter[3] = new SqlParameter("@CUSTOMER_ID", paymentEntity.customerId); sqlParameter[4] = new SqlParameter("@REPORT_ID", Convert.ToInt32(paymentEntity.reportId)); sqlParameter[5] = new SqlParameter("@RECIEPT_NO", SqlDbType.Char); sqlParameter[5].Direction = ParameterDirection.Output; sqlParameter[5].Size = 200; sqlParameter[6] = new SqlParameter("@PAYMENT_TYPE", SqlDbType.NVarChar); sqlParameter[6].Direction = ParameterDirection.Output; sqlParameter[6].Size = 2; sqlParameter[7] = new SqlParameter("@REMARKS", SqlDbType.NVarChar); sqlParameter[7].Direction = ParameterDirection.Output; sqlParameter[7].Size = 500; sqlParameter[8] = new SqlParameter("@PAYMENT_DATE", SqlDbType.NVarChar); sqlParameter[8].Direction = ParameterDirection.Output; sqlParameter[8].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_STUDENT_FEE_PAY_LIST", sqlParameter); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public JsonResult GetPaymentDeatils(GetPaymentEntity paymentEntity) { Account accountObj = new Account(); return(Json(accountObj.GetPaymentDeatils(paymentEntity))); }
public JsonResult GetPaymentHistory(GetPaymentEntity paymentEntity) { Account accountObj = new Account(); return(Json(accountObj.GetPaymentHistory(paymentEntity))); }