public DataMessage GetOfficerVillages(string officerCode) { var sSQL = @"SELECT LV.LocationId,code,LW.locationname Ward,LV.LocationName Village,LW.LocationID WardID FROM tblOfficerVillages OV INNER JOIN tblOfficer O ON OV.OfficerId = O.OfficerID AND O.ValidityTo IS NULL AND OV.ValidityTo IS NULL LEFT JOIN tblLocations LV ON LV.LocationId = OV.LocationId AND LV.LocationType = 'V' AND LV.ValidityTo IS NULL LEFT JOIN tblLocations LW ON LW.LocationId = LV.ParentLocationId AND LW.ValidityTo IS NULL WHERE O.Code = @EnrollmentOfficerCode" ; DataHelper helper = new DataHelper(Configuration); SqlParameter[] sqlParameters = { new SqlParameter("@EnrollmentOfficerCode", officerCode) }; DataMessage message; try { var response = helper.GetDataTable(sSQL, sqlParameters, System.Data.CommandType.Text); message = new ImisApiResponse(0, false, response, 0).Message; } catch (Exception e) { message = new ImisApiResponse(e).Message; } return(message); }
public DataMessage MatchPayment(MatchModel model) { SqlParameter[] sqlParameters = { new SqlParameter("@PaymentID", model.internal_identifier), new SqlParameter("@AuditUserId", model.audit_user_id) }; DataMessage message; try { DataSet data = dh.FillDataSet("uspMatchPayment", sqlParameters, CommandType.StoredProcedure); //bool error = false; DataTable dt = new DataTable(); if (data.Tables.Count > 0) { dt = data.Tables[data.Tables.Count - 1]; } message = new MatchPayResponse(dh.ReturnValue, false, dt, (int)Language).Message; if (model.internal_identifier != null && !message.ErrorOccured) { GetPaymentInfo(model.internal_identifier.ToString()); } } catch (Exception e) { message = new ImisApiResponse(e).Message; } return(message); }
public DataMessage MatchPayment(MatchModel model) { SqlParameter[] sqlParameters = { new SqlParameter("@PaymentID", model.internal_identifier), new SqlParameter("@AuditUserId", model.audit_user_id) }; DataMessage message; try { DataSet data = dh.FillDataSet("uspMatchPayment", sqlParameters, CommandType.StoredProcedure); //bool error = false; DataTable dt = new DataTable(); if (data.Tables.Count > 0) { dt = data.Tables[data.Tables.Count - 1]; // error = true; // if (dt.Rows.Count > 0) // { // var firstRow = dt.Rows[0]; // if (Convert.ToInt32(firstRow["PaymentMatched"]) > 0) // { // error = false; // } // } // else // { // error = true; // } } message = new MatchPayResponse(dh.ReturnValue, false, dt, (int)Language).Message; if (model.internal_identifier != 0 && !message.ErrorOccured) { GetPaymentInfo(model.internal_identifier); } } catch (Exception e) { message = new ImisApiResponse(e).Message; } return(message); }